Forum OpenACS Q&A: Response to mysql passes the acid test?

Collapse
Posted by Janne Blomqvist on
The innoDB site has some benchmarks (essentially the same as
mentioined previously) with pgSQL 7.1.1 at
http://www.innodb.com/bench.html
According to this, InnoDB smoked postgreSQL quite clearly. Of
course, this is a really simple test, and postgreSQL support a lot
more of SQL92. But anyway, InnoDB might finally impove MySQL:s
performance in high concurrency situations (it has essentially the
same locking system as Oracle & PostgreSQL). I'm really glad at how
much the situation has changed regarding open source RDBMS systems
in the last year. Think about it, a year ago pgSQL 7.0.x was the
only open source DB that had anything close to the feature set
offered by commercial databases. Today, we have pgSQL 7.1.x,
Interbase/Firebird, SAPDB and MySQL+InnoDB. We should be happy. :)