Re: Decide between Postgresql and Mysql (help of

On Tue, Mar 28, 2006 at 09:42:51PM +0200, PFC wrote:
>     However, throw in some maintenance operation which involves a long
>     query  with writes (like a big joined UPDATE) and all access to your
> website is  blocked while the query lasts.
>     This is worsened by the fact that MySQL sucks at complex queries.
>
>     If all of your updates are done to a few rows, MyISAM is cool, but
> someday you'll want to do this query which locks a table during one
> minute... and then you got a problem.

Not to mention that MyISAM loves to eat data. Livejournal suffered at
least one major crash due to MyISAM corruption.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461