You may want to consider other things...
MySQL adds complexity in that it has several database engines: MyISAM, InnoDB and MAXDB. All of which have different performance characteristics. MyISAM is very fast for databases with few transactions, but InnoDB is more comparable to Postgres in that it allows superior locking and foreign key integrity etc.
Although not appropriate for a speed comparison, you might want to note that the use of Mysql versions 4.0 upward now require commercial license for clients, which are no longer LGPL, whereas Postgres is free (BSD license). This makes transactions per dollar an interesting statistic when comparing the Postgres and MySql!
I look forward to seeing the results.
Howard Cole www.selestial.com
Rick Schumeyer wrote:
I’m interested in comparing the performance of postgresql and mysql
on various combinations of user loads and database sizes.
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
