Comparison of OpenJPA with H2 embedded vs OpenJPA 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 Entities		Many Entities		Average Score
	OpenJPA H2 embedded	OpenJPA HSQLDB server	OpenJPA H2 embedded	OpenJPA HSQLDB server	OpenJPA H2 embedded	OpenJPA HSQLDB server
Basic Person Test	9.7	failed	7.7	failed	8.7	failed
Element Collection Test	10.3	failed	7.4	failed	8.9	failed
Inheritance Test	5.2	failed	6.6	failed	5.9	failed
Indexing Test	9.2	failed	8.7	failed	9.0	failed
Graph (Binary Tree) Test	3.4	failed	2.7	failed	3.0	failed
Multithreading Test	7.5	failed	0.0000	failed	3.7	failed
All Tests	7.5	failed	5.5	failed	6.5	failed

OpenJPA with HSQLDB server has failed in 12 tests (see exceptions).

Retrieval Size =>	Few Entities		Many Entities		Average Score
	OpenJPA H2 embedded	OpenJPA HSQLDB server	OpenJPA H2 embedded	OpenJPA HSQLDB server	OpenJPA H2 embedded	OpenJPA HSQLDB server
Basic Person Test	11.4	failed	46.6	failed	29.0	failed
Element Collection Test	1.4	failed	33.1	failed	17.3	failed
Inheritance Test	5.6	failed	37.6	failed	21.6	failed
Indexing Test	5.8	failed	39.3	failed	22.5	failed
Graph (Binary Tree) Test	0.86	failed	0.90	failed	0.88	failed
Multithreading Test	14.0	failed	38.9	failed	26.4	failed
All Tests	6.5	failed	32.7	failed	19.6	failed

OpenJPA with HSQLDB server has failed in 12 tests (see exceptions).

Retrieval Size =>	Few Entities		Many Entities		Average Score
	OpenJPA H2 embedded	OpenJPA HSQLDB server	OpenJPA H2 embedded	OpenJPA HSQLDB server	OpenJPA H2 embedded	OpenJPA HSQLDB server
Basic Person Test	5.7	failed	24.0	failed	14.9	failed
Element Collection Test	3.6	failed	7.1	failed	5.4	failed
Inheritance Test	1.1	failed	9.3	failed	5.2	failed
Indexing Test	14.3	failed	24.2	failed	19.3	failed
Multithreading Test	3.1	failed	7.2	failed	5.1	failed
All Tests	5.6	failed	14.4	failed	10.0	failed

OpenJPA with HSQLDB server has failed in 10 tests (see exceptions).

Transaction Size =>	Few Entities		Many Entities		Average Score
	OpenJPA H2 embedded	OpenJPA HSQLDB server	OpenJPA H2 embedded	OpenJPA HSQLDB server	OpenJPA H2 embedded	OpenJPA HSQLDB server
Basic Person Test	14.2	failed	11.2	failed	12.7	failed
Element Collection Test	6.5	failed	15.2	failed	10.9	failed
Inheritance Test	4.0	failed	14.9	failed	9.5	failed
Indexing Test	43.0	failed	16.2	failed	29.6	failed
Graph (Binary Tree) Test	3.3	failed	2.2	failed	2.7	failed
Multithreading Test	8.2	failed	6.3	failed	7.2	failed
All Tests	13.2	failed	11.0	failed	12.1	failed

OpenJPA with HSQLDB server has failed in 12 tests (see exceptions).

Transaction Size =>	Few Entities		Many Entities		Average Score
	OpenJPA H2 embedded	OpenJPA HSQLDB server	OpenJPA H2 embedded	OpenJPA HSQLDB server	OpenJPA H2 embedded	OpenJPA HSQLDB server
Basic Person Test	55.8	failed	26.5	failed	41.1	failed
Element Collection Test	26.3	failed	3.0	failed	14.6	failed
Inheritance Test	26.7	failed	23.0	failed	24.8	failed
Indexing Test	100	failed	13.7	failed	56.8	failed
Graph (Binary Tree) Test	12.5	failed	40.6	failed	26.5	failed
Multithreading Test	20.9	failed	0.0000	failed	10.4	failed
All Tests	40.4	failed	17.8	failed	29.1	failed

OpenJPA with HSQLDB server has failed in 12 tests (see exceptions).

Transaction/Retrieval Size	Few Entities		Many Entities		Average Score
	OpenJPA H2 embedded	OpenJPA HSQLDB server	OpenJPA H2 embedded	OpenJPA HSQLDB server	OpenJPA H2 embedded	OpenJPA HSQLDB server
Basic Person Test	19.4	failed	23.2	failed	21.3	failed
Element Collection Test	9.6	failed	13.2	failed	11.4	failed
Inheritance Test	8.5	failed	18.3	failed	13.4	failed
Indexing Test	34.5	failed	20.4	failed	27.4	failed
Graph (Binary Tree) Test	5.0	failed	11.6	failed	8.3	failed
Multithreading Test	10.7	failed	10.5	failed	10.6	failed
All Tests	14.9	failed	16.4	failed	15.6	failed