Compare with

Comparison of Hibernate with Derby server vs DataNucleus 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
 Hibernate
Derby server
DataNucleus
HSQLDB server
Hibernate
Derby server
DataNucleus
HSQLDB server
Hibernate
Derby server
DataNucleus
HSQLDB server
Basic Person Test8.0failed5.6failed6.8failed
Element Collection Test8.3failed7.7failed8.0failed
Inheritance Test5.2failed8.7failed7.0failed
Indexing Test9.0failed10.4failed9.7failed
Graph (Binary Tree) Test5.6failed5.5failed5.6failed
Multithreading Test10.4failed0.0000failed5.2failed
All Tests7.8failed6.3failed7.0failed

DataNucleus 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
 Hibernate
Derby server
DataNucleus
HSQLDB server
Hibernate
Derby server
DataNucleus
HSQLDB server
Hibernate
Derby server
DataNucleus
HSQLDB server
Basic Person Test1.3failed5.7failed3.5failed
Element Collection Test0.47failed0.50failed0.48failed
Inheritance Test1.6failed5.1failed3.3failed
Indexing Test1.6failed5.7failed3.7failed
Graph (Binary Tree) Test0.19failed0.32failed0.26failed
Multithreading Test2.9failed9.1failed6.0failed
All Tests1.3failed4.4failed2.9failed

DataNucleus 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
 Hibernate
Derby server
DataNucleus
HSQLDB server
Hibernate
Derby server
DataNucleus
HSQLDB server
Hibernate
Derby server
DataNucleus
HSQLDB server
Basic Person Test0.40failed1.8failed1.1failed
Element Collection Test0.67failed0.62failed0.65failed
Inheritance Test0.39failed2.0failed1.2failed
Indexing Test1.1failed2.4failed1.7failed
Multithreading Test2.5failed3.5failed3.0failed
All Tests1.0failed2.1failed1.5failed

DataNucleus 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
 Hibernate
Derby server
DataNucleus
HSQLDB server
Hibernate
Derby server
DataNucleus
HSQLDB server
Hibernate
Derby server
DataNucleus
HSQLDB server
Basic Person Test1.1failed1.9failed1.5failed
Element Collection Test2.5failed1.1failed1.8failed
Inheritance Test1.5failed2.4failed2.0failed
Indexing Test3.9failed2.5failed3.2failed
Graph (Binary Tree) Test0.92failed0.52failed0.72failed
Multithreading Test1.7failed1.6failed1.6failed
All Tests1.9failed1.7failed1.8failed

DataNucleus 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
 Hibernate
Derby server
DataNucleus
HSQLDB server
Hibernate
Derby server
DataNucleus
HSQLDB server
Hibernate
Derby server
DataNucleus
HSQLDB server
Basic Person Test12.4failed17.2failed14.8failed
Element Collection Test6.7failed1.1failed3.9failed
Inheritance Test11.6failed11.1failed11.4failed
Indexing Test22.6failed9.8failed16.2failed
Graph (Binary Tree) Test7.7failed8.1failed7.9failed
Multithreading Test7.3failed0.0000failed3.7failed
All Tests11.4failed7.9failed9.6failed

DataNucleus 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
 Hibernate
Derby server
DataNucleus
HSQLDB server
Hibernate
Derby server
DataNucleus
HSQLDB server
Hibernate
Derby server
DataNucleus
HSQLDB server
Basic Person Test4.6failed6.4failed5.5failed
Element Collection Test3.7failed2.2failed3.0failed
Inheritance Test4.0failed5.9failed5.0failed
Indexing Test7.6failed6.2failed6.9failed
Graph (Binary Tree) Test3.6failed3.6failed3.6failed
Multithreading Test4.9failed2.8failed3.9failed
All Tests4.8failed4.6failed4.7failed

Other Head to Head DBMS/JPA Comparisons