database performance: Java Linux Databases: Select
Overall
We measure the speed of running many select statements as we increase the amount of initial data in the table:
Postgres leads most of the way, followed by MySQL and DB2.
Firebird and Sybase SQL Anywhere provide fairly constant throughput.
Informix suffers badly as the amount of initial data is increased.
Prepared Statements
Select is the prime example of an operation that greatly benefits from using prepared statements:
Sybase SQL Anywhere is the one that benefits the most: the performance increases by a factor of 15! DB2 performance increases by a factor of 7!
On average the improvement is closer to a factor of 2, which is still significant.
Only Postgresql shows a small but non negligeable improvement of 30%.
