Compare with

Comparison of EclipseLink with H2 server vs OpenJPA with HSQLDB server

Each of the following tables focuses on a specific database operation, where the last table presents average results comparison.

Speed comparison of JPA database persistence operations (normalized score, higher is better)

Transaction Size =>Few EntitiesMany EntitiesAverage Score
 EclipseLink
H2 server
OpenJPA
HSQLDB server
EclipseLink
H2 server
OpenJPA
HSQLDB server
EclipseLink
H2 server
OpenJPA
HSQLDB server
Basic Person Test12.6failed9.5failed11.1failed
Element Collection Test12.5failed6.6failed9.5failed
Inheritance Test6.5failed10.5failed8.5failed
Indexing Test12.2failed12.3failed12.3failed
Graph (Binary Tree) Test8.3failed7.3failed7.8failed
Multithreading Test11.5failed0.0000failed5.8failed
All Tests10.6failed7.7failed9.2failed

OpenJPA with HSQLDB server has failed in 12 tests (see exceptions).

Speed comparison of JPA database retrieval operations (normalized score, higher is better)

Retrieval Size =>Few EntitiesMany EntitiesAverage Score
 EclipseLink
H2 server
OpenJPA
HSQLDB server
EclipseLink
H2 server
OpenJPA
HSQLDB server
EclipseLink
H2 server
OpenJPA
HSQLDB server
Basic Person Test2.8failed6.6failed4.7failed
Element Collection Test1.5failed1.8failed1.7failed
Inheritance Test2.1failed7.9failed5.0failed
Indexing Test2.4failed8.0failed5.2failed
Graph (Binary Tree) Test0.38failed0.81failed0.60failed
Multithreading Test4.7failed11.2failed8.0failed
All Tests2.3failed6.0failed4.2failed

OpenJPA with HSQLDB server has failed in 12 tests (see exceptions).

Speed comparison of JPA database query operations (normalized score, higher is better)

Retrieval Size =>Few EntitiesMany EntitiesAverage Score
 EclipseLink
H2 server
OpenJPA
HSQLDB server
EclipseLink
H2 server
OpenJPA
HSQLDB server
EclipseLink
H2 server
OpenJPA
HSQLDB server
Basic Person Test1.2failed3.1failed2.2failed
Element Collection Test1.8failed1.9failed1.9failed
Inheritance Test0.75failed3.3failed2.0failed
Indexing Test2.1failed3.5failed2.8failed
Multithreading Test3.6failed6.7failed5.1failed
All Tests1.9failed3.7failed2.8failed

OpenJPA with HSQLDB server has failed in 10 tests (see exceptions).

Speed comparison of JPA database update operations (normalized score, higher is better)

Transaction Size =>Few EntitiesMany EntitiesAverage Score
 EclipseLink
H2 server
OpenJPA
HSQLDB server
EclipseLink
H2 server
OpenJPA
HSQLDB server
EclipseLink
H2 server
OpenJPA
HSQLDB server
Basic Person Test2.1failed2.8failed2.4failed
Element Collection Test4.8failed1.9failed3.4failed
Inheritance Test2.1failed3.0failed2.6failed
Indexing Test5.5failed4.4failed5.0failed
Graph (Binary Tree) Test1.0failed0.73failed0.89failed
Multithreading Test2.7failed1.4failed2.0failed
All Tests3.0failed2.4failed2.7failed

OpenJPA with HSQLDB server has failed in 12 tests (see exceptions).

Speed comparison of JPA database removal operations (normalized score, higher is better)

Transaction Size =>Few EntitiesMany EntitiesAverage Score
 EclipseLink
H2 server
OpenJPA
HSQLDB server
EclipseLink
H2 server
OpenJPA
HSQLDB server
EclipseLink
H2 server
OpenJPA
HSQLDB server
Basic Person Test12.1failed9.6failed10.9failed
Element Collection Test8.3failed1.2failed4.8failed
Inheritance Test13.7failed7.4failed10.6failed
Indexing Test23.0failed7.0failed15.0failed
Graph (Binary Tree) Test7.5failed10.9failed9.2failed
Multithreading Test7.0failed0.0000failed3.5failed
All Tests11.9failed6.0failed9.0failed

OpenJPA with HSQLDB server has failed in 12 tests (see exceptions).

Comparison of JPA/Database speed - the averages (normalized score, higher is better)

Transaction/Retrieval SizeFew EntitiesMany EntitiesAverage Score
 EclipseLink
H2 server
OpenJPA
HSQLDB server
EclipseLink
H2 server
OpenJPA
HSQLDB server
EclipseLink
H2 server
OpenJPA
HSQLDB server
Basic Person Test6.2failed6.3failed6.2failed
Element Collection Test5.8failed2.7failed4.2failed
Inheritance Test5.0failed6.4failed5.7failed
Indexing Test9.0failed7.0failed8.0failed
Graph (Binary Tree) Test4.3failed4.9failed4.6failed
Multithreading Test5.9failed3.9failed4.9failed
All Tests6.1failed5.2failed5.7failed

Other Head to Head DBMS/JPA Comparisons