On Thu, 2003-10-02 at 12:17, Mark Stosberg wrote:
> I understand that Postgres has been closing the speed gap with MySQL,
> but I'm having trouble finding hard data on this.
The "speed gap" you speek of is a myth, try to find some hard data on
that! The cases where mysql can really fly are not generally the
application scenarios you encounter in the real world unless you are
working with a read-high/write-low cases. Unfortunately, without
porting your app to both dbs you can not verify this experientially.
You could easily create an app to stress test both dbs (creating a php
script with a few queries from your app) and hit it with apache bench to
simulate your load.
We have been using postgres since 2000 for some relatively complex
e-commerce and order management projects. We used mysql for about a
week because we weren't familiar with postgres and we bought into the
mysql hype. But coming from Oracle and MSSQL, mysql was a total joke
and didn't have the features to support our application so we had to
disqualify it before we could even bench it. Postgres is a pleasure,
especially if you are coming from an Oracle environment.
-r