Skip to content

Instantly share code, notes, and snippets.

@pedrofurla
Last active August 29, 2015 13:58
Show Gist options
  • Save pedrofurla/10091385 to your computer and use it in GitHub Desktop.
Save pedrofurla/10091385 to your computer and use it in GitHub Desktop.
Slick vs JPA -- the difference is kind of ridiculous - preliminary results
[info] Running jpaperf.Main
-- Inserting
[info] # of Rows: 1, totalTime: 39724 μs, time per row: 39724.0 μs
[info] # of Rows: 10, totalTime: 32630 μs, time per row: 3263.0 μs
[info] # of Rows: 20, totalTime: 55624 μs, time per row: 2781.2 μs
[info] # of Rows: 30, totalTime: 79954 μs, time per row: 2665.1333 μs
[info] # of Rows: 40, totalTime: 99999 μs, time per row: 2499.975 μs
[info] # of Rows: 50, totalTime: 118572 μs, time per row: 2371.44 μs
[info] # of Rows: 100, totalTime: 217274 μs, time per row: 2172.74 μs
[info] # of Rows: 200, totalTime: 420907 μs, time per row: 2104.535 μs
[info] # of Rows: 300, totalTime: 540231 μs, time per row: 1800.77 μs
[info] # of Rows: 400, totalTime: 658670 μs, time per row: 1646.675 μs
[info] # of Rows: 600, totalTime: 896074 μs, time per row: 1493.4567 μs
[info] # of Rows: 800, totalTime: 1109615 μs, time per row: 1387.0188 μs
[info] # of Rows: 1000, totalTime: 1001483 μs, time per row: 1001.483 μs
[info] # of Rows: 5000, totalTime: 3707151 μs, time per row: 741.4302 μs
[info] # of Rows: 10000, totalTime: 6440906 μs, time per row: 644.0906 μs
[info] # of Rows: 1, totalTime: 77112 μs, time per row: 77112.0 μs
[info] # of Rows: 10, totalTime: 83262 μs, time per row: 8326.2 μs
[info] # of Rows: 20, totalTime: 89039 μs, time per row: 4451.95 μs
[info] # of Rows: 30, totalTime: 132675 μs, time per row: 4422.5 μs
[info] # of Rows: 40, totalTime: 98050 μs, time per row: 2451.25 μs
[info] # of Rows: 50, totalTime: 101685 μs, time per row: 2033.7 μs
[info] # of Rows: 100, totalTime: 134724 μs, time per row: 1347.24 μs
[info] Total Rows: 18802, totalTime: 16135361 μs, average time per row: 858.1726 μs
-- Retrieving
[info] # of Rows: 1, totalTime: 235975 μs, time per row: 235975.0 μs
[info] # of Rows: 10, totalTime: 3364 μs, time per row: 336.4 μs
[info] # of Rows: 20, totalTime: 5418 μs, time per row: 270.9 μs
[info] # of Rows: 30, totalTime: 8449 μs, time per row: 281.63333 μs
[info] # of Rows: 40, totalTime: 11081 μs, time per row: 277.025 μs
[info] # of Rows: 50, totalTime: 15731 μs, time per row: 314.62 μs
[info] # of Rows: 100, totalTime: 41235 μs, time per row: 412.35 μs
[info] # of Rows: 200, totalTime: 105501 μs, time per row: 527.505 μs
[info] # of Rows: 300, totalTime: 160938 μs, time per row: 536.46 μs
[info] # of Rows: 400, totalTime: 190281 μs, time per row: 475.7025 μs
[info] # of Rows: 600, totalTime: 388133 μs, time per row: 646.8883 μs
[info] # of Rows: 800, totalTime: 609721 μs, time per row: 762.15125 μs
[info] # of Rows: 1000, totalTime: 877973 μs, time per row: 877.973 μs
[info] # of Rows: 5000, totalTime: 25884012 μs, time per row: 5176.8022 μs
[info] # of Rows: 10000, totalTime: 113753236 μs, time per row: 11375.323 μs
[info] # of Rows: 1, totalTime: 207 μs, time per row: 207.0 μs
[info] # of Rows: 10, totalTime: 400 μs, time per row: 40.0 μs
[info] # of Rows: 20, totalTime: 771 μs, time per row: 38.55 μs
[info] # of Rows: 30, totalTime: 1346 μs, time per row: 44.866665 μs
[info] # of Rows: 40, totalTime: 2076 μs, time per row: 51.9 μs
[info] # of Rows: 50, totalTime: 3016 μs, time per row: 60.32 μs
[info] # of Rows: 100, totalTime: 9361 μs, time per row: 93.61 μs
[info] Total Rows: 18802, totalTime: 142308225 μs, average time per row: 7568.7812 μs
[success] Total time: 162 s, completed 08/04/2014 01:27:54
[info] Running slickperf.Main
-- Inserting
[info] # of Rows: 1, totalTime: 24958 μs, time per row: 24958.0 μs
[info] # of Rows: 10, totalTime: 12599 μs, time per row: 1259.9 μs
[info] # of Rows: 20, totalTime: 19040 μs, time per row: 952.0 μs
[info] # of Rows: 30, totalTime: 26967 μs, time per row: 898.9 μs
[info] # of Rows: 40, totalTime: 33865 μs, time per row: 846.625 μs
[info] # of Rows: 50, totalTime: 42853 μs, time per row: 857.06 μs
[info] # of Rows: 100, totalTime: 74452 μs, time per row: 744.52 μs
[info] # of Rows: 200, totalTime: 148175 μs, time per row: 740.875 μs
[info] # of Rows: 300, totalTime: 208029 μs, time per row: 693.43 μs
[info] # of Rows: 400, totalTime: 269801 μs, time per row: 674.5025 μs
[info] # of Rows: 600, totalTime: 368705 μs, time per row: 614.50836 μs
[info] # of Rows: 800, totalTime: 453404 μs, time per row: 566.755 μs
[info] # of Rows: 1000, totalTime: 475083 μs, time per row: 475.083 μs
[info] # of Rows: 5000, totalTime: 1765746 μs, time per row: 353.1492 μs
[info] # of Rows: 10000, totalTime: 2281977 μs, time per row: 228.1977 μs
[info] # of Rows: 1, totalTime: 307 μs, time per row: 307.0 μs
[info] # of Rows: 10, totalTime: 2587 μs, time per row: 258.7 μs
[info] # of Rows: 20, totalTime: 5598 μs, time per row: 279.9 μs
[info] # of Rows: 30, totalTime: 6784 μs, time per row: 226.13333 μs
[info] # of Rows: 40, totalTime: 9438 μs, time per row: 235.95 μs
[info] # of Rows: 50, totalTime: 12065 μs, time per row: 241.3 μs
[info] # of Rows: 100, totalTime: 23362 μs, time per row: 233.62 μs
[info] Total Rows: 18802, totalTime: 6265795 μs, average time per row: 333.25153 μs
-- Retrieving
[info] # of Rows: 1, totalTime: 1136 μs, time per row: 1136.0 μs
[info] # of Rows: 10, totalTime: 105 μs, time per row: 10.5 μs
[info] # of Rows: 20, totalTime: 100 μs, time per row: 5.0 μs
[info] # of Rows: 30, totalTime: 57 μs, time per row: 1.9 μs
[info] # of Rows: 40, totalTime: 66 μs, time per row: 1.65 μs
[info] # of Rows: 50, totalTime: 77 μs, time per row: 1.54 μs
[info] # of Rows: 100, totalTime: 124 μs, time per row: 1.24 μs
[info] # of Rows: 200, totalTime: 223 μs, time per row: 1.115 μs
[info] # of Rows: 300, totalTime: 427 μs, time per row: 1.4233333 μs
[info] # of Rows: 400, totalTime: 434 μs, time per row: 1.085 μs
[info] # of Rows: 600, totalTime: 643 μs, time per row: 1.0716667 μs
[info] # of Rows: 800, totalTime: 839 μs, time per row: 1.04875 μs
[info] # of Rows: 1000, totalTime: 1073 μs, time per row: 1.073 μs
[info] # of Rows: 5000, totalTime: 5169 μs, time per row: 1.0338 μs
[info] # of Rows: 10000, totalTime: 7160 μs, time per row: 0.716 μs
[info] # of Rows: 1, totalTime: 34 μs, time per row: 34.0 μs
[info] # of Rows: 10, totalTime: 22 μs, time per row: 2.2 μs
[info] # of Rows: 20, totalTime: 19 μs, time per row: 0.95 μs
[info] # of Rows: 30, totalTime: 22 μs, time per row: 0.73333335 μs
[info] # of Rows: 40, totalTime: 22 μs, time per row: 0.55 μs
[info] # of Rows: 50, totalTime: 28 μs, time per row: 0.56 μs
[info] # of Rows: 100, totalTime: 33 μs, time per row: 0.33 μs
[info] Total Rows: 18802, totalTime: 17813 μs, average time per row: 0.9473992 μs
[success] Total time: 11 s, completed 08/04/2014 01:19:51
@pedrofurla
Copy link
Author

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment