From ApacheToday (
http://apachetoday.com/news_story.php3?ltsn=2000-08-14-008-01-PR-MR-SW
following the Slashdot link). This post does not include the
transaction test that was made for brevity's sake, but MySQL didn't
even make it and Interbase had a problem because of the lack of a
stable ODBC driver. "In the TPC-C tests, Postgres performed neck and
neck with the two leading proprietary databases." (product names not
revealed due to license agreement issues.)
The performance tests were made using PG's ODBC driver
AFAIK... I wonder what we'd get using native drivers. Go PostgreSQL,
and kudos to the PG developers:
"In the AS3AP tests, PostgreSQL 7.0 significantly outperformed both
the leading commercial and open source applications in
speed and scalability. In the tested configuration, Postgres peaked at
1127.8 transactions per second with five users, and still processed at
a steady rate of 1070.4 with 100 users.
The proprietary leader also performed consistently, with a high of
314.15 transactions per second with eight users, which fell
slightly to 288.37 transactions per second with 100 users. The other
leading proprietary database also demonstrated consistency, running at
200.21 transactions per second with six users and 197.4 with 100."
"The other databases tested against the AS3AP benchmarks, open source
competitors MySQL 3.22 and Interbase 6.0, demonstrated some speed with
a low number of users but a distinct lack of scalability. MySQL
reached a peak of 803.48 with two users, but its performance
fell precipitously under the stress of additional users to a rate of
117.87 transactions per second with 100 users. Similarly, Interbase
reached 424 transactions per second with four users, but its
performance declined steadily with additional users, dropping off to
146.86 transactions per second with 100 users."
