[ic] Performance of mysql versus postgressql

[Mike Clark]

Check out these links:

http://www.phpbuilder.com/columns/tim20001112.php3
http://www.phpbuilder.com/columns/tim20000705.php3

They might be a little more unbiased since they aren't published by either
of the product providers. The best part is that the author does a good job
of pointing out the pros and cons of each db.


Mike C.

----- Original Message -----
From: "Jay Flaherty" <fty@mediapulse.com>
To: <interchange-users@interchange.redhat.com>
Sent: Wednesday, December 12, 2001 2:31 PM
Subject: Re: [ic] Performance of mysql versus postgressql


> > Message: 12
> > From: "Mike Clark" <mclark7@triad.rr.com>
> > To: <interchange-users@interchange.redhat.com>
> > Subject: Re: [ic] Performance of mysql versus postgressql
> > Date: Tue, 11 Dec 2001 14:54:33 -0500
> > Reply-To: interchange-users@interchange.redhat.com
>
> > Also be aware that Postgres' strength lies in scalability as you load
> your
> > server. MySQL is quite likely to be faster under single-user or light
> loads.
>
> I beg to differ. mySQL is quite likely to be faster under all
> conditions. We run mySQL on a dozen databases anywhere from 1,000
> records up to 2.5M records and anywhere from 10 to 100's of transactions
> per second. All on the same machine and daemon. Most of these run from
> various web servers with no effect on page loads. Postgres' strength
> lies in being a "Object-Relational DBMS, supporting almost all SQL
> constructs, including subselects, transactions, and user-defined types
> and functions.". Because of this it is not as lean and mean as mySQL is.
> Check out:
> http://www.mysql.com/information/benchmark-results/result-mysql,pg.html
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users