wiecklabs / clipper

Clipper O/RM for JRuby

clipper / PERFORMANCE
100644 112 lines (91 sloc) 6.973 kb
raw blame history 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112

=================================================================
                          Jan. 23, 2008
=================================================================
                      user     system      total        real
JRUBY HSQLDB create   1.681000   0.000000   1.681000 (  1.680326)
JRUBY HSQLDB get      0.843000   0.000000   0.843000 (  0.842670)
                      user     system      total        real
DM-DO SQLITE create   1.060000   0.590000   1.650000 (  4.620537)
DM-DO SQLITE get      0.500000   0.030000   0.530000 (  0.532087)
=====================================================
 
=================================================================
                        Jan. 24, 2008 (MBA)
=================================================================
                      user     system      total        real
JRUBY HSQLDB create   2.719000   0.000000   2.719000 (  2.719288)
JRUBY HSQLDB get      0.732000   0.000000   0.732000 (  0.731762)
JRUBY HSQLDB all     12.393000   0.000000  12.393000 ( 12.392847)
 
                      user     system      total        real
DM-DO SQLITE create   1.710000   1.240000   2.950000 (  4.835382)
DM-DO SQLITE get      0.840000   0.050000   0.890000 (  0.902754)
DM-DO SQLITE all     53.710000   0.460000  54.170000 ( 54.557365)
 
 
======================================================================
                        Jan. 25, 2008 (MBA)
======================================================================
                               user     system      total        real
                             
worm mysql create x 1000   2.858000   0.000000   2.858000 (  2.858281)
worm mysql get x 1000      8.581000   0.000000   8.581000 (  8.581045)
worm mysql all x 10        1.511000   0.000000   1.511000 (  1.511578)
 
dm mysql create x 1000     1.290000   0.140000   1.430000 (  2.381986)
dm mysql get x 1000        0.770000   0.080000   0.850000 (  1.094205)
dm mysql all x 10          1.580000   0.020000   1.600000 (  1.670792)
 
worm hsqldb create x 1000  2.946000   0.000000   2.946000 (  2.945451)
worm hsqldb get x 1000     0.749000   0.000000   0.749000 (  0.749083)
worm hsqldb all x 10       1.282000   0.000000   1.282000 (  1.282925)
 
dm sqlite create x 1000    1.250000   0.020000   1.270000 (  1.285718)
dm sqlite get x 1000       0.820000   0.010000   0.830000 (  0.832020)
dm sqlite all x 10         1.650000   0.010000   1.660000 (  1.694394)
 
============================================================================
                                      user     system      total        real
worm hsqldb create x 1000         2.834000   0.000000   2.834000 (  2.834236)
worm hsqldb get x 1000            0.513000   0.000000   0.513000 (  0.513382)
worm hsqldb all x 10              0.950000   0.000000   0.950000 (  0.949387)
worm hsqldb all(id < 10) x 1000   0.782000   0.000000   0.782000 (  0.781668)
 
dm sqlite create x 1000           1.160000   0.020000   1.180000 (  1.234969)
dm sqlite get x 1000              0.810000   0.010000   0.820000 (  0.852053)
dm sqlite all x 10                1.720000   0.020000   1.740000 (  1.747608)
dm sqlite all(id < 10) x 1000     1.360000   0.010000   1.370000 (  1.372313)
 
 
===================================================================================
                                            user     system      total        real
worm hsqldb create x 1000               2.203000   0.000000   2.203000 (  2.202796)
worm hsqldb batch create 1000 records   1.883000   0.000000   1.883000 (  1.882832)
worm hsqldb get x 1000                  0.526000   0.000000   0.526000 (  0.525846)
worm hsqldb all x 10                    2.214000   0.000000   2.214000 (  2.213663)
worm hsqldb all(id < 10) x 1000         0.783000   0.000000   0.783000 (  0.782740)
 
dm sqlite create x 1000                 1.450000   0.010000   1.460000 (  1.493413)
dm sqlite batch create 1000 records     1.250000   0.020000   1.270000 (  1.311536)
dm sqlite get x 1000                    0.830000   0.010000   0.840000 (  0.835084)
dm sqlite all x 10                      3.610000   0.030000   3.640000 (  3.704670)
dm sqlite all(id < 10) x 1000           1.360000   0.020000   1.380000 (  1.410786)
 
worm mysql create x 1000                8.866000   0.000000   8.866000 (  8.865905)
worm mysql batch create 1000 records    1.879000   0.000000   1.879000 (  1.878763)
worm mysql get x 1000                   7.826000   0.000000   7.826000 (  7.826528)
worm mysql all x 10                     2.754000   0.000000   2.754000 (  2.754246)
worm mysql all(id < 10) x 1000          8.670000   0.000000   8.670000 (  8.670105)
                                      
dm mysql create x 1000                  2.020000   0.150000   2.170000 (  3.117812)
dm mysql batch create 1000 records      1.310000   0.130000   1.440000 (  2.319806)
dm mysql get x 1000                     0.780000   0.080000   0.860000 (  1.071209)
dm mysql all x 10                       3.270000   0.050000   3.320000 (  3.542396)
dm mysql all(id < 10) x 1000            1.100000   0.080000   1.180000 (  1.467613)
 
 
===================[ c3p0 connection pooling, default config ]=====================
                                            user     system      total        real
worm hsqldb create x 1000               1.866000   0.000000   1.866000 (  1.865487)
worm hsqldb batch create 1000 records   1.751000   0.000000   1.751000 (  1.751333)
worm hsqldb get x 1000                  0.493000   0.000000   0.493000 (  0.493073)
worm hsqldb all x 10                    2.384000   0.000000   2.384000 (  2.384220)
worm hsqldb all(id < 10) x 1000         0.827000   0.000000   0.827000 (  0.826086)
 
worm mysql create x 1000                2.375000   0.000000   2.375000 (  2.375025)
worm mysql batch create 1000 records    1.918000   0.000000   1.918000 (  1.918213)
worm mysql get x 1000                   0.696000   0.000000   0.696000 (  0.695261)
worm mysql all x 10                     2.612000   0.000000   2.612000 (  2.611171)
worm mysql all(id < 10) x 1000          1.460000   0.000000   1.460000 (  1.459856)
 
dm sqlite create x 1000                 1.440000   0.020000   1.460000 (  1.468180)
dm sqlite batch create 1000 records     1.240000   0.010000   1.250000 (  1.255686)
dm sqlite get x 1000                    0.820000   0.010000   0.830000 (  0.844022)
dm sqlite all x 10                      3.360000   0.020000   3.380000 (  3.408616)
dm sqlite all(id < 10) x 1000           1.340000   0.010000   1.350000 (  1.359224)
 
dm mysql create x 1000                  1.950000   0.130000   2.080000 (  2.897048)
dm mysql batch create 1000 records      1.150000   0.130000   1.280000 (  2.150448)
dm mysql get x 1000                     0.610000   0.060000   0.670000 (  0.837893)
dm mysql all x 10                       3.160000   0.020000   3.180000 (  3.310640)
dm mysql all(id < 10) x 1000            1.130000   0.070000   1.200000 (  1.455336)