Created
February 27, 2009 04:30
-
-
Save jmettraux/71285 to your computer and use it in GitHub Desktop.
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
Fri Feb 27 13:02:16 +0900 2009 | |
N is 10000 | |
ruby is 1.8.6 | |
preparing fake data for table tests... | |
TC | |
user system total real | |
inserting one 0.000000 0.000000 0.000000 ( 0.000115) | |
inserting N 0.130000 0.010000 0.140000 ( 0.129227) | |
finding all keys 0.020000 0.000000 0.020000 ( 0.024804) | |
finding all keys (native) 0.120000 0.000000 0.120000 ( 0.123061) | |
finding all keys (pref) 0.200000 0.000000 0.200000 ( 0.198756) | |
finding all keys (r pref) 0.110000 0.000000 0.110000 ( 0.109493) | |
finding all 0.150000 0.000000 0.150000 ( 0.150847) | |
iterate all 0.210000 0.000000 0.210000 ( 0.214673) | |
find first 0.000000 0.000000 0.000000 ( 0.000017) | |
delete first 0.000000 0.000000 0.000000 ( 0.000047) | |
delete_keys_with_prefix "1" 0.000000 0.000000 0.000000 ( 0.003273) | |
del keys with prefix "2" (m) 0.030000 0.000000 0.030000 ( 0.022464) | |
Edo TC | |
user system total real | |
inserting one 0.000000 0.000000 0.000000 ( 0.000071) | |
inserting N 0.110000 0.000000 0.110000 ( 0.114509) | |
finding all keys 0.010000 0.000000 0.010000 ( 0.011439) | |
finding all keys (pref) 0.010000 0.000000 0.010000 ( 0.005404) | |
finding all keys (r pref) 0.020000 0.000000 0.020000 ( 0.022680) | |
finding all 0.120000 0.000000 0.120000 ( 0.119044) | |
iterate all 0.110000 0.000000 0.110000 ( 0.114404) | |
find first 0.000000 0.000000 0.000000 ( 0.000019) | |
delete first 0.000000 0.000000 0.000000 ( 0.000038) | |
delete_keys_with_prefix "1" (M) 0.010000 0.000000 0.010000 ( 0.008123) | |
del keys with prefix "2" (m) 0.000000 0.000000 0.000000 ( 0.006844) | |
TT | |
user system total real | |
inserting one 0.000000 0.000000 0.000000 ( 0.000238) | |
inserting N 0.210000 0.200000 0.410000 ( 1.133108) | |
finding all keys 0.120000 0.200000 0.320000 ( 1.006899) | |
finding all keys (native) 0.210000 0.210000 0.420000 ( 1.112644) | |
finding all keys (pref) 0.260000 0.000000 0.260000 ( 0.274108) | |
finding all keys (r pref) 0.130000 0.200000 0.330000 ( 1.022326) | |
finding all 0.330000 0.410000 0.740000 ( 2.140767) | |
iterate all 0.400000 0.400000 0.800000 ( 2.210343) | |
find first 0.000000 0.000000 0.000000 ( 0.000119) | |
delete first 0.000000 0.000000 0.000000 ( 0.000244) | |
delete_keys_with_prefix "1" 0.000000 0.000000 0.000000 ( 0.004100) | |
del keys with prefix "2" (m) 0.040000 0.050000 0.090000 ( 0.246526) | |
net TT | |
user system total real | |
inserting one 0.000000 0.000000 0.000000 ( 0.000276) | |
inserting N 0.500000 0.210000 0.710000 ( 1.460417) | |
finding all keys 0.630000 0.280000 0.910000 ( 1.644565) | |
finding all keys (pref) 0.310000 0.060000 0.370000 ( 0.378280) | |
finding all keys (r pref) 0.710000 0.280000 0.990000 ( 1.721810) | |
finding all 1.400000 0.560000 1.960000 ( 3.430359) | |
iterate all 1.460000 0.550000 2.010000 ( 3.569670) | |
find first 0.000000 0.000000 0.000000 ( 0.000172) | |
delete first 0.000000 0.000000 0.000000 ( 0.000271) | |
delete_keys_with_prefix "1" 0.110000 0.010000 0.120000 ( 0.124153) | |
del keys with prefix "2" (m) 0.140000 0.070000 0.210000 ( 0.375951) | |
TT over memcache-client | |
user system total real | |
inserting one 0.000000 0.000000 0.000000 ( 0.001106) | |
inserting N 2.210000 0.970000 3.180000 ( 3.393512) | |
find first 0.000000 0.000000 0.000000 ( 0.000757) | |
delete first 0.000000 0.000000 0.000000 ( 0.000312) | |
TT over memcache-client (:compression => true) | |
user system total real | |
inserting one 0.000000 0.000000 0.000000 ( 0.000929) | |
inserting N 2.180000 0.960000 3.140000 ( 3.286917) | |
find first 0.000000 0.000000 0.000000 ( 0.000771) | |
delete first 0.010000 0.000000 0.010000 ( 0.000309) | |
TC table | |
user system total real | |
inserting data (index set) 0.960000 0.250000 1.210000 ( 1.224383) | |
inserting data (no index) 1.020000 0.250000 1.270000 ( 1.276009) | |
finding all keys 0.020000 0.000000 0.020000 ( 0.024997) | |
finding all keys (pref) 0.200000 0.010000 0.210000 ( 0.202270) | |
finding all keys (r pref) 0.110000 0.000000 0.110000 ( 0.115743) | |
finding all 1.620000 0.050000 1.670000 ( 1.672337) | |
find last 0.000000 0.000000 0.000000 ( 0.000021) | |
delete last 0.000000 0.000000 0.000000 ( 0.000019) | |
find Alphonse 0.010000 0.000000 0.010000 ( 0.007275) | |
setting index (10000 rows) 0.010000 0.000000 0.010000 ( 0.018001) | |
find Alphonse (index set) 0.010000 0.000000 0.010000 ( 0.007788) | |
delete_keys_with_prefix "1" 0.310000 0.000000 0.310000 ( 0.316746) | |
Edo TC table | |
user system total real | |
inserting data (index set) 0.220000 0.000000 0.220000 ( 0.227572) | |
inserting data (no index) 0.330000 0.010000 0.340000 ( 0.332586) | |
finding all keys 0.010000 0.000000 0.010000 ( 0.014477) | |
finding all keys (pref) 0.010000 0.000000 0.010000 ( 0.007517) | |
finding all keys (r pref) 0.030000 0.000000 0.030000 ( 0.026319) | |
finding all 0.030000 0.000000 0.030000 ( 0.031799) | |
find last 0.000000 0.000000 0.000000 ( 0.000041) | |
delete last 0.000000 0.000000 0.000000 ( 0.000014) | |
find Alphonse 0.010000 0.000000 0.010000 ( 0.009196) | |
setting index (10000 rows) 0.020000 0.000000 0.020000 ( 0.024126) | |
find Alphonse (index set) 0.010000 0.000000 0.010000 ( 0.010261) | |
delete_keys_with_prefix "1" 0.020000 0.000000 0.020000 ( 0.021169) | |
TT table | |
user system total real | |
inserting data (index set) 0.810000 0.420000 1.230000 ( 2.086466) | |
inserting data (no index) 0.810000 0.420000 1.230000 ( 2.046680) | |
finding all keys 0.110000 0.200000 0.310000 ( 1.008603) | |
finding all keys (pref) 0.260000 0.000000 0.260000 ( 0.270386) | |
finding all keys (r pref) 0.120000 0.200000 0.320000 ( 1.012596) | |
finding all 1.400000 0.250000 1.650000 ( 2.529559) | |
find last 0.000000 0.000000 0.000000 ( 0.000175) | |
delete last 0.000000 0.000000 0.000000 ( 0.000138) | |
find Alphonse 0.000000 0.000000 0.000000 ( 0.009999) | |
setting index (10000 rows) 0.000000 0.000000 0.000000 ( 0.022236) | |
find Alphonse (index set) 0.000000 0.000000 0.000000 ( 0.010721) | |
delete_keys_with_prefix "1" 0.330000 0.050000 0.380000 ( 0.580418) | |
'author' TT table | |
user system total real | |
inserting data (index set) 1.470000 0.260000 1.730000 ( 2.692238) | |
inserting data (no index) 1.590000 0.260000 1.850000 ( 2.708792) | |
finding all keys 0.480000 0.280000 0.760000 ( 1.478013) | |
finding all keys (pref) 0.300000 0.060000 0.360000 ( 0.367290) | |
finding all keys (r pref) 0.500000 0.270000 0.770000 ( 1.495670) | |
finding all 0.180000 0.060000 0.240000 ( 0.262870) | |
find last 0.000000 0.000000 0.000000 ( 0.000284) | |
delete last 0.000000 0.000000 0.000000 ( 0.000232) | |
find Alphonse 0.000000 0.000000 0.000000 ( 0.010202) | |
setting index (10000 rows) 0.000000 0.000000 0.000000 ( 0.024995) | |
find Alphonse (index set) 0.000000 0.000000 0.000000 ( 0.010075) | |
delete_keys_with_prefix "1" 0.380000 0.110000 0.490000 ( 0.691663) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment