[Asterisk-Users] OT: Best DB

[Walt Reed]

On Thu, Mar 10, 2005 at 01:04:35AM -0700, Forrest W. Christian said:
> I understand that PostgreSql has also gotten faster than it used to be.

It's interesting. Just yesterday I was saying that we use both MySQL and
Postgres here, and that we were probably going to move everything to
postgres just to consolidate.

Now one of our lead engineers has done some performance testing last
night for our
app and found MySQL to be 8 to 100 times faster for all but one of our
operations (combination of ~80% reads, 20% writes on the InnoDB table
type.) His testing basically increased the load until performance was
unacceptable.

This is with lots of optimizations on Postgres (the current DB for the
app) and none on MySQL. Needless to say, we now need to re-evaluate our
decision to move everything to Postgres.

In the end, it all comes down to knowing exactly what features you need
for your app, how your specific app performs on each DB, what you need
for support, etc. As Forrest mentioned, write DB independant code and
then you can easily choose the DB that is best for your app. 2 years for
now, you may find a need to switch DB's.