database performance: Java Linux Databases: Multi-Threaded Insert
Up to 100 threads
With no pause in the threads (and less than 100 threads), there is a clear winner:
MySQL (MyISAM) is way ahead of all the other databases tested.
With a 1ms pause in each thread, throughput is enormously increased:
MySQL still dominates, scaling better than the competition, but it is closely followed by Postgresql and DB2.
Informix leads the rest of the pack.
More threads
With hundreds of threads and a 5 millisecond pause in each thread:
MySQL continues to lead, but Postgres is not far behind.
DB2 does quite well up to 500 threads, but then sees a sharp drop in performance.
Firebird provided fairly constant throughput, scaling all the way to 1100 threads.
Sybase Anywhere and Informix performed really poorly.
