database performance: Java Linux Databases: Multi-Threaded Update
Up to 100 threads
With no pause in the threads (and less than 100 threads):
Two groups emerge: DB2, MySQL and Postgres perform well whereas Informix, SQL Anywhere and Firebird do not.
With a 1 millisecond pause in the threads the initial throughput is increased enormously:
And the results are more mixed in this case. Informix and Firebird catch up with Postgresql, but MySQL and DB2 still lead.
More threads
With hundreds of threads and a 5 millisecond pause in each thread:
MySQL dominates this test (especially in its i686 incarnation),
increasing throughput as we increase the number of threads,
Postgresql is not too far behind and Firebird also performed well (although it is more than 50% slower than MySQL).
DB2 performed quite well but the performance collapsed after more than 400 threads.
Informix and Sybase Anywhere were both far too slow to register on this graph.
