On Tue, Jan 28, 2003 at 11:08:28AM -0800, Rick Moen wrote:
Quoting CJ Koh ([EMAIL PROTECTED]):In addition, Tim Purdue (sourceforge.net) has done some excellent work to compare MySQL and PostgreSQL. His investigation concluded that PostgreSQL was not only stronger in terms of database features, but was also able to completely outperform MySQL, particularly on complex queries. In particular, the main reason for this was due to MySQL's table-level locking as compared to PostgreSQL's 'better than row level' locking.Tim's a friend and former co-worker of mine. That was a very useful comparison Web page in its day, but is now obsolete.
Yes, I would love to see an updated version of that page; where Postgres
and MySQL stand respectively these days. I am a staunch Postgres
advocate, because from the earliest days it "just worked" for me, and I
didn't have to add in fancy non-SQL92 constructs to work around things
MySQL didn't support.
Jonathan
--
Geek House Productions, Ltd.
Providing Unix & Internet Contracting and Consulting,
QA Testing, Technical Documentation, Systems Design & Implementation,
General Programming, E-commerce, Web & Mail Services since 1998
Phone: 604-435-1205
Email: [EMAIL PROTECTED]
Webpage: http://reactor-core.org
Address: 2459 E 41st Ave, Vancouver, BC V5R2W2
msg22714/pgp00000.pgp
Description: PGP signature
