Performance Java 7
See orm-benchmarks for benchmark sources and results.
The introduction of log4j in the pom impacted the hibernate benchmark, I replace the last run number with a previous run.
Notes. the last update see a change in the pattern in the results, it might be due to a change of config on my machine.
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 | 1,932.90 | 4,986.56 | 35,174.76 | 338,329.42 |
| JdbcMapperStatic | 1,954.16 | 5,279.25 | 37,706.48 | 358,078.39 |
| JdbcMapperStaticNoAsm | 2,267.64 | 7,437.84 | 57,942.24 | 561,286.74 |
| JdbcMapperDynamic | 2,200.64 | 6,257.11 | 45,709.15 | 438,085.40 |
| Roma | 2,657.83 | 6,414.74 | 43,654.80 | 411,799.35 |
| JdbcMapperDynamicNoAsm | 2,488.84 | 8,403.93 | 66,964.97 | 650,236.33 |
| Sql2O | 6,465.33 | 12,188.29 | 66,407.25 | 601,473.37 |
| HibernateStatefull | 19,145.09 | 41,438.27 | 253,079.29 | 2,529,606.26 |
| Jooq.testSqlSmfMapper | 32,453.58 | 43,294.91 | 141,045.88 | 1,109,438.57 |
| Jooq.testFetchRecord | 29,230.55 | 45,241.89 | 174,774.53 | 1,547,739.98 |
| MyBatis | 19,646.33 | 53,041.10 | 357,459.33 | 3,584,767.10 |
| Jooq.testSqlWithJooqMapper | 39,710.39 | 55,112.47 | 206,354.76 | 1,758,898.63 |
| BeanPropertyRowMapper | 15,400.30 | 124,064.49 | 1,219,259.23 | 12,240,426.71 |
% Difference from PureJdbc Average Time, the lower the better
% Difference from PureJdbc Average Time Top 5, the lower the better
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 | 245,656.97 | 320,380.17 | 729,210.15 | 2,895,357.10 |
| JdbcMapperStatic | 251,270.09 | 320,653.79 | 733,313.02 | 2,875,003.36 |
| JdbcMapperDynamic | 248,157.25 | 334,258.93 | 750,968.87 | 2,992,474.71 |
| JdbcMapperStaticNoAsm | 247,415.98 | 343,042.86 | 745,021.39 | 3,068,639.02 |
| JdbcMapperDynamicNoAsm | 251,177.79 | 348,578.86 | 764,346.22 | 3,175,026.15 |
| Roma | 259,116.64 | 384,132.92 | 796,816.93 | 3,227,048.33 |
| Sql2O | 262,054.32 | 405,365.22 | 838,182.64 | 3,562,668.86 |
| HibernateStatefull | 336,939.80 | 426,423.35 | 1,115,869.80 | 5,682,184.56 |
| Jooq.testSqlSmfMapper | 348,344.11 | 436,034.03 | 896,927.74 | 4,004,866.97 |
| Jooq.testFetchRecord | 347,525.13 | 450,962.73 | 963,248.30 | 4,493,950.56 |
| Jooq.testSqlWithJooqMapper | 353,089.58 | 451,104.95 | 919,301.63 | 4,062,534.46 |
| BeanPropertyRowMapper | 319,099.37 | 513,320.26 | 2,039,824.24 | 14,979,374.50 |
| MyBatis | 436,415.82 | 533,972.72 | 1,244,039.59 | 7,506,197.17 |
% Difference from PureJdbc Average Time, the lower the better
% Difference from PureJdbc Average Time Top5, the lower the better
Jmh benchmark. Average time in us to parse and map to object a csv file with 10, 1000 and 100000 rows. The lower the better.
| Type/NbRows | 1 | 10 | 100 | 1000 |
|---|---|---|---|---|
| JacksonCsvMapper | 1,118.47 | 9,118.87 | 85,848.88 | 792,258.04 |
| ReadSfmCsvMapper | 2,316.74 | 6,360.36 | 54,518.06 | 569,732.59 |
| OpenCsvMapper | 2,602.02 | 13,782.47 | 127,311.26 | 1,330,882.55 |
% Difference from Jackson Average Time, the lower the better
