Choose benchmark test, operation and batch mode:

When one or more of the All filters is selected - only average normalized results are displayed. Please read Running and Results for more details.

Speed comparison of JPA database retrieval operations per second (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
DataNucleus47,21642,79532,377 5,671 20,04816,64829,40024,007 
EclipseLink186,32292,240114,269failed  35,71926,06249,12354,515 
Hibernate51,89542,25152,0733,999  26,74219,11434,90636,449 
OpenJPA71,66286,17795,408   36,91824,14671,93350,919 
ObjectDB     317,229    143,871

Performance comparison chart - The Y-Axis represents normalized score in logarithmic scale - higher is better:
JPA performance benchmark comparision Hibernate, EclipseLink, OpenJPA, DataNucleus, ObjectDB

Performance comparison chart - The Y-Axis represents normalized score in linear scale - higher is better:
JPA performance benchmark comparision Hibernate, EclipseLink, OpenJPA, DataNucleus, ObjectDB

Best and Worst JPA/Database Performer in this comparison

The Most Efficient (the Fastest):

1. ObjectDB embedded100
2. EclipseLink with Derby embedded58.7
3. ObjectDB server45.4
4. EclipseLink with HSQLDB embedded36.0
5. OpenJPA with HSQLDB embedded30.1
6. EclipseLink with H2 embedded29.1
7. OpenJPA with H2 embedded27.2
8. OpenJPA with MySQL server22.7
9. OpenJPA with Derby embedded22.6
10. EclipseLink with PostgreSQL server17.2
11. Hibernate with HSQLDB embedded16.4
12. Hibernate with Derby embedded16.4
13. OpenJPA with PostgreSQL server16.1
14. EclipseLink with MySQL server15.5
15. DataNucleus with Derby embedded14.9
16. DataNucleus with H2 embedded13.5
17. Hibernate with H2 embedded13.3

The Least Efficient (the Slowest):

18. OpenJPA with Derby server11.6
19. Hibernate with PostgreSQL server11.5
20. EclipseLink with Derby server11.3
21. Hibernate with MySQL server11.0
22. DataNucleus with HSQLDB embedded10.2
23. DataNucleus with MySQL server9.3
24. Hibernate with Derby server8.4
25. EclipseLink with H2 server8.2
26. OpenJPA with H2 server7.6
27. DataNucleus with PostgreSQL server7.6
28. DataNucleus with Derby server6.3
29. Hibernate with H2 server6.0
30. DataNucleus with H2 server5.2
31. DataNucleus with DB4O embedded1.8
32. Hibernate with SQLite embedded1.3
33. EclipseLink with SQLite embedded0.0000

Problems (Exceptions) in these tests

  • EclipseLink with SQLite embedded
    Local Exception Stack: 
Exception [EclipseLink-3002] (Eclipse Persistence Services - 2.1.1.v20100817-r8050): org.eclipse.persistence.exceptions.ConversionException
Exception Description: The object [1,375,200,000], of class [class java.lang.Integer], from mapping [org.eclipse.persistence.mappings.DirectToFieldMapping[lastLoginDate-->PERSON.LASTLOGINDATE]] with descriptor [RelationalDescriptor(org.jpab.basic.Person --> [DatabaseTable(PERSON)])], could not be converted to [class java.util.Date].
	at org.eclipse.persistence.exceptions.ConversionException.couldNotBeConverted(ConversionException.java:71)
	at org.eclipse.persistence.internal.helper.ConversionManager.convertObjectToUtilDate(ConversionManager.java:761)
	at org.eclipse.persistence.internal.helper.ConversionManager.convertObject(ConversionManager.java:101)
	at org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform.convertObject(DatasourcePlatform.java:157)
	at org.eclipse.persistence.mappings.converters.TypeConversionConverter.convertDataValueToObjectValue(TypeConversionConverter.java:119)
	at org.eclipse.persistence.mappings.foundation.AbstractDirectMapping.getAttributeValue(AbstractDirectMapping.java:675)
	at org.eclipse.persistence.mappings.foundation.AbstractDirectMapping.valueFromRow(AbstractDirectMapping.java:1263)
	at org.eclipse.persistence.mappings.foundation.AbstractDirectMapping.buildCloneFromRow(AbstractDirectMapping.java:1234)
	at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildAttributesIntoWorkingCopyClone(ObjectBuilder.java:1338)
	at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildWorkingCopyCloneFromRow(ObjectBuilder.java:1466)
	at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjectInUnitOfWork(ObjectBuilder.java:558)
	at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObject(ObjectBuilder.java:502)
	at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObject(ObjectBuilder.java:454)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.buildObject(ObjectLevelReadQuery.java:721)
	at org.eclipse.persistence.queries.ReadAllQuery.registerResultInUnitOfWork(ReadAllQuery.java:723)
	at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:420)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1074)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:736)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1034)
	at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:380)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1112)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2909)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1291)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1273)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1247)
	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:479)
	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQueryImpl.java:714)
	at org.jpab.Test.retireveEntities(Test.java:382)
	at org.jpab.Test.doAction(Test.java:251)
	at org.jpab.Runner$RetrieveAction.run0(Runner.java:550)
	at org.jpab.Runner$TestAction.run(Runner.java:517)
	at java.lang.Thread.run(Thread.java:662)