## 最新结果2022-08-07 本次均使用了最新的ORM版本。 JDBC作为基准测试,直接使用jdbc+无反射,是最快的。在不考虑JDBC的情况下,BeetlSQL性能比MyBatis和JPA都好很多 另外BeetlSQL支持全部9个场景的测试 > 有些dao并不支持一些特性,所以并未出现在下面列表,比如JDBC不支持自动翻页查询,MyBatis不支持one2Many等。 > > 测试机器在这几年中使用了不同的机器,本次测试使用的Mac i7. 测试维度是ops/ms,每毫秒的调用次数(Score,Error这里表示误差)。 ``` Benchmark Mode Cnt Score Error Units JMHMain.beetlsqlComplexMapping thrpt 2 261.097 ops/ms JMHMain.beetlsqlExecuteJdbc thrpt 2 545.487 ops/ms JMHMain.beetlsqlExecuteTemplate thrpt 2 468.580 ops/ms JMHMain.beetlsqlFile thrpt 2 475.087 ops/ms JMHMain.beetlsqlInsert thrpt 2 260.108 ops/ms JMHMain.beetlsqlLambdaQuery thrpt 2 296.364 ops/ms JMHMain.beetlsqlOne2Many thrpt 2 132.043 ops/ms JMHMain.beetlsqlPageQuery thrpt 2 230.195 ops/ms JMHMain.beetlsqlSelectById thrpt 2 458.701 ops/ms JMHMain.jdbcExecuteJdbc thrpt 2 1182.139 ops/ms JMHMain.jdbcInsert thrpt 2 335.903 ops/ms JMHMain.jdbcSelectById thrpt 2 1164.131 ops/ms JMHMain.jpaExecuteJdbc thrpt 2 124.374 ops/ms JMHMain.jpaExecuteTemplate thrpt 2 150.468 ops/ms JMHMain.jpaInsert thrpt 2 88.970 ops/ms JMHMain.jpaOne2Many thrpt 2 109.989 ops/ms JMHMain.jpaPageQuery thrpt 2 133.352 ops/ms JMHMain.jpaSelectById thrpt 2 359.050 ops/ms JMHMain.mybatisComplexMapping thrpt 2 117.422 ops/ms JMHMain.mybatisExecuteTemplate thrpt 2 251.915 ops/ms JMHMain.mybatisFile thrpt 2 192.212 ops/ms JMHMain.mybatisInsert thrpt 2 167.225 ops/ms JMHMain.mybatisLambdaQuery thrpt 2 12.453 ops/ms JMHMain.mybatisPageQuery thrpt 2 76.006 ops/ms JMHMain.mybatisSelectById thrpt 2 265.810 ops/ms JMHMain.weedExecuteJdbc thrpt 2 424.919 ops/ms JMHMain.weedExecuteTemplate thrpt 2 464.600 ops/ms JMHMain.weedFile thrpt 2 498.603 ops/ms JMHMain.weedInsert thrpt 2 248.010 ops/ms JMHMain.weedLambdaQuery thrpt 2 383.933 ops/ms JMHMain.weedPageQuery thrpt 2 249.315 ops/ms JMHMain.weedSelectById thrpt 2 401.897 ops/ms ```