Jdbc Performance In Memory HsqlDb
See orm-benchmarks for benchmark sources and results.
Ran with 1.7.6 the 30th of March 2015, Java 8, in memory HsqlDb.
Average time ns/op to execute, fetch and map to object the result of a query with 1, 10, 100 and 1000 rows. The lower the better.
| Type/NbRows | 1 | 10 | 100 | 1000 |
|---|---|---|---|---|
| PureJdbc | 1693.70 | 4647.74 | 33177.80 | 321250.07 |
| JdbcMapperStatic | 1769.70 | 4918.76 | 37481.25 | 363958.44 |
| JdbcMapperStaticForEach | 1757.46 | 4931.99 | 36646.49 | 350970.03 |
| JdbcMapperDynamicForEach | 1992.04 | 5218.15 | 36597.40 | 354883.75 |
| Roma | 2268.61 | 6075.77 | 41476.53 | 400075.13 |
| JdbcMapperDynamic | 1943.24 | 6136.61 | 48064.27 | 456940.11 |
| JdbcMapperStaticForEachNoAsm | 1993.55 | 6660.58 | 52857.40 | 488031.29 |
| JdbcMapperStaticNoAsm | 1991.14 | 6721.83 | 53239.93 | 486664.41 |
| JdbcMapperDynamicForEachNoAsm | 2265.03 | 6871.92 | 52528.08 | 496873.53 |
| JdbcMapperDynamicNoAsm | 2214.57 | 7717.28 | 62048.73 | 611691.56 |
| Sql2O.sfm | 4981.71 | 8571.33 | 42113.94 | 387285.87 |
| Sql2O | 6200.30 | 12128.38 | 68830.18 | 637521.62 |
| Jooq.testSqlSfmMapperOnResultSet | 22993.43 | 26775.29 | 62467.75 | 420515.54 |
| Jooq.testFetchRecord | 25400.52 | 33773.62 | 119448.29 | 945228.74 |
| Jooq.testSqlSfmAsProviderMapper | 25827.64 | 35987.92 | 131654.04 | 1081224.28 |
| HibernateStatefull | 18426.90 | 37612.33 | 239647.73 | 2193158.76 |
| Jooq.testSqlWithJooqMapper | 28731.06 | 44026.96 | 190535.52 | 1589820.34 |
| MyBatis | 21279.66 | 45177.67 | 272057.67 | 2488828.55 |
| BeanPropertyRowMapper | 14374.97 | 116673.28 | 1113095.87 | 11378836.28 |
% Difference from PureJdbc Average Time, the lower the better
% Difference from PureJdbc Average Time Top 5, the lower the better
