Last active
August 29, 2015 13:58
-
-
Save pedrofurla/10091385 to your computer and use it in GitHub Desktop.
Slick vs JPA -- the difference is kind of ridiculous - preliminary results
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Results from running https://github.com/pedrofurla/slick-perf