[KLUG Members] MySQL -vs- Postgresql - speed.
members@kalamazoolinux.org
members@kalamazoolinux.org
Sun, 27 Oct 2002 17:33:44 -0500
>>I've read that Postgresql may be a little slower than MySQL,
>>but that's not "a little slower", that's a LOT SLOWER!
>There are usually ways to improve speed on any database, but bottom
>line, yes Postgres is a lot slower.
>Postgres's atomicity is more robust. MySQL is much faster.
>Postgres provides rollbacks. MySQL is much faster.
>Postgres (probably) won't leave your DB in an inconsistent state if
>you yank the plug during a sequence of updates. MySQL is much
>faster.
>And so on. :)
>Also, MySQL is undergoing more rapid development, there are some
>exciting improvements happening.
Watching MySQL development is a little bewildering. By adding transactions,
foreign keys, contraints, triggers, etc... (all the features a "real" RDBMS has)
will inevitably result in one thing - larger & slower. It will just be another
PostgreSQL (or Informix, or Oracle, or M$-SQL), and it seems like it will have
evolved itself right out of its niche (light and just bloody fast).
Do they have a plan to avoid this?