Screaming Penguin

There is a new article at PHPBuilder about the open source database debate. Since the only real players in the open source db arena are MySQL and PostGRES, this debate is really MySQL v PostGRES. It appears, according to tests Tim Perdue (PHPBuilder guru) has done on Sourceforge and Geocrawler that the new rev 7.1 of PostGRES actually beats MySQL in performace and as always supports more standardized SQL features (sub-selects, transactions, foreign keys.) In all fairness, MySQL is planning most of these features in new revs, and traditionally postGRES has been slower because of more overhead associated with these items, but all of that may be changing. In the test a 10GB database was tested on both MySQL and PostGRES and postGRES outperformed and outfeatured MySQL. Hmmmmm. Check out the article for further details, and do your own tests with your app for optimum performance.   More on the Postgres vs. MySQL debate at PHPBuilder