Apache Derby - a Pure Java Database
Derby Performance Summary
The following charts show the performance of Derby (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).
The configurations in which Derby has been tested are listed in the following table:
|Database + JPA Provider||Normalized Score|
100 - Best, 0 - Worst
1 - Best, 32 - Worst
|1||EclipseLink with Derby embedded||14.6||4 (out of 32)||2|
|2||Hibernate with Derby embedded||11.4||7 (out of 32)||0|
|3||DataNucleus with Derby embedded||6.2||12 (out of 32)||15|
|4||OpenJPA with Derby embedded||5.4||17 (out of 32)||10|
|5||Hibernate with Derby server||5.2||19 (out of 32)||0|
|6||EclipseLink with Derby server||4.1||22 (out of 32)||2|
|7||DataNucleus with Derby server||2.8||25 (out of 32)||15|
|8||OpenJPA with Derby server||2.8||26 (out of 32)||38|
As shown above, the performance and stability are highly dependent on the JPA provider.
Derby is faster and more stable
(in both client-server and embedded modes) when used with EclipseLink or Hibernate. In addition, analysis of the results reveals that Derby is fast mainly in retrieval and queries but it is relatively slow in insert/update/delete operations.
About Apache Derby
Derby is a popular pure Java RDBMS, developed by the Apache Software Foundation.
The first version was released in 1997 by Cloudscape. First it was called JBMS and later it was renamed to Cloudscape. Cloudscape was acquired by Informix in 1999 and then by IBM (with the Informix database) in 2001. The Cloudscape database code has been contributed by IBM to Apache in 2004. Derby is also packaged by Sun in JDK 6 under the name Java DB.
Derby is available under the Apache open source license.
In this benchmark Apache Derby version 10.6.1.0 (which was released in 2010) has been tested.
Both client-server and embedded mode are supported by Derby and were tested in this benchmark.