database performance: Java Linux Databases: Update
Overall
MySQL (MyISAM) still leads with a huge margin, but as the amount of data in the table is increased
Informix quickly loses the second place to Firebird.
It also interresting to note that whilst providing the best performance,
MySQL also produces one of the lowest system load in i686 mode (see dotted lines).
Whilst Postgresql and MySQL produce a lower load in i686 mode, Firebird does the opposite and has a much lower load in x86_64 mode!
Prepared Statements
Using prepared statements provides a dramatic performance gain (except for Postgresql):
Indexes
The surprise in this test is how little difference there is when adding indexes to the columns (except MySQL):
