-
Notifications
You must be signed in to change notification settings - Fork 6
/
BENCHMARKS
295 lines (290 loc) · 23.1 KB
/
BENCHMARKS
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
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
2015-11-09: removed data_id as parameter for data/summary queries. Pass postgres args as const refs. Added query benchmarks.
- SQLite:
db_query_parse.main: 5 runs, user: 9.93s (100.0%), sys: 0.37s (100.0%), total: 10.30s (100.0%)
db_query_parse.station: 5 runs, user: 0.15s (1.5%), sys: 0.00s (0.0%), total: 0.15s (1.5%)
db_query_parse.sdata: 5 runs, user: 2.03s (20.4%), sys: 0.10s (27.0%), total: 2.13s (20.7%)
db_query_parse.data: 5 runs, user: 7.75s (78.0%), sys: 0.27s (73.0%), total: 8.02s (77.9%)
db_import.main: 10 runs, user: 0.51s (100.0%), sys: 0.06s (100.0%), total: 0.57s (100.0%)
db_import.synop: 10 runs, user: 0.34s (66.7%), sys: 0.05s (83.3%), total: 0.39s (68.4%)
db_import.temp: 10 runs, user: 0.16s (31.4%), sys: 0.01s (16.7%), total: 0.17s (29.8%)
db_import.airplane: 10 runs, user: 0.01s (2.0%), sys: 0.00s (0.0%), total: 0.01s (1.8%)
db_query.main: 50 runs, user: 33.99s (100.0%), sys: 1.87s (100.0%), total: 35.86s (100.0%)
db_query.by_latlon: 50 runs, user: 30.25s (89.0%), sys: 1.67s (89.3%), total: 31.92s (89.0%)
db_query.by_dt: 50 runs, user: 1.35s (4.0%), sys: 0.06s (3.2%), total: 1.41s (3.9%)
db_query.by_latlon_dt: 50 runs, user: 2.35s (6.9%), sys: 0.14s (7.5%), total: 2.49s (6.9%)
db_query.by_varcode: 50 runs, user: 0.04s (0.1%), sys: 0.00s (0.0%), total: 0.04s (0.1%)
- MEMDB
db_query_parse.main: 5 runs, user: 0.13s (100.0%), sys: 0.00s (-nan%), total: 0.13s (100.0%)
db_query_parse.station: 5 runs, user: 0.00s (0.0%), sys: 0.00s (-nan%), total: 0.00s (0.0%)
db_query_parse.sdata: 5 runs, user: 0.03s (23.1%), sys: 0.00s (-nan%), total: 0.03s (23.1%)
db_query_parse.data: 5 runs, user: 0.10s (76.9%), sys: 0.00s (-nan%), total: 0.10s (76.9%)
db_import.main: 10 runs, user: 0.08s (100.0%), sys: 0.00s (-nan%), total: 0.08s (100.0%)
db_import.synop: 10 runs, user: 0.06s (75.0%), sys: 0.00s (-nan%), total: 0.06s (75.0%)
db_import.temp: 10 runs, user: 0.02s (25.0%), sys: 0.00s (-nan%), total: 0.02s (25.0%)
db_import.airplane: 10 runs, user: 0.00s (0.0%), sys: 0.00s (-nan%), total: 0.00s (0.0%)
db_query.main: 50 runs, user: 0.08s (100.0%), sys: 0.00s (-nan%), total: 0.08s (100.0%)
db_query.by_latlon: 50 runs, user: 0.07s (87.5%), sys: 0.00s (-nan%), total: 0.07s (87.5%)
db_query.by_dt: 50 runs, user: 0.01s (12.5%), sys: 0.00s (-nan%), total: 0.01s (12.5%)
db_query.by_latlon_dt: 50 runs, user: 0.00s (0.0%), sys: 0.00s (-nan%), total: 0.00s (0.0%)
db_query.by_varcode: 50 runs, user: 0.00s (0.0%), sys: 0.00s (-nan%), total: 0.00s (0.0%)
- PostgreSQL
db_query_parse.main: 5 runs, user: 4.79s (100.0%), sys: 0.78s (100.0%), total: 5.57s (100.0%)
db_query_parse.station: 5 runs, user: 0.11s (2.3%), sys: 0.04s (5.1%), total: 0.15s (2.7%)
db_query_parse.sdata: 5 runs, user: 1.03s (21.5%), sys: 0.13s (16.7%), total: 1.16s (20.8%)
db_query_parse.data: 5 runs, user: 3.65s (76.2%), sys: 0.61s (78.2%), total: 4.26s (76.5%)
db_import.main: 10 runs, user: 0.68s (100.0%), sys: 0.40s (100.0%), total: 1.08s (100.0%)
db_import.synop: 10 runs, user: 0.45s (66.2%), sys: 0.31s (77.5%), total: 0.76s (70.4%)
db_import.temp: 10 runs, user: 0.18s (26.5%), sys: 0.09s (22.5%), total: 0.27s (25.0%)
db_import.airplane: 10 runs, user: 0.05s (7.4%), sys: 0.00s (0.0%), total: 0.05s (4.6%)
db_query.main: 50 runs, user: 16.82s (100.0%), sys: 4.14s (100.0%), total: 20.96s (100.0%)
db_query.by_latlon: 50 runs, user: 14.88s (88.5%), sys: 3.67s (88.6%), total: 18.55s (88.5%)
db_query.by_dt: 50 runs, user: 0.70s (4.2%), sys: 0.16s (3.9%), total: 0.86s (4.1%)
db_query.by_latlon_dt: 50 runs, user: 1.24s (7.4%), sys: 0.31s (7.5%), total: 1.55s (7.4%)
db_query.by_varcode: 50 runs, user: 0.00s (0.0%), sys: 0.00s (0.0%), total: 0.00s (0.0%)
- MySQL
db_query_parse.main: 5 runs, user: 5.03s (100.0%), sys: 0.90s (100.0%), total: 5.93s (100.0%)
db_query_parse.station: 5 runs, user: 0.11s (2.2%), sys: 0.02s (2.2%), total: 0.13s (2.2%)
db_query_parse.sdata: 5 runs, user: 1.05s (20.9%), sys: 0.16s (17.8%), total: 1.21s (20.4%)
db_query_parse.data: 5 runs, user: 3.87s (76.9%), sys: 0.72s (80.0%), total: 4.59s (77.4%)
db_import.main: 10 runs, user: 1.35s (100.0%), sys: 0.88s (100.0%), total: 2.23s (100.0%)
db_import.synop: 10 runs, user: 0.88s (65.2%), sys: 0.56s (63.6%), total: 1.44s (64.6%)
db_import.temp: 10 runs, user: 0.44s (32.6%), sys: 0.31s (35.2%), total: 0.75s (33.6%)
db_import.airplane: 10 runs, user: 0.03s (2.2%), sys: 0.01s (1.1%), total: 0.04s (1.8%)
db_query.main: 50 runs, user: 16.71s (100.0%), sys: 3.86s (100.0%), total: 20.57s (100.0%)
db_query.by_latlon: 50 runs, user: 14.70s (88.0%), sys: 3.46s (89.6%), total: 18.16s (88.3%)
db_query.by_dt: 50 runs, user: 0.70s (4.2%), sys: 0.13s (3.4%), total: 0.83s (4.0%)
db_query.by_latlon_dt: 50 runs, user: 1.30s (7.8%), sys: 0.25s (6.5%), total: 1.55s (7.5%)
db_query.by_varcode: 50 runs, user: 0.01s (0.1%), sys: 0.02s (0.5%), total: 0.03s (0.1%)
2015-06-25: wreport3
- SQLite:
db_query_parse.main: 5 runs, user: 9.39s (100.0%), sys: 0.43s (100.0%), total: 9.82s (100.0%)
db_query_parse.station: 5 runs, user: 0.15s (1.6%), sys: 0.01s (2.3%), total: 0.16s (1.6%)
db_query_parse.sdata: 5 runs, user: 1.83s (19.5%), sys: 0.12s (27.9%), total: 1.95s (19.9%)
db_query_parse.data: 5 runs, user: 7.41s (78.9%), sys: 0.30s (69.8%), total: 7.71s (78.5%)
db_import.main: 10 runs, user: 0.60s (100.0%), sys: 0.02s (100.0%), total: 0.62s (100.0%)
db_import.synop: 10 runs, user: 0.40s (66.7%), sys: 0.01s (50.0%), total: 0.41s (66.1%)
db_import.temp: 10 runs, user: 0.20s (33.3%), sys: 0.01s (50.0%), total: 0.21s (33.9%)
db_import.airplane: 10 runs, user: 0.00s (0.0%), sys: 0.00s (0.0%), total: 0.00s (0.0%)
- MEMDB
db_query_parse.main: 5 runs, user: 0.19s (100.0%), sys: 0.00s (-nan%), total: 0.19s (100.0%)
db_query_parse.station: 5 runs, user: 0.01s (5.3%), sys: 0.00s (-nan%), total: 0.01s (5.3%)
db_query_parse.sdata: 5 runs, user: 0.04s (21.1%), sys: 0.00s (-nan%), total: 0.04s (21.1%)
db_query_parse.data: 5 runs, user: 0.14s (73.7%), sys: 0.00s (-nan%), total: 0.14s (73.7%)
db_import.main: 10 runs, user: 0.08s (100.0%), sys: 0.00s (-nan%), total: 0.08s (100.0%)
db_import.synop: 10 runs, user: 0.03s (37.5%), sys: 0.00s (-nan%), total: 0.03s (37.5%)
db_import.temp: 10 runs, user: 0.05s (62.5%), sys: 0.00s (-nan%), total: 0.05s (62.5%)
db_import.airplane: 10 runs, user: 0.00s (0.0%), sys: 0.00s (-nan%), total: 0.00s (0.0%)
- PostgreSQL
db_query_parse.main: 5 runs, user: 4.66s (100.0%), sys: 0.85s (100.0%), total: 5.51s (100.0%)
db_query_parse.station: 5 runs, user: 0.13s (2.8%), sys: 0.01s (1.2%), total: 0.14s (2.5%)
db_query_parse.sdata: 5 runs, user: 0.98s (21.0%), sys: 0.16s (18.8%), total: 1.14s (20.7%)
db_query_parse.data: 5 runs, user: 3.55s (76.2%), sys: 0.68s (80.0%), total: 4.23s (76.8%)
db_import.main: 10 runs, user: 0.74s (100.0%), sys: 0.37s (100.0%), total: 1.11s (100.0%)
db_import.synop: 10 runs, user: 0.55s (74.3%), sys: 0.27s (73.0%), total: 0.82s (73.9%)
db_import.temp: 10 runs, user: 0.17s (23.0%), sys: 0.09s (24.3%), total: 0.26s (23.4%)
db_import.airplane: 10 runs, user: 0.02s (2.7%), sys: 0.01s (2.7%), total: 0.03s (2.7%)
- MySQL
db_query_parse.main: 5 runs, user: 3.57s (100.0%), sys: 0.46s (100.0%), total: 4.03s (100.0%)
db_query_parse.station: 5 runs, user: 0.08s (2.2%), sys: 0.02s (4.3%), total: 0.10s (2.5%)
db_query_parse.sdata: 5 runs, user: 0.76s (21.3%), sys: 0.13s (28.3%), total: 0.89s (22.1%)
db_query_parse.data: 5 runs, user: 2.73s (76.5%), sys: 0.31s (67.4%), total: 3.04s (75.4%)
db_import.main: 10 runs, user: 1.57s (100.0%), sys: 0.98s (100.0%), total: 2.55s (100.0%)
db_import.synop: 10 runs, user: 0.97s (61.8%), sys: 0.62s (63.3%), total: 1.59s (62.4%)
db_import.temp: 10 runs, user: 0.58s (36.9%), sys: 0.34s (34.7%), total: 0.92s (36.1%)
db_import.airplane: 10 runs, user: 0.02s (1.3%), sys: 0.02s (2.0%), total: 0.04s (1.6%)
2015-06-25:
- SQLite:
db_query_parse.main: 5 runs, user: 9.21s (100.0%), sys: 0.30s (100.0%), total: 9.51s (100.0%)
db_query_parse.station: 5 runs, user: 0.15s (1.6%), sys: 0.01s (3.3%), total: 0.16s (1.7%)
db_query_parse.sdata: 5 runs, user: 1.89s (20.5%), sys: 0.08s (26.7%), total: 1.97s (20.7%)
db_query_parse.data: 5 runs, user: 7.17s (77.9%), sys: 0.21s (70.0%), total: 7.38s (77.6%)
db_import.main: 10 runs, user: 0.59s (100.0%), sys: 0.04s (100.0%), total: 0.63s (100.0%)
db_import.synop: 10 runs, user: 0.39s (66.1%), sys: 0.04s (100.0%), total: 0.43s (68.3%)
db_import.temp: 10 runs, user: 0.20s (33.9%), sys: 0.00s (0.0%), total: 0.20s (31.7%)
db_import.airplane: 10 runs, user: 0.00s (0.0%), sys: 0.00s (0.0%), total: 0.00s (0.0%)
- MEMDB
db_query_parse.main: 5 runs, user: 0.13s (100.0%), sys: 0.00s (-nan%), total: 0.13s (100.0%)
db_query_parse.station: 5 runs, user: 0.00s (0.0%), sys: 0.00s (-nan%), total: 0.00s (0.0%)
db_query_parse.sdata: 5 runs, user: 0.03s (23.1%), sys: 0.00s (-nan%), total: 0.03s (23.1%)
db_query_parse.data: 5 runs, user: 0.10s (76.9%), sys: 0.00s (-nan%), total: 0.10s (76.9%)
db_import.main: 10 runs, user: 0.09s (100.0%), sys: 0.00s (-nan%), total: 0.09s (100.0%)
db_import.synop: 10 runs, user: 0.05s (55.6%), sys: 0.00s (-nan%), total: 0.05s (55.6%)
db_import.temp: 10 runs, user: 0.03s (33.3%), sys: 0.00s (-nan%), total: 0.03s (33.3%)
db_import.airplane: 10 runs, user: 0.01s (11.1%), sys: 0.00s (-nan%), total: 0.01s (11.1%)
- PostgreSQL
db_query_parse.main: 5 runs, user: 4.98s (100.0%), sys: 0.80s (100.0%), total: 5.78s (100.0%)
db_query_parse.station: 5 runs, user: 0.13s (2.6%), sys: 0.02s (2.5%), total: 0.15s (2.6%)
db_query_parse.sdata: 5 runs, user: 1.03s (20.7%), sys: 0.14s (17.5%), total: 1.17s (20.2%)
db_query_parse.data: 5 runs, user: 3.82s (76.7%), sys: 0.64s (80.0%), total: 4.46s (77.2%)
db_import.main: 10 runs, user: 0.80s (100.0%), sys: 0.40s (100.0%), total: 1.20s (100.0%)
db_import.synop: 10 runs, user: 0.59s (73.8%), sys: 0.24s (60.0%), total: 0.83s (69.2%)
db_import.temp: 10 runs, user: 0.17s (21.2%), sys: 0.15s (37.5%), total: 0.32s (26.7%)
db_import.airplane: 10 runs, user: 0.04s (5.0%), sys: 0.01s (2.5%), total: 0.05s (4.2%)
- MySQL
db_query_parse.main: 5 runs, user: 3.57s (100.0%), sys: 0.57s (100.0%), total: 4.14s (100.0%)
db_query_parse.station: 5 runs, user: 0.09s (2.5%), sys: 0.02s (3.5%), total: 0.11s (2.7%)
db_query_parse.sdata: 5 runs, user: 0.73s (20.4%), sys: 0.13s (22.8%), total: 0.86s (20.8%)
db_query_parse.data: 5 runs, user: 2.75s (77.0%), sys: 0.42s (73.7%), total: 3.17s (76.6%)
db_import.main: 10 runs, user: 1.64s (100.0%), sys: 1.15s (100.0%), total: 2.79s (100.0%)
db_import.synop: 10 runs, user: 0.97s (59.1%), sys: 0.75s (65.2%), total: 1.72s (61.6%)
db_import.temp: 10 runs, user: 0.62s (37.8%), sys: 0.38s (33.0%), total: 1.00s (35.8%)
db_import.airplane: 10 runs, user: 0.05s (3.0%), sys: 0.02s (1.7%), total: 0.07s (2.5%)
2015-04-27:
- Record SQLite:
db_query_parse.main: 5 runs, user: 9.46s (100.0%), sys: 0.36s (100.0%), total: 9.82s (100.0%)
db_query_parse.station: 5 runs, user: 0.15s (1.6%), sys: 0.00s (0.0%), total: 0.15s (1.5%)
db_query_parse.sdata: 5 runs, user: 1.99s (21.0%), sys: 0.09s (25.0%), total: 2.08s (21.2%)
db_query_parse.data: 5 runs, user: 7.32s (77.4%), sys: 0.27s (75.0%), total: 7.59s (77.3%)
db_import.main: 10 runs, user: 0.60s (100.0%), sys: 0.03s (100.0%), total: 0.63s (100.0%)
db_import.synop: 10 runs, user: 0.39s (65.0%), sys: 0.01s (33.3%), total: 0.40s (63.5%)
db_import.temp: 10 runs, user: 0.19s (31.7%), sys: 0.02s (66.7%), total: 0.21s (33.3%)
db_import.airplane: 10 runs, user: 0.02s (3.3%), sys: 0.00s (0.0%), total: 0.02s (3.2%)
- Query SQLite:
db_query_parse.main: 5 runs, user: 9.09s (100.0%), sys: 0.37s (100.0%), total: 9.46s (100.0%)
db_query_parse.station: 5 runs, user: 0.14s (1.5%), sys: 0.02s (5.4%), total: 0.16s (1.7%)
db_query_parse.sdata: 5 runs, user: 1.88s (20.7%), sys: 0.09s (24.3%), total: 1.97s (20.8%)
db_query_parse.data: 5 runs, user: 7.07s (77.8%), sys: 0.26s (70.3%), total: 7.33s (77.5%)
db_import.main: 10 runs, user: 0.60s (100.0%), sys: 0.04s (100.0%), total: 0.64s (100.0%)
db_import.synop: 10 runs, user: 0.38s (63.3%), sys: 0.03s (75.0%), total: 0.41s (64.1%)
db_import.temp: 10 runs, user: 0.21s (35.0%), sys: 0.01s (25.0%), total: 0.22s (34.4%)
db_import.airplane: 10 runs, user: 0.01s (1.7%), sys: 0.00s (0.0%), total: 0.01s (1.6%)
- Record MEMDB:
db_query_parse.main: 5 runs, user: 0.15s (100.0%), sys: 0.01s (100.0%), total: 0.16s (100.0%)
db_query_parse.station: 5 runs, user: 0.00s (0.0%), sys: 0.01s (100.0%), total: 0.01s (6.2%)
db_query_parse.sdata: 5 runs, user: 0.02s (13.3%), sys: 0.00s (0.0%), total: 0.02s (12.5%)
db_query_parse.data: 5 runs, user: 0.13s (86.7%), sys: 0.00s (0.0%), total: 0.13s (81.2%)
db_import.main: 10 runs, user: 0.09s (100.0%), sys: 0.00s (-nan%), total: 0.09s (100.0%)
db_import.synop: 10 runs, user: 0.05s (55.6%), sys: 0.00s (-nan%), total: 0.05s (55.6%)
db_import.temp: 10 runs, user: 0.04s (44.4%), sys: 0.00s (-nan%), total: 0.04s (44.4%)
db_import.airplane: 10 runs, user: 0.00s (0.0%), sys: 0.00s (-nan%), total: 0.00s (0.0%)
- Query MEMDB:
db_query_parse.main: 5 runs, user: 0.13s (100.0%), sys: 0.00s (-nan%), total: 0.13s (100.0%)
db_query_parse.station: 5 runs, user: 0.01s (7.7%), sys: 0.00s (-nan%), total: 0.01s (7.7%)
db_query_parse.sdata: 5 runs, user: 0.02s (15.4%), sys: 0.00s (-nan%), total: 0.02s (15.4%)
db_query_parse.data: 5 runs, user: 0.10s (76.9%), sys: 0.00s (-nan%), total: 0.10s (76.9%)
db_import.main: 10 runs, user: 0.07s (100.0%), sys: 0.00s (-nan%), total: 0.07s (100.0%)
db_import.synop: 10 runs, user: 0.03s (42.9%), sys: 0.00s (-nan%), total: 0.03s (42.9%)
db_import.temp: 10 runs, user: 0.04s (57.1%), sys: 0.00s (-nan%), total: 0.04s (57.1%)
db_import.airplane: 10 runs, user: 0.00s (0.0%), sys: 0.00s (-nan%), total: 0.00s (0.0%)
- Record PostgreSQL:
db_query_parse.main: 5 runs, user: 3.92s (100.0%), sys: 0.88s (100.0%), total: 4.80s (100.0%)
db_query_parse.station: 5 runs, user: 0.07s (1.8%), sys: 0.00s (0.0%), total: 0.07s (1.5%)
db_query_parse.sdata: 5 runs, user: 0.82s (20.9%), sys: 0.18s (20.5%), total: 1.00s (20.8%)
db_query_parse.data: 5 runs, user: 3.03s (77.3%), sys: 0.70s (79.5%), total: 3.73s (77.7%)
db_import.main: 10 runs, user: 0.74s (100.0%), sys: 0.41s (100.0%), total: 1.15s (100.0%)
db_import.synop: 10 runs, user: 0.52s (70.3%), sys: 0.27s (65.9%), total: 0.79s (68.7%)
db_import.temp: 10 runs, user: 0.19s (25.7%), sys: 0.13s (31.7%), total: 0.32s (27.8%)
db_import.airplane: 10 runs, user: 0.03s (4.1%), sys: 0.01s (2.4%), total: 0.04s (3.5%)
Query PostgreSQL:
db_query_parse.main: 5 runs, user: 3.65s (100.0%), sys: 0.75s (100.0%), total: 4.40s (100.0%)
db_query_parse.station: 5 runs, user: 0.06s (1.6%), sys: 0.04s (5.3%), total: 0.10s (2.3%)
db_query_parse.sdata: 5 runs, user: 0.73s (20.0%), sys: 0.14s (18.7%), total: 0.87s (19.8%)
db_query_parse.data: 5 runs, user: 2.86s (78.4%), sys: 0.57s (76.0%), total: 3.43s (78.0%)
db_import.main: 10 runs, user: 0.68s (100.0%), sys: 0.46s (100.0%), total: 1.14s (100.0%)
db_import.synop: 10 runs, user: 0.46s (67.6%), sys: 0.34s (73.9%), total: 0.80s (70.2%)
db_import.temp: 10 runs, user: 0.20s (29.4%), sys: 0.12s (26.1%), total: 0.32s (28.1%)
db_import.airplane: 10 runs, user: 0.02s (2.9%), sys: 0.00s (0.0%), total: 0.02s (1.8%)
Record MySQL:
db_query_parse.main: 5 runs, user: 2.76s (100.0%), sys: 0.60s (100.0%), total: 3.36s (100.0%)
db_query_parse.station: 5 runs, user: 0.05s (1.8%), sys: 0.03s (5.0%), total: 0.08s (2.4%)
db_query_parse.sdata: 5 runs, user: 0.54s (19.6%), sys: 0.15s (25.0%), total: 0.69s (20.5%)
db_query_parse.data: 5 runs, user: 2.17s (78.6%), sys: 0.42s (70.0%), total: 2.59s (77.1%)
db_import.main: 10 runs, user: 1.60s (100.0%), sys: 0.90s (100.0%), total: 2.50s (100.0%)
db_import.synop: 10 runs, user: 0.96s (60.0%), sys: 0.58s (64.4%), total: 1.54s (61.6%)
db_import.temp: 10 runs, user: 0.57s (35.6%), sys: 0.30s (33.3%), total: 0.87s (34.8%)
db_import.airplane: 10 runs, user: 0.07s (4.4%), sys: 0.02s (2.2%), total: 0.09s (3.6%)
Query MySQL:
db_query_parse.main: 5 runs, user: 2.56s (100.0%), sys: 0.59s (100.0%), total: 3.15s (100.0%)
db_query_parse.station: 5 runs, user: 0.06s (2.3%), sys: 0.02s (3.4%), total: 0.08s (2.5%)
db_query_parse.sdata: 5 runs, user: 0.51s (19.9%), sys: 0.14s (23.7%), total: 0.65s (20.6%)
db_query_parse.data: 5 runs, user: 1.99s (77.7%), sys: 0.43s (72.9%), total: 2.42s (76.8%)
db_import.main: 10 runs, user: 1.47s (100.0%), sys: 1.07s (100.0%), total: 2.54s (100.0%)
db_import.synop: 10 runs, user: 0.94s (63.9%), sys: 0.68s (63.6%), total: 1.62s (63.8%)
db_import.temp: 10 runs, user: 0.48s (32.7%), sys: 0.37s (34.6%), total: 0.85s (33.5%)
db_import.airplane: 10 runs, user: 0.05s (3.4%), sys: 0.02s (1.9%), total: 0.07s (2.8%)
2015-04-17:
- postgres: benchmark db_import_v6
- initial:
db_import.main: 5 runs, user: 1.33s (100.0%), sys: 1.11s (100.0%), total: 2.44s (100.0%)
db_import.synop: 5 runs, user: 0.99s (74.4%), sys: 0.87s (78.4%), total: 1.86s (76.2%)
db_import.temp: 5 runs, user: 0.32s (24.1%), sys: 0.22s (19.8%), total: 0.54s (22.1%)
db_import.airplane: 5 runs, user: 0.02s (1.5%), sys: 0.02s (1.8%), total: 0.04s (1.6%)
- std::string -> const char*
db_import.main: 5 runs, user: 1.27s (100.0%), sys: 1.03s (100.0%), total: 2.30s (100.0%)
db_import.synop: 5 runs, user: 0.98s (77.2%), sys: 0.80s (77.7%), total: 1.78s (77.4%)
db_import.temp: 5 runs, user: 0.27s (21.3%), sys: 0.22s (21.4%), total: 0.49s (21.3%)
db_import.airplane: 5 runs, user: 0.02s (1.6%), sys: 0.01s (1.0%), total: 0.03s (1.3%)
- station attrs via bulk insert
db_import.main: 5 runs, user: 1.25s (100.0%), sys: 1.04s (100.0%), total: 2.29s (100.0%)
db_import.synop: 5 runs, user: 0.94s (75.2%), sys: 0.78s (75.0%), total: 1.72s (75.1%)
db_import.temp: 5 runs, user: 0.30s (24.0%), sys: 0.25s (24.0%), total: 0.55s (24.0%)
db_import.airplane: 5 runs, user: 0.01s (0.8%), sys: 0.01s (1.0%), total: 0.02s (0.9%)
- data via bulk insert
db_import.main: 5 runs, user: 0.53s (100.0%), sys: 0.40s (100.0%), total: 0.93s (100.0%)
db_import.synop: 5 runs, user: 0.41s (77.4%), sys: 0.37s (92.5%), total: 0.78s (83.9%)
db_import.temp: 5 runs, user: 0.11s (20.8%), sys: 0.02s (5.0%), total: 0.13s (14.0%)
db_import.airplane: 5 runs, user: 0.01s (1.9%), sys: 0.01s (2.5%), total: 0.02s (2.2%)
- data via bulk insert, refactored with AnnotateV6
db_import.main: 5 runs, user: 0.50s (100.0%), sys: 0.39s (100.0%), total: 0.89s (100.0%)
db_import.synop: 5 runs, user: 0.43s (86.0%), sys: 0.33s (84.6%), total: 0.76s (85.4%)
db_import.temp: 5 runs, user: 0.07s (14.0%), sys: 0.06s (15.4%), total: 0.13s (14.6%)
db_import.airplane: 5 runs, user: 0.00s (0.0%), sys: 0.00s (0.0%), total: 0.00s (0.0%)
- attrs via bulk insert
db_import.main: 5 runs, user: 0.33s (100.0%), sys: 0.20s (100.0%), total: 0.53s (100.0%)
db_import.synop: 5 runs, user: 0.24s (72.7%), sys: 0.14s (70.0%), total: 0.38s (71.7%)
db_import.temp: 5 runs, user: 0.09s (27.3%), sys: 0.04s (20.0%), total: 0.13s (24.5%)
db_import.airplane: 5 runs, user: 0.00s (0.0%), sys: 0.02s (10.0%), total: 0.02s (3.8%)
- sqlite: benchmark db_import_v6
- initial:
db_import.main: 5 runs, user: 0.28s (100.0%), sys: 0.01s (100.0%), total: 0.29s (100.0%)
db_import.synop: 5 runs, user: 0.17s (60.7%), sys: 0.01s (100.0%), total: 0.18s (62.1%)
db_import.temp: 5 runs, user: 0.11s (39.3%), sys: 0.00s (0.0%), total: 0.11s (37.9%)
db_import.airplane: 5 runs, user: 0.00s (0.0%), sys: 0.00s (0.0%), total: 0.00s (0.0%)
- after for-auto& and const char* fixes
db_import.main: 5 runs, user: 0.27s (100.0%), sys: 0.02s (100.0%), total: 0.29s (100.0%)
db_import.synop: 5 runs, user: 0.17s (63.0%), sys: 0.01s (50.0%), total: 0.18s (62.1%)
db_import.temp: 5 runs, user: 0.10s (37.0%), sys: 0.01s (50.0%), total: 0.11s (37.9%)
db_import.airplane: 5 runs, user: 0.00s (0.0%), sys: 0.00s (0.0%), total: 0.00s (0.0%)
- data via bulk insert
db_import.main: 5 runs, user: 0.29s (100.0%), sys: 0.04s (100.0%), total: 0.33s (100.0%)
db_import.synop: 5 runs, user: 0.18s (62.1%), sys: 0.03s (75.0%), total: 0.21s (63.6%)
db_import.temp: 5 runs, user: 0.10s (34.5%), sys: 0.01s (25.0%), total: 0.11s (33.3%)
db_import.airplane: 5 runs, user: 0.01s (3.4%), sys: 0.00s (0.0%), total: 0.01s (3.0%)
- no change: we operate locally, sqlite has safe upsert, there is no
point bundling inserts and updates to save in latency, so nothing
really changes.
- attr via bulk insert
db_import.main: 5 runs, user: 0.37s (100.0%), sys: 0.02s (100.0%), total: 0.39s (100.0%)
db_import.synop: 5 runs, user: 0.24s (64.9%), sys: 0.01s (50.0%), total: 0.25s (64.1%)
db_import.temp: 5 runs, user: 0.12s (32.4%), sys: 0.00s (0.0%), total: 0.12s (30.8%)
db_import.airplane: 5 runs, user: 0.01s (2.7%), sys: 0.01s (50.0%), total: 0.02s (5.1%)
- odbc-mysql: benchmark db_import_v6
- initial:
db_import.main: 5 runs, user: 1.34s (100.0%), sys: 0.80s (100.0%), total: 2.14s (100.0%)
db_import.synop: 5 runs, user: 0.82s (61.2%), sys: 0.47s (58.8%), total: 1.29s (60.3%)
db_import.temp: 5 runs, user: 0.49s (36.6%), sys: 0.32s (40.0%), total: 0.81s (37.9%)
db_import.airplane: 5 runs, user: 0.03s (2.2%), sys: 0.01s (1.2%), total: 0.04s (1.9%)
- data via bulk insert
db_import.main: 5 runs, user: 1.29s (100.0%), sys: 0.85s (100.0%), total: 2.14s (100.0%)
db_import.synop: 5 runs, user: 0.77s (59.7%), sys: 0.51s (60.0%), total: 1.28s (59.8%)
db_import.temp: 5 runs, user: 0.51s (39.5%), sys: 0.31s (36.5%), total: 0.82s (38.3%)
db_import.airplane: 5 runs, user: 0.01s (0.8%), sys: 0.03s (3.5%), total: 0.04s (1.9%)
- no change: mysql has upsert (of dubious safety), and odbc does not
allow to bundle inserts and updates to save in latency, so nothing
really changes.
- mysql:
- bulk:
db_import.main: 5 runs, user: 0.68s (100.0%), sys: 0.60s (100.0%), total: 1.28s (100.0%)
db_import.synop: 5 runs, user: 0.39s (57.4%), sys: 0.42s (70.0%), total: 0.81s (63.3%)
db_import.temp: 5 runs, user: 0.26s (38.2%), sys: 0.18s (30.0%), total: 0.44s (34.4%)
db_import.airplane: 5 runs, user: 0.03s (4.4%), sys: 0.00s (0.0%), total: 0.03s (2.3%)
- non-bulk:
db_import.main: 5 runs, user: 0.66s (100.0%), sys: 0.64s (100.0%), total: 1.30s (100.0%)
db_import.synop: 5 runs, user: 0.37s (56.1%), sys: 0.42s (65.6%), total: 0.79s (60.8%)
db_import.temp: 5 runs, user: 0.28s (42.4%), sys: 0.20s (31.2%), total: 0.48s (36.9%)
db_import.airplane: 5 runs, user: 0.01s (1.5%), sys: 0.02s (3.1%), total: 0.03s (2.3%)
- bulk attrs:
db_import.main: 5 runs, user: 0.71s (100.0%), sys: 0.57s (100.0%), total: 1.28s (100.0%)
db_import.synop: 5 runs, user: 0.45s (63.4%), sys: 0.35s (61.4%), total: 0.80s (62.5%)
db_import.temp: 5 runs, user: 0.26s (36.6%), sys: 0.21s (36.8%), total: 0.47s (36.7%)
db_import.airplane: 5 runs, user: 0.00s (0.0%), sys: 0.01s (1.8%), total: 0.01s (0.8%)