H2 Pure Java Database
H2 Performance Summary
The following charts show the performance of H2 (in green) relatively to other JPA/DBMS combinations (in gray).Position #1 on the X-Axis (the fastest) is about 100 times faster than position #32 (the slowest).
The configurations in which H2 has been tested are listed in the following table:
|Database + JPA Provider||Normalized Score|
100 - Best, 0 - Worst
1 - Best, 32 - Worst
|1||Hibernate with H2 embedded||12.5||5 (out of 32)||0|
|2||EclipseLink with H2 embedded||12.3||6 (out of 32)||2|
|3||DataNucleus with H2 embedded||4.3||20 (out of 32)||4|
|4||EclipseLink with H2 server||3.4||23 (out of 32)||2|
|5||Hibernate with H2 server||3.1||24 (out of 32)||0|
|6||OpenJPA with H2 server||1.1||30 (out of 32)||2|
|7||DataNucleus with H2 server||1.0||31 (out of 32)||7|
|8||OpenJPA with H2 embedded||0.90||32 (out of 32)||10|
As shown above, the performance and stability are highly dependent on the JPA provider.
H2 is faster and more stable
(in both client-server and embedded modes) when used with EclipseLink or Hibernate.
About H2 Database
H2 Database is a popular pure Java RDBMS. Its first version was released in 2005.
H2 is available under a modified version of the Mozilla Public License (MPL) license or under the Eclipse Public License (EPL).
In this benchmark H2 version 1.2.141 (which was released in 2010) has been tested.
Both client-server and embedded mode are supported by H2 and were tested in this benchmark.