simple swift associations benchmarks

gistfile1.txt

bharanee@tardis $ ./simple.rb -s swift -s dm -r 1000 

-- driver: sqlite3 rows: 1000 runs: 5 --

benchmark       	sys     	user    	total   	real    	rss
swift #create   	0.060000	0.370000	0.430000	0.431087	18.81m
swift #select   	0.000000	0.020000	0.020000	0.027583	3.56m
swift #update   	0.070000	1.760000	1.830000	1.836255	77.74m
dm #create      	0.120000	1.640000	1.760000	1.799292	119.61m
dm #select      	0.050000	0.760000	0.810000	0.812489	49.06m
dm #update      	0.280000	5.710000	5.990000	5.994204	541.14m

bharanee@tardis $ ./simple.rb -s swift -s dm -r 1000 -d mysql

-- driver: mysql rows: 1000 runs: 5 --

benchmark       	sys     	user    	total   	real    	rss
swift #create   	0.150000	0.360000	0.510000	1.524913	20.02m
swift #select   	0.000000	0.010000	0.010000	0.027542	2.84m
swift #update   	0.220000	0.850000	1.070000	2.246216	98.10m
dm #create      	0.100000	1.680000	1.780000	2.109504	119.48m
dm #select      	0.000000	0.980000	0.980000	0.988341	58.86m
dm #update      	0.360000	5.590000	5.950000	6.779374	541.13m


bharanee@tardis $ ./simple.rb -s swift -s dm -r 1000 -d postgresql

-- driver: postgresql rows: 1000 runs: 5 --

benchmark       	sys     	user    	total   	real    	rss
swift #create   	0.170000	0.340000	0.510000	1.124462	22.04m
swift #select   	0.000000	0.010000	0.010000	0.022007	2.61m
swift #update   	0.270000	1.000000	1.270000	3.265552	65.11m
dm #create      	0.170000	1.630000	1.800000	2.003855	120.81m
dm #select      	0.060000	0.710000	0.770000	0.790215	49.12m
dm #update      	0.340000	5.580000	5.920000	6.094355	541.36m