ScalaRelational vs Slick Benchmark

ScalaRelational vs Slick Benchmark

[info] Result "srUpdate":
[info]   65.054 ±(99.9%) 14.119 ms/op [Average]
[info]   (min, avg, max) = (55.011, 65.054, 77.015), stdev = 9.339
[info]   CI (99.9%): [50.936, 79.173] (assumes normal distribution)
[info]   Samples, N = 10
[info]         mean =     65.054 ±(99.9%) 14.119 ms/op
[info]          min =     55.011 ms/op
[info]   p( 0.0000) =     55.011 ms/op
[info]   p(50.0000) =     60.050 ms/op
[info]   p(90.0000) =     76.990 ms/op
[info]   p(95.0000) =     77.015 ms/op
[info]   p(99.0000) =     77.015 ms/op
[info]   p(99.9000) =     77.015 ms/op
[info]   p(99.9900) =     77.015 ms/op
[info]   p(99.9990) =     77.015 ms/op
[info]   p(99.9999) =     77.015 ms/op
[info]          max =     77.015 ms/op
[info] 
[info] 
[info] # Run complete. Total time: 04:56:04
[info] 
[info] Benchmark                   Mode     Cnt     Score     Error   Units
[info] Test.slickDelete           thrpt     200     0.004 ±   0.001  ops/ms
[info] Test.slickInsertBatch      thrpt     200     0.045 ±   0.001  ops/ms
[info] Test.slickInsertSeparate   thrpt     200     0.021 ±   0.001  ops/ms
[info] Test.slickQuery            thrpt     200     0.004 ±   0.001  ops/ms
[info] Test.slickUpdate           thrpt     200     0.005 ±   0.001  ops/ms
[info] Test.srDelete              thrpt     200     1.185 ±   0.023  ops/ms
[info] Test.srInsertBatch         thrpt     200     0.179 ±   0.007  ops/ms
[info] Test.srInsertMapper        thrpt     200     0.013 ±   0.001  ops/ms
[info] Test.srInsertSeparate      thrpt     200     0.146 ±   0.002  ops/ms
[info] Test.srQueryConvert        thrpt     200     0.160 ±   0.002  ops/ms
[info] Test.srQueryMap            thrpt     200     0.159 ±   0.003  ops/ms
[info] Test.srQueryTo             thrpt     200     0.138 ±   0.002  ops/ms
[info] Test.srUpdate              thrpt     200     0.208 ±   0.004  ops/ms
[info] Test.slickDelete            avgt     200   231.147 ±   5.925   ms/op
[info] Test.slickInsertBatch       avgt     200    22.940 ±   0.206   ms/op
[info] Test.slickInsertSeparate    avgt     200    49.880 ±   1.455   ms/op
[info] Test.slickQuery             avgt     200   260.313 ±   7.767   ms/op
[info] Test.slickUpdate            avgt     200   238.467 ±   6.986   ms/op
[info] Test.srDelete               avgt     200     0.926 ±   0.026   ms/op
[info] Test.srInsertBatch          avgt     200     5.950 ±   0.132   ms/op
[info] Test.srInsertMapper         avgt     200    77.657 ±   0.851   ms/op
[info] Test.srInsertSeparate       avgt     200     6.836 ±   0.118   ms/op
[info] Test.srQueryConvert         avgt     200     6.150 ±   0.093   ms/op
[info] Test.srQueryMap             avgt     200     6.282 ±   0.086   ms/op
[info] Test.srQueryTo              avgt     200     7.325 ±   0.139   ms/op
[info] Test.srUpdate               avgt     200     4.864 ±   0.101   ms/op
[info] Test.slickDelete          sample     929   242.056 ±   3.267   ms/op
[info] Test.slickInsertBatch     sample    8869    22.784 ±   0.085   ms/op
[info] Test.slickInsertSeparate  sample    4071    50.377 ±   0.409   ms/op
[info] Test.slickQuery           sample     865   262.203 ±   4.583   ms/op
[info] Test.slickUpdate          sample     983   224.984 ±   4.396   ms/op
[info] Test.srDelete             sample  218133     0.916 ±   0.002   ms/op
[info] Test.srInsertBatch        sample   37836     5.294 ±   0.013   ms/op
[info] Test.srInsertMapper       sample    2650    77.932 ±   0.501   ms/op
[info] Test.srInsertSeparate     sample   29424     6.814 ±   0.017   ms/op
[info] Test.srQueryConvert       sample   31864     6.290 ±   0.017   ms/op
[info] Test.srQueryMap           sample   31142     6.438 ±   0.014   ms/op
[info] Test.srQueryTo            sample   27196     7.374 ±   0.015   ms/op
[info] Test.srUpdate             sample   40868     4.900 ±   0.012   ms/op
[info] Test.slickDelete              ss      10  1177.173 ±  92.612   ms/op
[info] Test.slickInsertBatch         ss      10   151.199 ±  33.706   ms/op
[info] Test.slickInsertSeparate      ss      10   267.268 ±  25.338   ms/op
[info] Test.slickQuery               ss      10  1218.197 ±  72.230   ms/op
[info] Test.slickUpdate              ss      10  1146.394 ±  52.206   ms/op
[info] Test.srDelete                 ss      10    52.473 ±   8.424   ms/op
[info] Test.srInsertBatch            ss      10    36.624 ±  10.053   ms/op
[info] Test.srInsertMapper           ss      10  1429.950 ± 264.726   ms/op
[info] Test.srInsertSeparate         ss      10    90.604 ±  22.969   ms/op
[info] Test.srQueryConvert           ss      10   129.922 ±  34.403   ms/op
[info] Test.srQueryMap               ss      10   130.020 ±  32.380   ms/op
[info] Test.srQueryTo                ss      10   195.316 ±  37.107   ms/op
[info] Test.srUpdate                 ss      10    65.054 ±  14.119   ms/op
[success] Total time: 17787 s, completed Jul 13, 2015 8:29:21 PM