database performance: Java Linux Databases: Math
Count
This test measures the time taken to count the number of rows in a table (lower is better):
The first column is quite interesting:
it takes much longer to count the number of rows in an empty table (zero) than in a table containing 10000 rows! (or maybe the data
is just making it to the cache)
After this initial glitch, Postresql and MySQL dominate the test,
but as the amount of data in the table reaches 10000, DB2 catches up.
SQLAnywhere provides fairly constant response time and is not too far off the leader's pace.
There was not enough data to compare Firebird and Informix with this version of the test code.
Sum
This test calculates the SUM of the values in an integer column (lower is better):
The results are similar to the other math test above,
except that Informix is featured (and does reasonably well) whereas DB2 is not. Another win for MySQL and Postgresql.
