And in fact I am currently migrating one of my web sites (in PHP3) from PostgreSQL to MySQL because MySQL is significantly faster and stable compared to PostgreSQL.
I used to be a fan of PostgreSQL, and always thought it was a more superior product than MySQL because of more completed SQL support. The web site I have been building has been running on PostgreSQL for more than a year now (from 6.4 to now at 6.5.3). As the amount of data grows larger, there are constantly problems with the backend DBM. The postmaster sigfaults every now and then, and for a couple of times I have to restore to backup because it refuses to function anymore. Most annoyingly, PostgreSQL still has the row size limit of 8k, which is just ridiculous for developing any application.
I have been running TWIG on the same host, and initially I used PostgreSQL as its backend. That was a big mistake because it takes around 5 seconds just to perform all the queries in a page! I then tried MySQL, and that makes a huge difference.
I do understand that MySQL does not support many nice features that I like from PostgreSQL, especially the subqueries and foreign keys. However, it is still a better DB for web based application.
Slashdot Mirror
Yeah. Consider that many P4 and Athlon motherboards and chipsets are actually manufactored in Taiwan/China...
And in fact I am currently migrating one of my web sites (in PHP3) from PostgreSQL to MySQL because MySQL is significantly faster and stable compared to PostgreSQL.
I used to be a fan of PostgreSQL, and always thought it was a more superior product than MySQL because of more completed SQL support. The web site I have been building has been running on PostgreSQL for more than a year now (from 6.4 to now at 6.5.3). As the amount of data grows larger, there are constantly problems with the backend DBM. The postmaster sigfaults every now and then, and for a couple of times I have to restore to backup because it refuses to function anymore. Most annoyingly, PostgreSQL still has the row size limit of 8k, which is just ridiculous for developing any application.
I have been running TWIG on the same host, and initially I used PostgreSQL as its backend. That was a big mistake because it takes around 5 seconds just to perform all the queries in a page! I then tried MySQL, and that makes a huge difference.
I do understand that MySQL does not support many nice features that I like from PostgreSQL, especially the subqueries and foreign keys. However, it is still a better DB for web based application.