database performance: Java Linux Databases: Multi-Threaded Select
Up to 100 threads
With a 5ms pause in each thread and up to 100 threads:
Postgresql and MySQL are neck and neck,
the advantage goes to MySQL for its consistency.
Informix and Firebird start with the same pace as the leaders not scaling as well they fall behind when more 15 threads are used.
More threads
With hundreds of threads and a 5 millisecond pause in each thread:
MySQL and Posgres perform consistently well, even with a large amount of threads.
Firebird provides a reliable throughput (albeit much lower than the leaders), all the way to thousands of threads.
SQL Anywhere performs really well (on par with the leaders) up to 300 threads before dropping back.
DB2 performed ok for up to 400 threads. Informix hardly registered here.
