NetXMS Support Forum

Hello all,

I'm evaluating NetXMS since version 1.2.11 to substitute our current NMS (Xymon) with NetXMS.

Now I'm ready for the jump to production, but I have a big doubt about what DB backend to use.
In other words when do you suggest to use SQLite? And when do you suggest to NOT use SQLite?
Thanks in advance for your help.

Regards.
Massimo

SQLite is mostly for development or really small installations.
All other DB engines are production ready. In most installations we use PostgreSQL, with proper tuning it works pretty good — but decision is usually based on existing infrastructure or DBA experience.
Currently we fully support DB2, Informix, MSSQL, MySQL, Oracle, and PostgreSQL.

Hello Alex,

thank you for your prompt reply.

No doubts now.
I will use PostgreSQL (last release 9.3.4).

Any suggested proper specific tuning for it?

Check this presentation: http://www.slideshare.net/xzilla/the-essentialpostgresconf