Created
April 5, 2014 17:39
-
-
Save pedrofurla/9995242 to your computer and use it in GitHub Desktop.
Comparing slick vs jsa under mysql. Notice the file names. I consider the most revealing info being the "time per register". Also notice the re-rerun after 10,000 rows.
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 | |
| [info] Inserting users with one account each | |
| [info] Rows: 1, totalTime: 39161 μs, time per register: 39161.0 μs | |
| [info] Rows: 10, totalTime: 31550 μs, time per register: 3155.0 μs | |
| [info] Rows: 20, totalTime: 58404 μs, time per register: 2920.2 μs | |
| [info] Rows: 30, totalTime: 75291 μs, time per register: 2509.7 μs | |
| [info] Rows: 40, totalTime: 93540 μs, time per register: 2338.5 μs | |
| [info] Rows: 50, totalTime: 109259 μs, time per register: 2185.18 μs | |
| [info] Rows: 100, totalTime: 206513 μs, time per register: 2065.13 μs | |
| [info] Rows: 200, totalTime: 418894 μs, time per register: 2094.47 μs | |
| [info] Rows: 300, totalTime: 545047 μs, time per register: 1816.8234 μs | |
| [info] Rows: 400, totalTime: 634042 μs, time per register: 1585.105 μs | |
| [info] Rows: 600, totalTime: 905233 μs, time per register: 1508.7217 μs | |
| [info] Rows: 800, totalTime: 1051569 μs, time per register: 1314.4613 μs | |
| [info] Rows: 1000, totalTime: 966888 μs, time per register: 966.888 μs | |
| [info] Rows: 5000, totalTime: 3726433 μs, time per register: 745.2866 μs | |
| [info] Rows: 10000, totalTime: 6332957 μs, time per register: 633.2957 μs | |
| [info] Rows: 1, totalTime: 2264 μs, time per register: 2264.0 μs | |
| [info] Rows: 10, totalTime: 7478 μs, time per register: 747.8 μs | |
| [info] Rows: 20, totalTime: 13307 μs, time per register: 665.35 μs | |
| [info] Rows: 30, totalTime: 19345 μs, time per register: 644.8333 μs | |
| [info] Rows: 40, totalTime: 25966 μs, time per register: 649.15 μs | |
| [info] Rows: 50, totalTime: 32192 μs, time per register: 643.84 μs | |
| [info] Rows: 100, totalTime: 61888 μs, time per register: 618.88 μs | |
| [info] Querying users and its accounts | |
| [info] Rows: 1, totalTime: 223225 μs, time per register: 223225.0 μs | |
| [info] Rows: 10, totalTime: 11897 μs, time per register: 1189.7 μs | |
| [info] Rows: 20, totalTime: 22232 μs, time per register: 1111.6 μs | |
| [info] Rows: 30, totalTime: 33802 μs, time per register: 1126.7333 μs | |
| [info] Rows: 40, totalTime: 51327 μs, time per register: 1283.175 μs | |
| [info] Rows: 50, totalTime: 60649 μs, time per register: 1212.98 μs | |
| [info] Rows: 100, totalTime: 172143 μs, time per register: 1721.43 μs | |
| [info] Rows: 200, totalTime: 187080 μs, time per register: 935.4 μs | |
| [info] Rows: 300, totalTime: 270890 μs, time per register: 902.9667 μs | |
| [info] Rows: 400, totalTime: 411456 μs, time per register: 1028.64 μs | |
| [info] Rows: 600, totalTime: 674237 μs, time per register: 1123.7284 μs | |
| [info] Rows: 800, totalTime: 1002798 μs, time per register: 1253.4976 μs | |
| [info] Rows: 1000, totalTime: 1349237 μs, time per register: 1349.237 μs | |
| [info] Rows: 5000, totalTime: 28313565 μs, time per register: 5662.713 μs | |
| [info] Rows: 10000, totalTime: 124359912 μs, time per register: 12435.991 μs | |
| [info] Rows: 1, totalTime: 1080 μs, time per register: 1080.0 μs | |
| [info] Rows: 10, totalTime: 3777 μs, time per register: 377.7 μs | |
| [info] Rows: 20, totalTime: 8322 μs, time per register: 416.1 μs | |
| [info] Rows: 30, totalTime: 9413 μs, time per register: 313.76666 μs | |
| [info] Rows: 40, totalTime: 15747 μs, time per register: 393.675 μs | |
| [info] Rows: 50, totalTime: 26457 μs, time per register: 529.14 μs | |
| [info] Rows: 100, totalTime: 42851 μs, time per register: 428.51 μs | |
| [success] Total time: 180 s, completed 04/04/2014 19:27:40 |
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 | |
| [info] Inserting users and one account per user | |
| [info] Rows: 1, totalTime: 41785 μs, time per register: 41785.0 μs | |
| [info] Rows: 10, totalTime: 28910 μs, time per register: 2891.0 μs | |
| [info] Rows: 20, totalTime: 35185 μs, time per register: 1759.25 μs | |
| [info] Rows: 30, totalTime: 44759 μs, time per register: 1491.9667 μs | |
| [info] Rows: 40, totalTime: 51247 μs, time per register: 1281.175 μs | |
| [info] Rows: 50, totalTime: 55508 μs, time per register: 1110.16 μs | |
| [info] Rows: 100, totalTime: 96494 μs, time per register: 964.94 μs | |
| [info] Rows: 200, totalTime: 166850 μs, time per register: 834.25 μs | |
| [info] Rows: 300, totalTime: 227683 μs, time per register: 758.94336 μs | |
| [info] Rows: 400, totalTime: 269607 μs, time per register: 674.0175 μs | |
| [info] Rows: 600, totalTime: 371828 μs, time per register: 619.7133 μs | |
| [info] Rows: 800, totalTime: 465075 μs, time per register: 581.34375 μs | |
| [info] Rows: 1000, totalTime: 477243 μs, time per register: 477.243 μs | |
| [info] Rows: 5000, totalTime: 1752176 μs, time per register: 350.4352 μs | |
| [info] Rows: 10000, totalTime: 2293504 μs, time per register: 229.3504 μs | |
| [info] Rows: 1, totalTime: 7349 μs, time per register: 7349.0 μs | |
| [info] Rows: 10, totalTime: 9916 μs, time per register: 991.6 μs | |
| [info] Rows: 20, totalTime: 12779 μs, time per register: 638.95 μs | |
| [info] Rows: 30, totalTime: 13617 μs, time per register: 453.9 μs | |
| [info] Rows: 40, totalTime: 16043 μs, time per register: 401.075 μs | |
| [info] Rows: 50, totalTime: 18333 μs, time per register: 366.66 μs | |
| [info] Rows: 100, totalTime: 29521 μs, time per register: 295.21 μs | |
| [info] Querying: | |
| [info] Querying users and its accounts | |
| [info] Rows: 1, totalTime: 7806 μs, time per register: 7806.0 μs | |
| [info] Rows: 10, totalTime: 7334 μs, time per register: 733.4 μs | |
| [info] Rows: 20, totalTime: 6850 μs, time per register: 342.5 μs | |
| [info] Rows: 30, totalTime: 7032 μs, time per register: 234.4 μs | |
| [info] Rows: 40, totalTime: 5812 μs, time per register: 145.3 μs | |
| [info] Rows: 50, totalTime: 7441 μs, time per register: 148.82 μs | |
| [info] Rows: 100, totalTime: 5980 μs, time per register: 59.8 μs | |
| [info] Rows: 200, totalTime: 7087 μs, time per register: 35.435 μs | |
| [info] Rows: 300, totalTime: 7286 μs, time per register: 24.286667 μs | |
| [info] Rows: 400, totalTime: 9127 μs, time per register: 22.8175 μs | |
| [info] Rows: 600, totalTime: 9543 μs, time per register: 15.905 μs | |
| [info] Rows: 800, totalTime: 11235 μs, time per register: 14.04375 μs | |
| [info] Rows: 1000, totalTime: 10915 μs, time per register: 10.915 μs | |
| [info] Rows: 5000, totalTime: 13370 μs, time per register: 2.674 μs | |
| [info] Rows: 10000, totalTime: 18009 μs, time per register: 1.8009 μs | |
| [info] Rows: 1, totalTime: 16422 μs, time per register: 16422.0 μs | |
| [info] Rows: 10, totalTime: 6649 μs, time per register: 664.9 μs | |
| [info] Rows: 20, totalTime: 6792 μs, time per register: 339.6 μs | |
| [info] Rows: 30, totalTime: 6540 μs, time per register: 218.0 μs | |
| [info] Rows: 40, totalTime: 5478 μs, time per register: 136.95 μs | |
| [info] Rows: 50, totalTime: 5745 μs, time per register: 114.9 μs | |
| [info] Rows: 100, totalTime: 5086 μs, time per register: 50.86 μs |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment