Open Source Database Engines in Java
Hmm…. H2? When developing software with Java, why anyone would bother with non-Java DB, i.e. all the problems with native library compatibility and such (32bit/64bit, Linux/Windows/etc., M$XP/M$Vista/M$7/…)? Especially interesting sounds the possibility to embed DB into java process, thus avoiding having separate process and socket (or such) communication with it.
And is Java based DB then slow? If these results are correct, then performance is very well comparable to PostgresSQL. I’m betting that performance difference comes from the fact that when DB and process using it are both java, then some redundant communication overhead and conversions (for example, String) are avoided. Especially embedded mode performance looks quite impressive compared to PostgresSQL (7X faster on statements per second).
References:
Open Source Database Engines in Java
H2
Highest Performance Database in Java