This is the database benchmark that I stumbled upon when I was searching for similiar information.
PolePosition is a benchmark test suite to compare database engines and object-relational mapping technology. It has done the benchmarking for the followings
- db4o - the open source object database for Java and .NET
- Hibernate - relational persistence for idiomatic Java
- MySQL - the world’s most popular open source database
- McKoi - an open source Java SQL database system
- JavaDB - Sun’s supported distribution of Apache Derby
- HSQLDB - lightweight 100% Java SQL database engine
- SQLite - a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
Few things to note from the tests, as described in the website,
- HSQLDB is performing good as most processing is done in memory, but if you want to use it in complex database application, you have to test yourself
- Use of OR mapping tools like Hibernate or JDO has negative impact on performance. Use it if you have powerful hardware. Well, Java always demands higher processing power, that is what we all knew :). However, O-R mappers and object databases make life so much easier and productive.
- db4o provides best performance for deep inheritance hierarchies and tree structures
- MySQL is worth looking at compared to other proprietary products. Well I like this one.