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. _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
