SQLite Embedded Database

SQLite Performance Summary

The following charts show the performance of SQLite (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).
In the chart below the Y-Axis represents result score (maximum 100) in logarithmic scale - higher is better:
JPA performance benchmark comparision Hibernate, EclipseLink, OpenJPA, DataNucleus, ObjectDB
In the chart below the Y-Axis represents result score (maximum 100) in linear scale - higher is better:
JPA performance benchmark comparision Hibernate, EclipseLink, OpenJPA, DataNucleus, ObjectDB


The configurations in which SQLite has been tested are listed in the following table:

 Database + JPA ProviderNormalized Score
100 - Best,  0 - Worst
Final Position
1 - Best,  32 - Worst
Failed Tests
1Hibernate with SQLite embedded2.727  (out of 32)6
2EclipseLink with SQLite embedded1.929  (out of 32)36

About SQLite

SQLite is an embedded database, written in C. Its first version was released in 2000.

SQLite is in the public domain (no license).

JPA support for SQLite is available (unofficially) only by Hibernate and EclipseLink, but the EclipseLink support seems unusable (too many test failures with EclipseLink).

In this benchmark SQLite 3.7.2 (which was released in 2010) has been tested.