When one or more of the All filters is selected - only average normalized results are displayed. Please read Running and Results for more details.
Comparison of database storage efficiency - entity objects per MB (higher is better)
  | Derby embedded | H2 embedded | HSQLDB embedded | SQLite embedded | DB4O embedded | ObjectDB embedded | Derby server | H2 server | MySQL server | PostgreSQL server | ObjectDB server |
---|---|---|---|---|---|---|---|---|---|---|---|
DataNucleus | 6,823 | 9,988 | 6,248 | failed | |||||||
EclipseLink | 6,713 | 20,505 | 14,274 | 30,305 | |||||||
Hibernate | 6,549 | 14,262 | 14,274 | 33,930 | |||||||
OpenJPA | 6,401 | 14,234 | 14,274 | ||||||||
ObjectDB | 50,000 |
Disk space efficiency chart - The Y-Axis represents normalized score in logarithmic scale - higher is better:
Disk space efficiency chart - The Y-Axis represents normalized score in linear scale - higher is better:
Best and Worst JPA/Database Performer in this comparison
The Most Efficient:
1. | ObjectDB embedded | 100 |
2. | Hibernate with SQLite embedded | 67.9 |
3. | EclipseLink with SQLite embedded | 60.6 |
4. | EclipseLink with H2 embedded | 41.0 |
5. | EclipseLink with HSQLDB embedded | 28.5 |
6. | Hibernate with HSQLDB embedded | 28.5 |
7. | OpenJPA with HSQLDB embedded | 28.5 |
8. | Hibernate with H2 embedded | 28.5 |
The Least Efficient:
9. | OpenJPA with H2 embedded | 28.5 |
10. | DataNucleus with H2 embedded | 20.0 |
11. | DataNucleus with Derby embedded | 13.6 |
12. | EclipseLink with Derby embedded | 13.4 |
13. | Hibernate with Derby embedded | 13.1 |
14. | OpenJPA with Derby embedded | 12.8 |
15. | DataNucleus with HSQLDB embedded | 12.5 |
16. | DataNucleus with DB4O embedded | 0.0000 |
Problems (Exceptions) in these tests
- DataNucleus with DB4O embedded
javax.persistence.PersistenceException: Object "org.jpab.node.Node@538eb7b8" being inserted has id "130003" yet an object with this id already exists in the datastore! at org.datanucleus.api.jpa.NucleusJPAHelper.getJPAExceptionForNucleusException(NucleusJPAHelper.java:302) at org.datanucleus.api.jpa.JPAEntityTransaction.commit(JPAEntityTransaction.java:122) at org.jpab.Test.persist(Test.java:217) at org.jpab.Test.persist(Test.java:200) at org.jpab.Runner$PersistAction.run0(Runner.java:538) at org.jpab.Runner$TestAction.run(Runner.java:517) at java.lang.Thread.run(Thread.java:662) Caused by: org.datanucleus.exceptions.NucleusUserException: Object "org.jpab.node.Node@538eb7b8" being inserted has id "130003" yet an object with this id already exists in the datastore! at org.datanucleus.store.db4o.DB4OPersistenceHandler.insertObject(DB4OPersistenceHandler.java:140) at org.datanucleus.state.JDOStateManager.internalMakePersistent(JDOStateManager.java:2371) at org.datanucleus.state.JDOStateManager.flush(JDOStateManager.java:3803) at org.datanucleus.ObjectManagerImpl.flushInternalWithOrdering(ObjectManagerImpl.java:3854) at org.datanucleus.ObjectManagerImpl.flushInternal(ObjectManagerImpl.java:3755) at org.datanucleus.ObjectManagerImpl.flush(ObjectManagerImpl.java:3701) at org.datanucleus.ObjectManagerImpl.preCommit(ObjectManagerImpl.java:4084) at org.datanucleus.ObjectManagerImpl$2.transactionPreCommit(ObjectManagerImpl.java:398) at org.datanucleus.TransactionImpl.internalPreCommit(TransactionImpl.java:370) at org.datanucleus.TransactionImpl.commit(TransactionImpl.java:259) at org.datanucleus.api.jpa.JPAEntityTransaction.commit(JPAEntityTransaction.java:103) ... 5 more
The results above are in use in calculating the following average results
- All Tests - All Operations - All Batch Size Modes
- All Tests - All Operations - Few Entities (5/100)
- All Tests - Storage Efficiency - All Batch Size Modes
- All Tests - Storage Efficiency - Few Entities (5/100)
- Graph (Binary Tree) Test - All Operations - All Batch Size Modes
- Graph (Binary Tree) Test - All Operations - Few Entities (5/100)
- Graph (Binary Tree) Test - Storage Efficiency - All Batch Size Modes