Created
May 2, 2009 11:21
-
-
Save markoa/105516 to your computer and use it in GitHub Desktop.
Sample results of http://gist.github.com/105314
This file contains 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
| Sat May 02 13:20:05 +0200 2009 | |
| N is 1000 | |
| ruby is 1.8.7 | |
| Preparing data... | |
| == PeopleMigration: reverting ================================================ | |
| -- drop_table(:people) | |
| -> 0.0447s | |
| == PeopleMigration: reverted (0.0450s) ======================================= | |
| == PageViewMigration: reverting ============================================== | |
| -- drop_table(:page_views) | |
| -> 0.0326s | |
| == PageViewMigration: reverted (0.0327s) ===================================== | |
| == PeopleMigration: migrating ================================================ | |
| -- create_table(:people) | |
| -> 0.0109s | |
| -- add_index(:people, :email) | |
| -> 0.0239s | |
| == PeopleMigration: migrated (0.0354s) ======================================= | |
| == PageViewMigration: migrating ============================================== | |
| -- create_table(:page_views) | |
| -> 0.0081s | |
| == PageViewMigration: migrated (0.0083s) ===================================== | |
| ActiveRecord with MySQL adapter | |
| People | |
| user system total real | |
| inserting data 4.430000 0.460000 4.890000 ( 11.191485) | |
| finding all 0.020000 0.000000 0.020000 ( 0.041656) | |
| finding last 0.000000 0.000000 0.000000 ( 0.001415) | |
| find emails (i) 0.150000 0.010000 0.160000 ( 0.190081) | |
| find sonya email (i) 0.000000 0.000000 0.000000 ( 0.001001) | |
| find names 0.050000 0.000000 0.050000 ( 0.208266) | |
| PageViews | |
| user system total real | |
| inserting data 2.940000 0.400000 3.340000 ( 6.604770) | |
| finding all 0.020000 0.000000 0.020000 ( 0.032462) | |
| finding last 0.000000 0.000000 0.000000 ( 0.001385) | |
| find user_ids 0.120000 0.010000 0.130000 ( 0.163348) | |
| find user_id 10 0.000000 0.000000 0.000000 ( 0.000729) | |
| Tokyo Cabinet table, direct access to file | |
| People | |
| user system total real | |
| inserting data 0.030000 0.000000 0.030000 ( 0.035078) | |
| finding all 0.000000 0.000000 0.000000 ( 0.003270) | |
| find last 0.000000 0.000000 0.000000 ( 0.000059) | |
| find emails (i) 0.100000 0.000000 0.100000 ( 0.093549) | |
| find sonya email (i) 0.000000 0.000000 0.000000 ( 0.000902) | |
| find names 0.070000 0.000000 0.070000 ( 0.075077) | |
| PageViews | |
| user system total real | |
| inserting data 0.020000 0.010000 0.030000 ( 0.022545) | |
| finding all 0.000000 0.000000 0.000000 ( 0.001631) | |
| find last 0.000000 0.000000 0.000000 ( 0.000031) | |
| find user_ids 0.060000 0.000000 0.060000 ( 0.058045) | |
| find user_id 10 0.000000 0.000000 0.000000 ( 0.000592) | |
| Benchmark Tokyo Tyrant? [y/n] | |
| y | |
| Tokyo Tyrant | |
| People | |
| user system total real | |
| inserting data 0.100000 0.030000 0.130000 ( 0.224206) | |
| finding all 0.170000 0.040000 0.210000 ( 0.281781) | |
| find last 0.000000 0.010000 0.010000 ( 0.000208) | |
| find emails (i) 0.040000 0.000000 0.040000 ( 0.145908) | |
| find sonya email (i) 0.000000 0.000000 0.000000 ( 0.001454) | |
| find names 0.040000 0.000000 0.040000 ( 0.136947) | |
| PageViews | |
| user system total real | |
| inserting data 0.060000 0.040000 0.100000 ( 0.170623) | |
| finding all 0.210000 0.070000 0.280000 ( 0.363774) | |
| find last 0.000000 0.000000 0.000000 ( 0.000233) | |
| find user_ids 0.280000 0.070000 0.350000 ( 0.560159) | |
| find user_id 10 0.000000 0.000000 0.000000 ( 0.004312) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment