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)
) is private.
