Hi Nikos, PostgreSQL was always most reliable for me, I had some post-crash data loss experience with 3.x series that thankfully kept me away from the mess called MySQL since then. With recent improvements after 8.2, PostgreSQL is performing either very close to MySQL or outperforming it in some cases.
SQLite is probably another good choice if you don't plan scaling it up to multiple bearerbox processes writing to the same database. libsdb is essentially a multiplexing database abstraction layer if I'm not wrong; so that's probably not what you want. And please, I beg you, don't use Oracle. Using Oracle should be made a crime against humanity in as many countries as possible. -HTH On Thu, 2009-01-15 at 20:03 +0200, Nikos Balkanas wrote: > Hi, > > I am considering using a DB for DLR storage. Up till now I was using > internal DLRs. Of the many options supported, (Mysql, PostgresSQL, > Oracle, LibSdb, sqlbox, sqllite) which one would you consider best > suited for bulk SMS, in terms of performance and reliability. If you > could also give a one liner for your choice, it would be most > appreciated. I thing it is fair to say, that internal is the fastest > and least reliable of all. > > Thanx > Nikos -- Enver
