Skip to content

Instantly share code, notes, and snippets.

@tindzk

tindzk/gist:e2966773aa3e72897204

Last active January 15, 2016 16:35
Show Gist options
  • Save tindzk/e2966773aa3e72897204 to your computer and use it in GitHub Desktop.
Save tindzk/e2966773aa3e72897204 to your computer and use it in GitHub Desktop.
Download ZIP
ScalaRelational benchmarks
Raw
gistfile1.txt
> run -i 2 -wi 2 -f 0
SR v1.1.0, Slick v3.0.0
[info] Benchmark Mode Cnt Score Error Units
[info] Test.slickDelete thrpt 2 0,008 ops/ms
[info] Test.slickInsertBatch thrpt 2 0,086 ops/ms
[info] Test.slickInsertSeparate thrpt 2 0,056 ops/ms
[info] Test.slickQuery thrpt 2 0,009 ops/ms
[info] Test.slickUpdate thrpt 2 0,010 ops/ms
[info] Test.srDelete thrpt 2 2,460 ops/ms
[info] Test.srInsertBatch thrpt 2 0,624 ops/ms
[info] Test.srInsertMapper thrpt 2 0,356 ops/ms
[info] Test.srInsertSeparate thrpt 2 0,329 ops/ms
[info] Test.srQueryConvert thrpt 2 0,437 ops/ms
[info] Test.srQueryMap thrpt 2 0,440 ops/ms
[info] Test.srQueryTo thrpt 2 0,393 ops/ms
[info] Test.srUpdate thrpt 2 0,541 ops/ms
[info] Test.slickDelete avgt 2 107,355 ms/op
[info] Test.slickInsertBatch avgt 2 8,790 ms/op
[info] Test.slickInsertSeparate avgt 2 19,233 ms/op
[info] Test.slickQuery avgt 2 110,214 ms/op
[info] Test.slickUpdate avgt 2 98,577 ms/op
[info] Test.srDelete avgt 2 0,413 ms/op
[info] Test.srInsertBatch avgt 2 1,548 ms/op
[info] Test.srInsertMapper avgt 2 2,744 ms/op
[info] Test.srInsertSeparate avgt 2 3,029 ms/op
[info] Test.srQueryConvert avgt 2 2,241 ms/op
[info] Test.srQueryMap avgt 2 2,154 ms/op
[info] Test.srQueryTo avgt 2 2,390 ms/op
[info] Test.srUpdate avgt 2 1,839 ms/op
[info] Test.slickDelete sample 20 105,041 ± 2,187 ms/op
[info] Test.slickInsertBatch sample 229 8,748 ± 0,110 ms/op
[info] Test.slickInsertSeparate sample 106 19,099 ± 0,629 ms/op
[info] Test.slickQuery sample 18 112,212 ± 2,696 ms/op
[info] Test.slickUpdate sample 21 99,115 ± 3,671 ms/op
[info] Test.srDelete sample 4859 0,411 ± 0,003 ms/op
[info] Test.srInsertBatch sample 1216 1,644 ± 0,031 ms/op
[info] Test.srInsertMapper sample 759 2,637 ± 0,052 ms/op
[info] Test.srInsertSeparate sample 690 2,899 ± 0,082 ms/op
[info] Test.srQueryConvert sample 916 2,184 ± 0,057 ms/op
[info] Test.srQueryMap sample 933 2,143 ± 0,011 ms/op
[info] Test.srQueryTo sample 838 2,387 ± 0,017 ms/op
[info] Test.srUpdate sample 1126 1,777 ± 0,006 ms/op
[info] Test.slickDelete ss 2 108,619 ms/op
[info] Test.slickInsertBatch ss 2 8,843 ms/op
[info] Test.slickInsertSeparate ss 2 17,155 ms/op
[info] Test.slickQuery ss 2 109,411 ms/op
[info] Test.slickUpdate ss 2 97,816 ms/op
[info] Test.srDelete ss 2 1,000 ms/op
[info] Test.srInsertBatch ss 2 1,725 ms/op
[info] Test.srInsertMapper ss 2 2,525 ms/op
[info] Test.srInsertSeparate ss 2 2,903 ms/op
[info] Test.srQueryConvert ss 2 2,232 ms/op
[info] Test.srQueryMap ss 2 2,184 ms/op
[info] Test.srQueryTo ss 2 2,429 ms/op
[info] Test.srUpdate ss 2 1,825 ms/op
SR v1.2.0, Slick v3.1.1
[info] Benchmark Mode Cnt Score Error Units
[info] Test.slickDelete thrpt 2 0,029 ops/ms
[info] Test.slickInsertBatch thrpt 2 0,182 ops/ms
[info] Test.slickInsertSeparate thrpt 2 0,086 ops/ms
[info] Test.slickQuery thrpt 2 0,030 ops/ms
[info] Test.slickUpdate thrpt 2 0,035 ops/ms
[info] Test.srDelete thrpt 2 2,462 ops/ms
[info] Test.srInsertBatch thrpt 2 0,651 ops/ms
[info] Test.srInsertMapper thrpt 2 0,338 ops/ms
[info] Test.srInsertSeparate thrpt 2 0,289 ops/ms
[info] Test.srQueryConvert thrpt 2 0,462 ops/ms
[info] Test.srQueryMap thrpt 2 0,447 ops/ms
[info] Test.srQueryTo thrpt 2 0,459 ops/ms
[info] Test.srUpdate thrpt 2 0,546 ops/ms
[info] Test.slickDelete avgt 2 31,603 ms/op
[info] Test.slickInsertBatch avgt 2 5,216 ms/op
[info] Test.slickInsertSeparate avgt 2 11,398 ms/op
[info] Test.slickQuery avgt 2 34,210 ms/op
[info] Test.slickUpdate avgt 2 30,220 ms/op
[info] Test.srDelete avgt 2 0,392 ms/op
[info] Test.srInsertBatch avgt 2 1,641 ms/op
[info] Test.srInsertMapper avgt 2 2,726 ms/op
[info] Test.srInsertSeparate avgt 2 3,296 ms/op
[info] Test.srQueryConvert avgt 2 2,118 ms/op
[info] Test.srQueryMap avgt 2 2,279 ms/op
[info] Test.srQueryTo avgt 2 2,126 ms/op
[info] Test.srUpdate avgt 2 1,821 ms/op
[info] Test.slickDelete sample 66 31,085 ± 1,131 ms/op
[info] Test.slickInsertBatch sample 378 5,297 ± 0,058 ms/op
[info] Test.slickInsertSeparate sample 177 11,349 ± 0,217 ms/op
[info] Test.slickQuery sample 60 33,897 ± 1,036 ms/op
[info] Test.slickUpdate sample 68 29,910 ± 0,979 ms/op
[info] Test.srDelete sample 5077 0,394 ± 0,003 ms/op
[info] Test.srInsertBatch sample 1279 1,563 ± 0,011 ms/op
[info] Test.srInsertMapper sample 732 2,735 ± 0,141 ms/op
[info] Test.srInsertSeparate sample 627 3,188 ± 0,076 ms/op
[info] Test.srQueryConvert sample 971 2,059 ± 0,059 ms/op
[info] Test.srQueryMap sample 870 2,301 ± 0,061 ms/op
[info] Test.srQueryTo sample 941 2,125 ± 0,048 ms/op
[info] Test.srUpdate sample 974 2,054 ± 0,124 ms/op
[info] Test.slickDelete ss 2 36,418 ms/op
[info] Test.slickInsertBatch ss 2 5,829 ms/op
[info] Test.slickInsertSeparate ss 2 12,133 ms/op
[info] Test.slickQuery ss 2 35,171 ms/op
[info] Test.slickUpdate ss 2 30,536 ms/op
[info] Test.srDelete ss 2 1,284 ms/op
[info] Test.srInsertBatch ss 2 1,684 ms/op
[info] Test.srInsertMapper ss 2 2,648 ms/op
[info] Test.srInsertSeparate ss 2 3,155 ms/op
[info] Test.srQueryConvert ss 2 2,603 ms/op
[info] Test.srQueryMap ss 2 2,279 ms/op
[info] Test.srQueryTo ss 2 2,637 ms/op
[info] Test.srUpdate ss 2 2,029 ms/op
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment