Skip to content

Instantly share code, notes, and snippets.

@markoa

markoa/ar_mysql_vs_tc_table.log

Created May 2, 2009 11:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save markoa/105516 to your computer and use it in GitHub Desktop.
Save markoa/105516 to your computer and use it in GitHub Desktop.
Download ZIP
Sample results of http://gist.github.com/105314
Raw
ar_mysql_vs_tc_table.log
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