Project

General

Profile

Vysledky mongo » dbtest_mongo_final.txt

Tomáš Plesník, 10/11/2016 07:56 AM

 
1
MongoDB
2
Running testplan
3
!2016-08-26T14:49:02 Init
4
TS1.1: Impact of fragmentation on INSERT
5
!2016-08-26T14:56:42 TS1.1
6
Run	Empty [s]	First [s]	Middle [s]	Delete [s]	Fragmented [s]
7
1	127.922201	129.392131	129.354367	7.603520	130.301279
8
2	130.302063	129.946774	132.418760	7.608551	131.156769
9
3	129.552224	128.700161	132.994419	7.542808	130.664446
10
4	126.847849	127.684087	131.240836	7.597966	130.372580
11
5	129.696564	128.195218	132.982633	7.562814	130.898716
12
6	128.377722	126.907665	130.065722	7.521640	130.169196
13
7	129.502944	128.030488	131.437991	7.643319	131.553265
14
8	129.240116	129.007747	130.110507	7.581124	131.880039
15
9	130.553518	128.646558	132.235081	7.515750	131.059796
16
TS1.2: Impact of indexing and fragmentation on INSERT
17
!2016-08-26T16:16:58 TS1.2
18
Run	Empty [s]	First [s]	Middle [s]	Delete [s]	Fragmented [s]
19
1	173.647710	177.968113	183.993663	30.069588	184.758466
20
2	173.629722	178.415824	183.969028	30.070325	186.556422
21
3	174.022939	176.095028	182.031965	30.170620	184.657400
22
4	175.535268	177.974228	184.986954	29.766625	185.885353
23
5	175.615344	179.148640	187.290543	30.439705	187.112232
24
6	174.830304	178.366894	182.815570	30.042563	185.856504
25
7	173.601921	177.102745	182.955350	30.025276	184.144057
26
8	176.025728	177.213952	184.054311	30.023341	185.719333
27
9	175.469983	176.546728	184.125221	30.591613	185.935915
28
TS1.3: Index creation timing
29
!2016-08-26T18:10:56 TS1.3
30
Run	INSERT [s]	DetectTime [s]	ts [s]		Name [s]	!Detector [s]	Src IP [s]	!Src Range [s]
31
1	394.282975	6.756382	4.112482	17.050397	22.302891	8.520851	11.711954
32
2	394.209425	6.736578	4.117324	17.118401	22.194257	8.574414	11.774997
33
3	390.860696	6.710911	4.086974	17.112138	22.305206	8.593174	11.757838
34
4	391.908978	6.699310	4.100555	17.210869	22.235549	8.535727	11.632488
35
5	397.137158	6.729598	4.116091	17.489018	22.386854	8.523736	11.559902
36
6	391.927438	6.690400	4.126439	17.397926	22.480825	8.386318	11.796966
37
7	396.679676	6.602872	4.042784	16.909235	22.115287	8.416613	11.833548
38
8	394.259255	6.670743	4.076836	16.968165	22.299115	8.469255	11.620068
39
9	393.093860	6.720491	4.070675	16.935772	22.103473	8.478802	11.750964
40
TS1.4: Impact of indexing on INSERT time
41
!2016-08-26T19:21:39 TS1.4
42
Run	DetectTime [s]	ts [s]		Name [s]	!Detector [s]	Src IP [s]	!Src Range [s]	INSERT [s]
43
1	0.095333	0.007732	0.007909	0.009209	0.008688	0.008170	542.007565
44
2	0.028094	0.004556	0.005994	0.006236	0.005891	0.005027	551.804655
45
3	0.031046	0.004694	0.006085	0.008681	0.008709	0.004849	549.001550
46
4	0.035373	0.009057	0.007306	0.006811	0.007153	0.008803	546.248195
47
5	0.035590	0.009269	0.008941	0.009804	0.009003	0.006746	545.113158
48
6	0.036306	0.005918	0.007224	0.009196	0.007952	0.008808	552.632978
49
7	0.038022	0.008932	0.008672	0.008664	0.008570	0.009038	547.686718
50
8	0.072588	0.009210	0.008470	0.007839	0.007578	0.008251	546.923785
51
9	0.037439	0.009226	0.009427	0.008425	0.005091	0.008515	547.406995
52
TS2.1: Cold read
53
!2016-08-26T20:45:10 TS2.1
54
Query		Run	find [s]	sort [s]	iterate [s]	Results [-]	Total Time [s]
55
MENTAT         	1      	0.000283	0.000187	511.033009	6747529   	511.035800
56
MENTAT         	2      	0.000268	0.000187	515.743728	6747529   	515.746490
57
MENTAT         	3      	0.000262	0.000187	420.844979	6747529   	420.847032
58
MENTAT         	4      	0.000265	0.000187	508.426094	6747529   	508.427047
59
MENTAT         	5      	0.000267	0.000189	507.606699	6747529   	507.607818
60
MENTAT         	6      	0.000268	0.000190	506.150227	6747529   	506.151223
61
MENTAT         	7      	0.000264	0.000188	509.515272	6747529   	509.517369
62
MENTAT         	8      	0.000264	0.000185	520.272144	6747529   	520.274866
63
MENTAT         	9      	0.000268	0.000186	418.551855	6747529   	418.553592
64
HAWAT1         	1      	0.000263	0.000193	86.109275	364527    	86.109964
65
HAWAT1         	2      	0.000268	0.000190	86.152511	364527    	86.153862
66
HAWAT1         	3      	0.000267	0.000192	85.538912	364527    	85.540184
67
HAWAT1         	4      	0.000268	0.000188	84.850769	364527    	84.851902
68
HAWAT1         	5      	0.000271	0.000194	81.707942	364527    	81.708961
69
HAWAT1         	6      	0.000268	0.000193	85.110888	364527    	85.112008
70
HAWAT1         	7      	0.000273	0.000193	78.681353	364527    	78.682369
71
HAWAT1         	8      	0.000267	0.000188	86.021770	364527    	86.022532
72
HAWAT1         	9      	0.000302	0.000195	78.741570	364527    	78.742354
73
HAWAT2         	1      	0.000268	0.000190	87.096650	72334     	87.097303
74
HAWAT2         	2      	0.000266	0.000198	87.789435	72334     	87.790144
75
HAWAT2         	3      	0.000268	0.000211	88.842009	72334     	88.842721
76
HAWAT2         	4      	0.000269	0.000196	88.513749	72334     	88.514447
77
HAWAT2         	5      	0.000290	0.000196	87.926340	72334     	87.927062
78
HAWAT2         	6      	0.000267	0.000195	88.451478	72334     	88.452186
79
HAWAT2         	7      	0.000271	0.000196	87.127282	72334     	87.127966
80
HAWAT2         	8      	0.000263	0.000198	88.195420	72334     	88.196128
81
HAWAT2         	9      	0.000270	0.000195	90.182639	72334     	90.183338
82
HAWAT3         	1      	0.000269	0.000195	490.509768	6237248   	490.511532
83
HAWAT3         	2      	0.000270	0.000190	432.371037	6237248   	432.372198
84
HAWAT3         	3      	0.000144	0.000096	454.269072	6237248   	454.269495
85
HAWAT3         	4      	0.000266	0.000184	475.578615	6237248   	475.579316
86
HAWAT3         	5      	0.000263	0.000183	461.287815	6237248   	461.289052
87
HAWAT3         	6      	0.000268	0.000184	479.793021	6237248   	479.793863
88
HAWAT3         	7      	0.000265	0.000187	487.537971	6237248   	487.539051
89
HAWAT3         	8      	0.000267	0.000188	479.156575	6237248   	479.158198
90
HAWAT3         	9      	0.000293	0.000195	418.960975	6237248   	418.962579
91
HAWAT4         	1      	0.000263	0.000189	97.757782	961836    	97.759354
92
HAWAT4         	2      	0.000268	0.000191	88.001651	961836    	88.002373
93
HAWAT4         	3      	0.000267	0.000187	99.461632	961836    	99.462742
94
HAWAT4         	4      	0.000271	0.000189	94.231371	961836    	94.232250
95
HAWAT4         	5      	0.000272	0.000189	94.985798	961836    	94.986669
96
HAWAT4         	6      	0.000267	0.000189	98.964201	961836    	98.965096
97
HAWAT4         	7      	0.000268	0.000188	98.502563	961836    	98.503450
98
HAWAT4         	8      	0.000268	0.000188	98.322375	961836    	98.323237
99
HAWAT4         	9      	0.000265	0.000189	97.203095	961836    	97.204188
100
HAWAT5         	1      	0.000264	0.000185	101.429182	961071    	101.429867
101
HAWAT5         	2      	0.000269	0.000187	93.023187	961071    	93.023861
102
HAWAT5         	3      	0.000273	0.000186	101.553183	961071    	101.553852
103
HAWAT5         	4      	0.000298	0.000185	102.023856	961071    	102.024561
104
HAWAT5         	5      	0.000269	0.000203	100.491724	961071    	100.492429
105
HAWAT5         	6      	0.000305	0.000184	101.747961	961071    	101.748663
106
HAWAT5         	7      	0.000268	0.000188	94.446469	961071    	94.447141
107
HAWAT5         	8      	0.000272	0.000185	98.728326	961071    	98.729004
108
HAWAT5         	9      	0.000275	0.000206	101.019464	961071    	101.020175
109
HAWAT6         	1      	0.000268	0.000183	79.173390	364527    	79.174537
110
HAWAT6         	2      	0.000270	0.000190	86.328840	364527    	86.329747
111
HAWAT6         	3      	0.000269	0.000188	79.272074	364527    	79.272844
112
HAWAT6         	4      	0.000273	0.000187	85.984156	364527    	85.984929
113
HAWAT6         	5      	0.000270	0.000212	86.358828	364527    	86.360034
114
HAWAT6         	6      	0.000270	0.000210	85.367100	364527    	85.367907
115
HAWAT6         	7      	0.000263	0.000206	81.383568	364527    	81.384375
116
HAWAT6         	8      	0.000265	0.000186	79.754849	364527    	79.755697
117
HAWAT6         	9      	0.000269	0.000189	86.168911	364527    	86.169820
118
HAWAT7         	1      	0.000268	0.000185	91.493113	68964     	91.494022
119
HAWAT7         	2      	0.000270	0.000190	92.099406	68964     	92.100378
120
HAWAT7         	3      	0.000271	0.000205	92.915546	68964     	92.916550
121
HAWAT7         	4      	0.000276	0.000211	92.386829	68964     	92.387583
122
HAWAT7         	5      	0.000268	0.000187	91.476902	68964     	91.477834
123
HAWAT7         	6      	0.000274	0.000193	92.603941	68964     	92.605127
124
HAWAT7         	7      	0.000270	0.000208	92.466109	68964     	92.467113
125
HAWAT7         	8      	0.000271	0.000192	92.373811	68964     	92.374530
126
HAWAT7         	9      	0.000273	0.000196	94.189761	68964     	94.190721
127
TS2.2: Hot read
128
!2016-08-27T00:38:02 TS2.2
129
Query		Run	find [s]	sort [s]	iterate [s]	Results [-]	Total Time [s]
130
HAWAT1         	COLD1  	0.000271	0.000195	86.350134	364527    	86.351100
131
HAWAT1         	HOT1   	0.000056	0.000065	59.839078	364525    	59.839830
132
HAWAT2         	COLD1  	0.000266	0.000194	88.124338	72334     	88.125024
133
HAWAT2         	HOT1   	0.000045	0.000054	51.832817	72334     	51.832992
134
HAWAT3         	COLD1  	0.000273	0.000198	480.688220	6237248   	480.689853
135
HAWAT3         	HOT1   	0.000056	0.000050	374.665166	6237343   	374.666367
136
HAWAT4         	COLD1  	0.000269	0.000192	98.394072	961836    	98.394850
137
HAWAT4         	HOT1   	0.000056	0.000050	61.603166	961836    	61.603455
138
HAWAT5         	COLD1  	0.000273	0.000193	92.285556	961071    	92.286211
139
HAWAT5         	HOT1   	0.000051	0.000045	65.179411	961071    	65.179566
140
HAWAT6         	COLD1  	0.000268	0.000191	80.367874	364527    	80.369202
141
HAWAT6         	HOT1   	0.000056	0.000050	59.492005	364525    	59.492206
142
HAWAT7         	COLD1  	0.000263	0.000193	92.588143	68964     	92.589450
143
HAWAT7         	HOT1   	0.000057	0.000049	50.524505	68964     	50.524996
144
HAWAT1         	COLD2  	0.000269	0.000195	79.422035	364527    	79.423050
145
HAWAT1         	HOT2   	0.000056	0.000049	56.223618	364525    	56.224339
146
HAWAT2         	COLD2  	0.000319	0.000193	88.068263	72334     	88.068986
147
HAWAT2         	HOT2   	0.000049	0.000042	51.055803	72334     	51.055965
148
HAWAT3         	COLD2  	0.000270	0.000196	488.767272	6237248   	488.769152
149
HAWAT3         	HOT2   	0.000058	0.000067	465.471592	6237343   	465.473117
150
HAWAT4         	COLD2  	0.000269	0.000191	97.345328	961836    	97.346322
151
HAWAT4         	HOT2   	0.000055	0.000064	71.348367	961836    	71.348870
152
HAWAT5         	COLD2  	0.000274	0.000190	93.040005	961071    	93.040659
153
HAWAT5         	HOT2   	0.000051	0.000044	68.285577	961071    	68.285740
154
HAWAT6         	COLD2  	0.000269	0.000194	86.099274	364527    	86.100787
155
HAWAT6         	HOT2   	0.000056	0.000065	59.075523	364525    	59.075996
156
HAWAT7         	COLD2  	0.000268	0.000192	92.084753	68964     	92.085677
157
HAWAT7         	HOT2   	0.000057	0.000050	50.771242	68964     	50.771631
158
HAWAT1         	COLD3  	0.000269	0.000196	84.866414	364527    	84.867539
159
HAWAT1         	HOT3   	0.000056	0.000065	58.278766	364525    	58.279309
160
HAWAT2         	COLD3  	0.000274	0.000191	86.297139	72334     	86.297853
161
HAWAT2         	HOT3   	0.000046	0.000041	54.607638	72334     	54.607778
162
HAWAT3         	COLD3  	0.000268	0.000197	413.218996	6237248   	413.220676
163
HAWAT3         	HOT3   	0.000055	0.000064	436.428298	6237343   	436.429414
164
HAWAT4         	COLD3  	0.000274	0.000192	106.867295	961836    	106.868316
165
HAWAT4         	HOT3   	0.000056	0.000066	70.525083	961836    	70.525443
166
HAWAT5         	COLD3  	0.000118	0.000084	110.904617	961071    	110.904935
167
HAWAT5         	HOT3   	0.000048	0.000057	75.227087	961071    	75.227395
168
HAWAT6         	COLD3  	0.000271	0.000188	80.026302	364527    	80.028014
169
HAWAT6         	HOT3   	0.000058	0.000051	56.913023	364525    	56.914016
170
HAWAT7         	COLD3  	0.000268	0.000193	90.350966	68964     	90.352011
171
HAWAT7         	HOT3   	0.000055	0.000067	51.701086	68964     	51.701642
172
HAWAT1         	COLD4  	0.000271	0.000192	82.217079	364527    	82.219270
173
HAWAT1         	HOT4   	0.000058	0.000064	56.243818	364525    	56.244493
174
HAWAT2         	COLD4  	0.000272	0.000193	85.977842	72334     	85.978574
175
HAWAT2         	HOT4   	0.000098	0.000097	51.059915	72334     	51.060270
176
HAWAT3         	COLD4  	0.000273	0.000198	464.269669	6237248   	464.271135
177
HAWAT3         	HOT4   	0.000057	0.000050	424.541086	6237343   	424.542459
178
HAWAT4         	COLD4  	0.000264	0.000192	97.655963	961836    	97.657040
179
HAWAT4         	HOT4   	0.000054	0.000064	65.650673	961836    	65.651183
180
HAWAT5         	COLD4  	0.000270	0.000192	98.188798	961071    	98.189462
181
HAWAT5         	HOT4   	0.000047	0.000056	74.329437	961071    	74.329614
182
HAWAT6         	COLD4  	0.000269	0.000188	80.682261	364527    	80.683353
183
HAWAT6         	HOT4   	0.000055	0.000062	58.936366	364525    	58.936718
184
HAWAT7         	COLD4  	0.000268	0.000192	90.840174	68964     	90.841126
185
HAWAT7         	HOT4   	0.000055	0.000050	51.019533	68964     	51.020015
186
HAWAT1         	COLD5  	0.000305	0.000192	79.443524	364527    	79.444369
187
HAWAT1         	HOT5   	0.000055	0.000049	58.925452	364525    	58.925958
188
HAWAT2         	COLD5  	0.000269	0.000195	86.481730	72334     	86.482396
189
HAWAT2         	HOT5   	0.000051	0.000054	51.852800	72334     	51.852974
190
HAWAT3         	COLD5  	0.000270	0.000196	491.774496	6237248   	491.775254
191
HAWAT3         	HOT5   	0.000054	0.000064	467.174607	6237343   	467.175539
192
HAWAT4         	COLD5  	0.000271	0.000191	92.083364	961836    	92.084231
193
HAWAT4         	HOT5   	0.000055	0.000048	61.444613	961836    	61.444865
194
HAWAT5         	COLD5  	0.000273	0.000207	98.199694	961071    	98.200372
195
HAWAT5         	HOT5   	0.000049	0.000044	73.102331	961071    	73.102562
196
HAWAT6         	COLD5  	0.000274	0.000207	79.850924	364527    	79.852113
197
HAWAT6         	HOT5   	0.000056	0.000049	53.353052	364525    	53.354438
198
HAWAT7         	COLD5  	0.000289	0.000190	90.780127	68964     	90.781174
199
HAWAT7         	HOT5   	0.000055	0.000063	52.026994	68964     	52.027561
200
HAWAT1         	COLD6  	0.000269	0.000195	85.158191	364527    	85.159693
201
HAWAT1         	HOT6   	0.000056	0.000065	59.340312	364525    	59.340586
202
HAWAT2         	COLD6  	0.000273	0.000209	86.355776	72334     	86.356491
203
HAWAT2         	HOT6   	0.000045	0.000053	52.247903	72334     	52.248070
204
HAWAT3         	COLD6  	0.000273	0.000215	452.424948	6237248   	452.425812
205
HAWAT3         	HOT6   	0.000056	0.000066	454.966447	6237343   	454.966741
206
HAWAT4         	COLD6  	0.000270	0.000240	88.347305	961836    	88.348448
207
HAWAT4         	HOT6   	0.000055	0.000051	61.724150	961836    	61.724722
208
HAWAT5         	COLD6  	0.000271	0.000192	98.887185	961071    	98.887846
209
HAWAT5         	HOT6   	0.000050	0.000045	69.763538	961071    	69.763829
210
HAWAT6         	COLD6  	0.000263	0.000191	79.578916	364527    	79.580157
211
HAWAT6         	HOT6   	0.000055	0.000049	53.637540	364525    	53.638302
212
HAWAT7         	COLD6  	0.000268	0.000189	91.595693	68964     	91.596700
213
HAWAT7         	HOT6   	0.000055	0.000064	51.864407	68964     	51.864981
214
HAWAT1         	COLD7  	0.000269	0.000192	85.153012	364527    	85.154322
215
HAWAT1         	HOT7   	0.000057	0.000064	58.296536	364525    	58.298232
216
HAWAT2         	COLD7  	0.000269	0.000192	85.811315	72334     	85.811977
217
HAWAT2         	HOT7   	0.000046	0.000041	50.432978	72334     	50.433130
218
HAWAT3         	COLD7  	0.000277	0.000222	419.991227	6237248   	419.992487
219
HAWAT3         	HOT7   	0.000056	0.000058	439.848673	6237343   	439.850127
220
HAWAT4         	COLD7  	0.000266	0.000191	89.880599	961836    	89.881574
221
HAWAT4         	HOT7   	0.000056	0.000049	70.705241	961836    	70.705764
222
HAWAT5         	COLD7  	0.000268	0.000336	101.883743	961071    	101.884555
223
HAWAT5         	HOT7   	0.000049	0.000058	75.197966	961071    	75.198167
224
HAWAT6         	COLD7  	0.000306	0.000193	85.612869	364527    	85.614216
225
HAWAT6         	HOT7   	0.000056	0.000064	59.178073	364525    	59.179053
226
HAWAT7         	COLD7  	0.000264	0.000186	89.705307	68964     	89.706367
227
HAWAT7         	HOT7   	0.000056	0.000065	51.739018	68964     	51.740064
228
HAWAT1         	COLD8  	0.000267	0.000191	85.592848	364527    	85.594331
229
HAWAT1         	HOT8   	0.000057	0.000067	59.510033	364525    	59.510559
230
HAWAT2         	COLD8  	0.000270	0.000192	85.085181	72334     	85.085845
231
HAWAT2         	HOT8   	0.000048	0.000042	50.468642	72334     	50.468900
232
HAWAT3         	COLD8  	0.000273	0.000197	477.129824	6237248   	477.131536
233
HAWAT3         	HOT8   	0.000055	0.000064	459.945071	6237343   	459.946546
234
HAWAT4         	COLD8  	0.000272	0.000193	95.979044	961836    	95.979838
235
HAWAT4         	HOT8   	0.000055	0.000065	71.386775	961836    	71.387086
236
HAWAT5         	COLD8  	0.000271	0.000188	100.400267	961071    	100.400928
237
HAWAT5         	HOT8   	0.000049	0.000058	74.688736	961071    	74.688917
238
HAWAT6         	COLD8  	0.000269	0.000196	79.192888	364527    	79.194048
239
HAWAT6         	HOT8   	0.000057	0.000050	53.385759	364525    	53.386327
240
HAWAT7         	COLD8  	0.000267	0.000187	90.875301	68964     	90.876903
241
HAWAT7         	HOT8   	0.000056	0.000049	50.837946	68964     	50.838133
242
HAWAT1         	COLD9  	0.000269	0.000195	84.566740	364527    	84.568187
243
HAWAT1         	HOT9   	0.000054	0.000065	54.371072	364525    	54.371272
244
HAWAT2         	COLD9  	0.000267	0.000192	86.409299	72334     	86.410055
245
HAWAT2         	HOT9   	0.000097	0.000108	51.874347	72334     	51.874673
246
HAWAT3         	COLD9  	0.000268	0.000195	402.670680	6237248   	402.672175
247
HAWAT3         	HOT9   	0.000057	0.000050	371.736473	6237343   	371.737121
248
HAWAT4         	COLD9  	0.000269	0.000195	98.993367	961836    	98.994545
249
HAWAT4         	HOT9   	0.000056	0.000067	71.850909	961836    	71.851500
250
HAWAT5         	COLD9  	0.000271	0.000192	101.040562	961071    	101.041226
251
HAWAT5         	HOT9   	0.000049	0.000058	69.058299	961071    	69.058480
252
HAWAT6         	COLD9  	0.000271	0.000194	81.434117	364527    	81.435546
253
HAWAT6         	HOT9   	0.000055	0.000065	59.390276	364525    	59.391805
254
HAWAT7         	COLD9  	0.000266	0.000194	88.817852	68964     	88.819276
255
HAWAT7         	HOT9   	0.000056	0.000050	50.447492	68964     	50.447922
256
TS2.3: Impact of count()
257
!2016-08-27T05:12:21 TS2.3
258
Query		Run	find [s]	count [s]	sort [s]	iterate [s]	Results [-]	Total Time [s]
259
HAWAT1         	1      	0.000265	56.128928	0.000105	55.175659	364527    	111.305859
260
HAWAT1         	2      	0.000275	56.619195	0.000118	58.982486	364527    	115.603125
261
HAWAT1         	3      	0.000270	57.923089	0.000116	53.116699	364527    	111.040879
262
HAWAT1         	4      	0.000272	56.409457	0.000123	53.672709	364527    	110.083271
263
HAWAT1         	5      	0.000301	56.407964	0.000121	56.473951	364527    	112.882714
264
HAWAT1         	6      	0.000268	56.517492	0.000116	53.885593	364527    	110.404270
265
HAWAT1         	7      	0.000273	56.580462	0.000114	53.781483	364527    	110.362589
266
HAWAT1         	8      	0.000270	57.892323	0.000125	53.933985	364527    	111.827511
267
HAWAT1         	9      	0.000271	56.875050	0.000125	53.746121	364527    	110.622045
268
HAWAT2         	1      	0.000275	545.386286	0.000138	67.437590	72334     	612.824560
269
HAWAT2         	2      	0.000274	520.923400	0.000116	66.635103	72334     	587.559189
270
HAWAT2         	3      	0.000271	521.423326	0.000106	66.282444	72334     	587.706428
271
HAWAT2         	4      	0.000270	535.550393	0.000116	66.925380	72334     	602.476458
272
HAWAT2         	5      	0.000269	525.072939	0.000106	65.986712	72334     	591.060318
273
HAWAT2         	6      	0.000268	530.178149	0.000113	66.356582	72334     	596.535399
274
HAWAT2         	7      	0.000274	525.080818	0.000116	65.649010	72334     	590.730485
275
HAWAT2         	8      	0.000270	526.597107	0.000115	66.585503	72334     	593.183272
276
HAWAT2         	9      	0.000270	532.462767	0.000116	65.148566	72334     	597.611981
277
HAWAT3         	1      	0.000272	40.610421	0.000105	425.069880	6237248   	465.681156
278
HAWAT3         	2      	0.000272	42.287293	0.000104	407.870217	6237248   	450.158406
279
HAWAT3         	3      	0.000264	42.015835	0.000105	405.769728	6237248   	447.786370
280
HAWAT3         	4      	0.000269	41.534883	0.000104	393.948733	6237248   	435.485238
281
HAWAT3         	5      	0.000266	41.808353	0.000103	446.122121	6237248   	487.931374
282
HAWAT3         	6      	0.000267	41.466127	0.000114	440.741263	6237248   	482.208312
283
HAWAT3         	7      	0.000269	41.480116	0.000116	462.657218	6237248   	504.138291
284
HAWAT3         	8      	0.000272	41.759483	0.000115	405.576725	6237248   	447.337284
285
HAWAT3         	9      	0.000270	41.365098	0.000104	368.848111	6237248   	410.214217
286
HAWAT4         	1      	0.000277	50.185940	0.000103	64.458868	961836    	114.645810
287
HAWAT4         	2      	0.000303	49.284152	0.000114	71.929763	961836    	121.215014
288
HAWAT4         	3      	0.000275	50.194549	0.000114	72.467082	961836    	122.662324
289
HAWAT4         	4      	0.000274	51.620420	0.000115	72.732308	961836    	124.353441
290
HAWAT4         	5      	0.000278	50.334418	0.000105	63.241550	961836    	113.576600
291
HAWAT4         	6      	0.000277	50.400753	0.000105	72.326241	961836    	122.727770
292
HAWAT4         	7      	0.000279	49.781486	0.000105	62.670643	961836    	112.453159
293
HAWAT4         	8      	0.000272	49.506952	0.000103	63.869591	961836    	113.377262
294
HAWAT4         	9      	0.000275	49.393610	0.000104	62.248968	961836    	111.643352
295
HAWAT5         	1      	0.000272	52.819272	0.000105	74.995112	961071    	127.815008
296
HAWAT5         	2      	0.000273	54.081149	0.000105	65.552282	961071    	119.634043
297
HAWAT5         	3      	0.000274	53.047477	0.000104	72.203634	961071    	125.251757
298
HAWAT5         	4      	0.000271	53.931743	0.000103	74.637085	961071    	128.569446
299
HAWAT5         	5      	0.000267	53.681319	0.000103	67.185935	961071    	120.867864
300
HAWAT5         	6      	0.000274	53.130693	0.000105	68.430763	961071    	121.562081
301
HAWAT5         	7      	0.000268	52.953536	0.000105	70.264384	961071    	123.218541
302
HAWAT5         	8      	0.000272	52.782377	0.000105	66.269955	961071    	119.052940
303
HAWAT5         	9      	0.000269	55.683445	0.000107	67.374636	961071    	123.058842
304
HAWAT6         	1      	0.000118	57.452906	0.000103	53.904840	364527    	111.358372
305
HAWAT6         	2      	0.000273	57.116536	0.000121	57.293111	364527    	114.410359
306
HAWAT6         	3      	0.000275	56.867077	0.000118	53.684758	364527    	110.552542
307
HAWAT6         	4      	0.000276	57.427454	0.000126	59.469088	364527    	116.897273
308
HAWAT6         	5      	0.000270	58.479639	0.000065	56.234956	364527    	114.715174
309
HAWAT6         	6      	0.000272	57.427493	0.000119	58.090372	364527    	115.518521
310
HAWAT6         	7      	0.000272	57.433875	0.000119	54.067726	364527    	111.502295
311
HAWAT6         	8      	0.000271	57.681110	0.000055	56.305394	364527    	113.987071
312
HAWAT6         	9      	0.000276	57.611272	0.000118	54.256333	364527    	111.868387
313
HAWAT7         	1      	0.000268	523.119257	0.000135	68.386140	68964     	591.506137
314
HAWAT7         	2      	0.000275	521.163840	0.000118	68.011978	68964     	589.176545
315
HAWAT7         	3      	0.000273	516.672529	0.000107	68.624607	68964     	585.297777
316
HAWAT7         	4      	0.000272	522.729522	0.000121	69.636561	68964     	592.367445
317
HAWAT7         	5      	0.000345	519.303917	0.000120	70.638318	68964     	589.943218
318
HAWAT7         	6      	0.000273	527.421646	0.000119	69.414657	68964     	596.836961
319
HAWAT7         	7      	0.000175	522.820333	0.000108	69.777803	68964     	592.598865
320
HAWAT7         	8      	0.000272	523.975258	0.000115	69.591383	68964     	593.567577
321
HAWAT7         	9      	0.000274	523.020736	0.000115	69.817426	68964     	592.839587
322
OTHER2         	1      	0.000276	59.960017	0.000117	60.012506	353365    	119.973234
323
OTHER2         	2      	0.000116	58.370723	0.000104	54.329250	353365    	112.700368
324
OTHER2         	3      	0.000273	57.669037	0.000114	57.791307	353365    	115.461017
325
OTHER2         	4      	0.000274	58.107281	0.000046	53.999477	353365    	112.107297
326
OTHER2         	5      	0.000300	57.776713	0.000103	53.757529	353365    	111.534904
327
OTHER2         	6      	0.000269	59.177150	0.000104	57.460360	353365    	116.638291
328
OTHER2         	7      	0.000275	58.156169	0.000104	54.444806	353365    	112.601741
329
OTHER2         	8      	0.000275	57.770462	0.000104	57.488160	353365    	115.259349
330
OTHER2         	9      	0.000267	57.737532	0.000104	53.876072	353365    	111.614220
331
TS2.4: Descending sort
332
!2016-08-27T10:54:20 TS2.4
333
Query		Run	find [s]	sort [s]	iterate [s]	Results [-]	Total Time [s]
334
HAWAT1         	1      	0.000262	0.000190	303.946681	364527    	303.947616
335
HAWAT1         	2      	0.000271	0.000190	304.008823	364527    	304.009784
336
HAWAT1         	3      	0.000265	0.000190	308.690606	364527    	308.691580
337
HAWAT1         	4      	0.000270	0.000191	309.447409	364527    	309.448667
338
HAWAT1         	5      	0.000273	0.000194	302.190748	364527    	302.191455
339
HAWAT1         	6      	0.000264	0.000189	306.066466	364527    	306.067569
340
HAWAT1         	7      	0.000264	0.000189	300.134607	364527    	300.135810
341
HAWAT1         	8      	0.000270	0.000191	312.552629	364527    	312.553873
342
HAWAT1         	9      	0.000269	0.000190	307.377933	364527    	307.378777
343
HAWAT2         	1      	0.000311	0.000189	296.082076	72334     	296.082824
344
HAWAT2         	2      	0.000271	0.000196	296.880929	72334     	296.881668
345
HAWAT2         	3      	0.000270	0.000197	292.862825	72334     	292.863523
346
HAWAT2         	4      	0.000277	0.000196	293.976519	72334     	293.977413
347
HAWAT2         	5      	0.000115	0.000099	303.263950	72334     	303.264529
348
HAWAT2         	6      	0.000273	0.000194	301.593339	72334     	301.594052
349
HAWAT2         	7      	0.000276	0.000198	294.940591	72334     	294.941358
350
HAWAT2         	8      	0.000273	0.000197	301.273740	72334     	301.274544
351
HAWAT2         	9      	0.000270	0.000210	298.578141	72334     	298.578881
352
HAWAT3         	1      	0.000314	0.000216	625.641411	6237248   	625.642276
353
HAWAT3         	2      	0.000268	0.000226	633.984323	6237248   	633.985146
354
HAWAT3         	3      	0.000267	0.000216	625.320163	6237248   	625.320983
355
HAWAT3         	4      	0.000267	0.000211	637.394384	6237248   	637.395193
356
HAWAT3         	5      	0.000269	0.000222	643.048944	6237248   	643.049749
357
HAWAT3         	6      	0.000267	0.000197	627.043752	6237248   	627.044628
358
HAWAT3         	7      	0.000268	0.000195	640.376453	6237248   	640.377227
359
HAWAT3         	8      	0.000264	0.000196	655.550836	6237248   	655.552005
360
HAWAT3         	9      	0.000268	0.000192	632.926614	6237248   	632.927758
361
HAWAT4         	1      	0.000265	0.000194	309.587799	961836    	309.588707
362
HAWAT4         	2      	0.000269	0.000195	320.926643	961836    	320.927893
363
HAWAT4         	3      	0.000268	0.000190	316.522752	961836    	316.523815
364
HAWAT4         	4      	0.000271	0.000192	311.558165	961836    	311.559136
365
HAWAT4         	5      	0.000271	0.000193	310.167622	961836    	310.168983
366
HAWAT4         	6      	0.000271	0.000188	309.826669	961836    	309.827691
367
HAWAT4         	7      	0.000268	0.000190	311.627138	961836    	311.627991
368
HAWAT4         	8      	0.000270	0.000193	320.967746	961836    	320.969014
369
HAWAT4         	9      	0.000270	0.000187	309.000765	961836    	309.001744
370
HAWAT5         	1      	0.000269	0.000192	318.498921	961071    	318.499641
371
HAWAT5         	2      	0.000270	0.000195	318.273743	961071    	318.274469
372
HAWAT5         	3      	0.000270	0.000195	320.479179	961071    	320.479978
373
HAWAT5         	4      	0.000270	0.000195	311.816791	961071    	311.817543
374
HAWAT5         	5      	0.000271	0.000209	324.863733	961071    	324.864540
375
HAWAT5         	6      	0.000269	0.000246	321.490107	961071    	321.490934
376
HAWAT5         	7      	0.000267	0.000193	346.196830	961071    	346.197648
377
HAWAT5         	8      	0.000270	0.000195	363.158751	961071    	363.159541
378
HAWAT5         	9      	0.000268	0.000192	379.695570	961071    	379.696242
379
HAWAT6         	1      	0.000306	0.000197	359.229975	364527    	359.231253
380
HAWAT6         	2      	0.000267	0.000191	377.495457	364527    	377.497386
381
HAWAT6         	3      	0.000268	0.000195	351.360839	364527    	351.361630
382
HAWAT6         	4      	0.000274	0.000194	349.121862	364527    	349.122673
383
HAWAT6         	5      	0.000272	0.000193	357.726026	364527    	357.727948
384
HAWAT6         	6      	0.000268	0.000188	352.029644	364527    	352.030874
385
HAWAT6         	7      	0.000264	0.000190	368.647001	364527    	368.648114
386
HAWAT6         	8      	0.000265	0.000190	362.230575	364527    	362.231702
387
HAWAT6         	9      	0.000267	0.000191	373.849453	364527    	373.851310
388
HAWAT7         	1      	0.000272	0.000191	364.863858	68964     	364.865528
389
HAWAT7         	2      	0.000270	0.000198	360.247088	68964     	360.248008
390
HAWAT7         	3      	0.000273	0.000195	380.012131	68964     	380.013898
391
HAWAT7         	4      	0.000272	0.000196	380.327933	68964     	380.328910
392
HAWAT7         	5      	0.000270	0.000193	347.522429	68964     	347.523425
393
HAWAT7         	6      	0.000272	0.000192	349.819539	68964     	349.820275
394
HAWAT7         	7      	0.000268	0.000194	391.997389	68964     	391.998318
395
HAWAT7         	8      	0.000275	0.000193	393.938469	68964     	393.939606
396
HAWAT7         	9      	0.000299	0.000191	382.269969	68964     	382.270966
397
End
398
!2016-08-27T17:34:34 TS2.5
399
TS2.5: Impact of list size on query time
400
!2016-08-28T19:29:12 TS2.5
401
Query		Run		find [s]	iterate [s]	Results [-]	Total Time [s]
402
OTHER1         	LIST(2) 1	0.000292	85.309108	585092    	85.309621
403
OTHER1         	LIST(2) 2	0.000248	85.403787	585092    	85.404724
404
OTHER1         	LIST(2) 3	0.000246	85.158338	585092    	85.159557
405
OTHER1         	LIST(2) 4	0.000275	84.714374	585092    	84.715073
406
OTHER1         	LIST(2) 5	0.000243	84.193268	585092    	84.193941
407
OTHER1         	LIST(2) 6	0.000249	85.336396	585092    	85.337574
408
OTHER1         	LIST(2) 7	0.000249	84.581644	585092    	84.583087
409
OTHER1         	LIST(2) 8	0.000248	83.842330	585092    	83.843740
410
OTHER1         	LIST(2) 9	0.000247	84.939007	585092    	84.939798
411
OTHER1         	LIST(4) 1	0.000256	106.617359	1065895   	106.620152
412
OTHER1         	LIST(4) 2	0.000251	107.545930	1065895   	107.547145
413
OTHER1         	LIST(4) 3	0.000244	108.144930	1065895   	108.146751
414
OTHER1         	LIST(4) 4	0.000245	107.500582	1065895   	107.502743
415
OTHER1         	LIST(4) 5	0.000244	108.707623	1065895   	108.710490
416
OTHER1         	LIST(4) 6	0.000248	107.563322	1065895   	107.566289
417
OTHER1         	LIST(4) 7	0.000248	107.839557	1065895   	107.842582
418
OTHER1         	LIST(4) 8	0.000245	108.215022	1065895   	108.217696
419
OTHER1         	LIST(4) 9	0.000245	108.293715	1065895   	108.296603
420
OTHER1         	LIST(8) 1	0.000255	148.623771	1949772   	148.624436
421
OTHER1         	LIST(8) 2	0.000246	149.623780	1949772   	149.624517
422
OTHER1         	LIST(8) 3	0.000249	151.038550	1949772   	151.039086
423
OTHER1         	LIST(8) 4	0.000252	149.656575	1949772   	149.657225
424
OTHER1         	LIST(8) 5	0.000254	151.882990	1949772   	151.883733
425
OTHER1         	LIST(8) 6	0.000252	152.948044	1949772   	152.948698
426
OTHER1         	LIST(8) 7	0.000255	153.823821	1949772   	153.825296
427
OTHER1         	LIST(8) 8	0.000250	153.956117	1949772   	153.957514
428
OTHER1         	LIST(8) 9	0.000253	152.646311	1949772   	152.646977
429
OTHER1         	LIST(16) 1	0.000259	252.003717	2141519   	252.004172
430
OTHER1         	LIST(16) 2	0.000253	247.438853	2141519   	247.439316
431
OTHER1         	LIST(16) 3	0.000248	246.683937	2141519   	246.684413
432
OTHER1         	LIST(16) 4	0.000253	249.808197	2141519   	249.808634
433
OTHER1         	LIST(16) 5	0.000253	247.054645	2141519   	247.055120
434
OTHER1         	LIST(16) 6	0.000249	249.880643	2141519   	249.881075
435
OTHER1         	LIST(16) 7	0.000250	247.243855	2141519   	247.244303
436
OTHER1         	LIST(16) 8	0.000251	247.447255	2141519   	247.447695
437
OTHER1         	LIST(16) 9	0.000248	247.579152	2141519   	247.579582
438
OTHER1         	LIST(32) 1	0.000260	176.692752	2454499   	176.695219
439
OTHER1         	LIST(32) 2	0.000250	173.962569	2454499   	173.964572
440
OTHER1         	LIST(32) 3	0.000250	176.502946	2454499   	176.505006
441
OTHER1         	LIST(32) 4	0.000249	171.298658	2454499   	171.300236
442
OTHER1         	LIST(32) 5	0.000248	171.208730	2454499   	171.211086
443
OTHER1         	LIST(32) 6	0.000252	174.746956	2454499   	174.749243
444
OTHER1         	LIST(32) 7	0.000249	170.800640	2454499   	170.801110
445
OTHER1         	LIST(32) 8	0.000284	173.521612	2454499   	173.522413
446
OTHER1         	LIST(32) 9	0.000250	172.459550	2454499   	172.460370
447
OTHER1         	LIST(64) 1	0.000263	192.689700	2877964   	192.691241
448
OTHER1         	LIST(64) 2	0.000257	191.558554	2877964   	191.559122
449
OTHER1         	LIST(64) 3	0.000260	191.924855	2877964   	191.926381
450
OTHER1         	LIST(64) 4	0.000262	199.189215	2877964   	199.190691
451
OTHER1         	LIST(64) 5	0.000170	196.708135	2877964   	196.709518
452
OTHER1         	LIST(64) 6	0.000260	197.146672	2877964   	197.147262
453
OTHER1         	LIST(64) 7	0.000258	196.663581	2877964   	196.665028
454
OTHER1         	LIST(64) 8	0.000303	195.885461	2877964   	195.886906
455
OTHER1         	LIST(64) 9	0.000256	195.093681	2877964   	195.095290
456
OTHER1         	LIST(128) 1	0.000264	540.932335	3274716   	540.932839
457
OTHER1         	LIST(128) 2	0.000255	536.876381	3274716   	536.876819
458
OTHER1         	LIST(128) 3	0.000259	532.903233	3274716   	532.903668
459
OTHER1         	LIST(128) 4	0.000259	534.650791	3274716   	534.651276
460
OTHER1         	LIST(128) 5	0.000258	534.705771	3274716   	534.706209
461
OTHER1         	LIST(128) 6	0.000255	533.465872	3274716   	533.466307
462
OTHER1         	LIST(128) 7	0.000256	534.572861	3274716   	534.573309
463
OTHER1         	LIST(128) 8	0.000262	531.801165	3274716   	531.801703
464
OTHER1         	LIST(128) 9	0.000259	532.657019	3274716   	532.657574
465
TS3.1: Batched read using SKIP+LIMIT, COLD
466
!2016-08-28T23:19:39 TS3.1
467
Query		Run	Results [-]	Total Time [s]
468
HAWAT1         	S1     	7068      	2.041117
469
HAWAT1         	B1     	7068      	46.274450
470
HAWAT1         	S2     	7068      	1.974957
471
HAWAT1         	B2     	7068      	46.484994
472
HAWAT1         	S3     	7068      	2.637872
473
HAWAT1         	B3     	7068      	46.374636
474
HAWAT1         	S4     	7068      	2.202773
475
HAWAT1         	B4     	7068      	46.513879
476
HAWAT1         	S5     	7068      	2.014362
477
HAWAT1         	B5     	7068      	46.504773
478
HAWAT1         	S6     	7068      	2.111150
479
HAWAT1         	B6     	7068      	46.234607
480
HAWAT1         	S7     	7068      	2.103107
481
HAWAT1         	B7     	7068      	46.546200
482
HAWAT1         	S8     	7068      	2.123680
483
HAWAT1         	B8     	7068      	46.408190
484
HAWAT1         	S9     	7068      	2.117512
485
HAWAT1         	B9     	7068      	46.958138
486
HAWAT3         	S1     	143657    	7.759152
487
HAWAT3         	B1     	143657    	502.120570
488
HAWAT3         	S2     	143657    	7.739480
489
HAWAT3         	B2     	143657    	501.900951
490
HAWAT3         	S3     	143657    	7.812472
491
HAWAT3         	B3     	143657    	502.277066
492
HAWAT3         	S4     	143657    	7.792722
493
HAWAT3         	B4     	143657    	492.111689
494
HAWAT3         	S5     	143657    	7.823419
495
HAWAT3         	B5     	143657    	496.734792
496
HAWAT3         	S6     	143657    	7.921954
497
HAWAT3         	B6     	143657    	498.273288
498
HAWAT3         	S7     	143657    	7.854594
499
HAWAT3         	B7     	143657    	500.296681
500
HAWAT3         	S8     	143657    	7.541185
501
HAWAT3         	B8     	143657    	500.481219
502
HAWAT3         	S9     	143657    	7.759399
503
HAWAT3         	B9     	143657    	492.787675
504
HAWAT4         	S1     	17730     	2.143916
505
HAWAT4         	B1     	17730     	102.667594
506
HAWAT4         	S2     	17730     	2.058725
507
HAWAT4         	B2     	17730     	105.092041
508
HAWAT4         	S3     	17730     	2.096076
509
HAWAT4         	B3     	17730     	104.796015
510
HAWAT4         	S4     	17730     	1.975656
511
HAWAT4         	B4     	17730     	102.386076
512
HAWAT4         	S5     	17730     	1.954580
513
HAWAT4         	B5     	17730     	102.946305
514
HAWAT4         	S6     	17730     	1.883833
515
HAWAT4         	B6     	17730     	102.850934
516
HAWAT4         	S7     	17730     	2.044334
517
HAWAT4         	B7     	17730     	103.603665
518
HAWAT4         	S8     	17730     	1.985562
519
HAWAT4         	B8     	17730     	101.773075
520
HAWAT4         	S9     	17730     	2.396481
521
HAWAT4         	B9     	17730     	104.955900
522
HAWAT5         	S1     	17724     	1.963812
523
HAWAT5         	B1     	17724     	119.895189
524
HAWAT5         	S2     	17724     	2.225648
525
HAWAT5         	B2     	17724     	119.853201
526
HAWAT5         	S3     	17724     	2.171825
527
HAWAT5         	B3     	17724     	118.239951
528
HAWAT5         	S4     	17724     	2.113179
529
HAWAT5         	B4     	17724     	121.077077
530
HAWAT5         	S5     	17724     	1.996060
531
HAWAT5         	B5     	17724     	120.299923
532
HAWAT5         	S6     	17724     	2.215032
533
HAWAT5         	B6     	17724     	120.410087
534
HAWAT5         	S7     	17724     	2.170963
535
HAWAT5         	B7     	17724     	119.963739
536
HAWAT5         	S8     	17724     	2.186691
537
HAWAT5         	B8     	17724     	119.405156
538
HAWAT5         	S9     	17724     	2.106899
539
HAWAT5         	B9     	17724     	120.339450
540
HAWAT6         	S1     	7068      	2.193597
541
HAWAT6         	B1     	7068      	47.367378
542
HAWAT6         	S2     	7068      	2.324118
543
HAWAT6         	B2     	7068      	47.020386
544
HAWAT6         	S3     	7068      	2.261488
545
HAWAT6         	B3     	7068      	46.744962
546
HAWAT6         	S4     	7068      	2.222433
547
HAWAT6         	B4     	7068      	47.698421
548
HAWAT6         	S5     	7068      	2.232777
549
HAWAT6         	B5     	7068      	46.406152
550
HAWAT6         	S6     	7068      	2.210899
551
HAWAT6         	B6     	7068      	46.876552
552
HAWAT6         	S7     	7068      	2.172889
553
HAWAT6         	B7     	7068      	46.948755
554
HAWAT6         	S8     	7068      	2.223305
555
HAWAT6         	B8     	7068      	46.523153
556
HAWAT6         	S9     	7068      	2.351850
557
HAWAT6         	B9     	7068      	47.924846
558
TS3.2: Batched read using SKIP+LIMIT, COLD, descending sort
559
!2016-08-29T01:32:33 TS3.2
560
Query		Run	Results [-]	Total Time [s]
561
HAWAT1         	S1     	7068      	6.832209
562
HAWAT1         	B1     	7068      	68.421570
563
HAWAT1         	S2     	7068      	6.871713
564
HAWAT1         	B2     	7068      	69.937015
565
HAWAT1         	S3     	7068      	6.643312
566
HAWAT1         	B3     	7068      	68.553704
567
HAWAT1         	S4     	7068      	6.718763
568
HAWAT1         	B4     	7068      	69.297647
569
HAWAT1         	S5     	7068      	6.948518
570
HAWAT1         	B5     	7068      	69.523425
571
HAWAT1         	S6     	7068      	6.724933
572
HAWAT1         	B6     	7068      	68.820351
573
HAWAT1         	S7     	7068      	6.918917
574
HAWAT1         	B7     	7068      	69.978024
575
HAWAT1         	S8     	7068      	6.738763
576
HAWAT1         	B8     	7068      	68.904353
577
HAWAT1         	S9     	7068      	6.762707
578
HAWAT1         	B9     	7068      	68.711615
579
HAWAT3         	S1     	143657    	11.885667
580
HAWAT3         	B1     	143657    	548.665974
581
HAWAT3         	S2     	143657    	11.998656
582
HAWAT3         	B2     	143657    	547.565119
583
HAWAT3         	S3     	143657    	12.258986
584
HAWAT3         	B3     	143657    	559.434639
585
HAWAT3         	S4     	143657    	11.833114
586
HAWAT3         	B4     	143657    	538.467030
587
HAWAT3         	S5     	143657    	11.813205
588
HAWAT3         	B5     	143657    	529.839122
589
HAWAT3         	S6     	143657    	11.985153
590
HAWAT3         	B6     	143657    	540.301619
591
HAWAT3         	S7     	143657    	11.644954
592
HAWAT3         	B7     	143657    	534.533140
593
HAWAT3         	S8     	143657    	12.674420
594
HAWAT3         	B8     	143657    	531.582379
595
HAWAT3         	S9     	143657    	12.186682
596
HAWAT3         	B9     	143657    	558.585608
597
HAWAT4         	S1     	17730     	6.700466
598
HAWAT4         	B1     	17730     	101.522750
599
HAWAT4         	S2     	17730     	6.615232
600
HAWAT4         	B2     	17730     	101.912969
601
HAWAT4         	S3     	17730     	6.481664
602
HAWAT4         	B3     	17730     	98.587956
603
HAWAT4         	S4     	17730     	6.308944
604
HAWAT4         	B4     	17730     	100.744002
605
HAWAT4         	S5     	17730     	6.508421
606
HAWAT4         	B5     	17730     	99.489153
607
HAWAT4         	S6     	17730     	6.502958
608
HAWAT4         	B6     	17730     	102.499532
609
HAWAT4         	S7     	17730     	6.545856
610
HAWAT4         	B7     	17730     	98.543858
611
HAWAT4         	S8     	17730     	6.655805
612
HAWAT4         	B8     	17730     	100.065373
613
HAWAT4         	S9     	17730     	6.555724
614
HAWAT4         	B9     	17730     	99.887305
615
HAWAT5         	S1     	17724     	6.744722
616
HAWAT5         	B1     	17724     	117.729866
617
HAWAT5         	S2     	17724     	6.508594
618
HAWAT5         	B2     	17724     	115.029915
619
HAWAT5         	S3     	17724     	6.529837
620
HAWAT5         	B3     	17724     	116.285848
621
HAWAT5         	S4     	17724     	6.516873
622
HAWAT5         	B4     	17724     	119.371877
623
HAWAT5         	S5     	17724     	6.572405
624
HAWAT5         	B5     	17724     	115.309178
625
HAWAT5         	S6     	17724     	6.528806
626
HAWAT5         	B6     	17724     	114.658110
627
HAWAT5         	S7     	17724     	6.758385
628
HAWAT5         	B7     	17724     	117.408255
629
HAWAT5         	S8     	17724     	6.587494
630
HAWAT5         	B8     	17724     	116.239774
631
HAWAT5         	S9     	17724     	6.720783
632
HAWAT5         	B9     	17724     	116.343932
633
HAWAT6         	S1     	7068      	6.728187
634
HAWAT6         	B1     	7068      	69.895496
635
HAWAT6         	S2     	7068      	6.662333
636
HAWAT6         	B2     	7068      	70.071798
637
HAWAT6         	S3     	7068      	7.035845
638
HAWAT6         	B3     	7068      	68.708470
639
HAWAT6         	S4     	7068      	6.819496
640
HAWAT6         	B4     	7068      	68.976871
641
HAWAT6         	S5     	7068      	6.694632
642
HAWAT6         	B5     	7068      	69.143331
643
HAWAT6         	S6     	7068      	6.924413
644
HAWAT6         	B6     	7068      	69.497977
645
HAWAT6         	S7     	7068      	6.835949
646
HAWAT6         	B7     	7068      	69.471609
647
HAWAT6         	S8     	7068      	6.778259
648
HAWAT6         	B8     	7068      	68.931042
649
HAWAT6         	S9     	7068      	6.639160
650
HAWAT6         	B9     	7068      	68.883142
651
TS3.3: Batched read using SKIP+LIMIT, HOT
652
!2016-08-29T04:01:09 TS3.3
653
Query		Run	Results [-]	Total Time [s]
654
HAWAT1         	COLD1  	50        	0.278733
655
HAWAT1         	THREE1 	150       	0.329743
656
HAWAT1         	HOT1   	50        	0.020097
657
HAWAT3         	COLD1  	50        	0.067436
658
HAWAT3         	THREE1 	150       	0.066342
659
HAWAT3         	HOT1   	50        	0.001818
660
HAWAT4         	COLD1  	50        	0.134319
661
HAWAT4         	THREE1 	150       	0.128998
662
HAWAT4         	HOT1   	50        	0.008289
663
HAWAT5         	COLD1  	50        	0.220432
664
HAWAT5         	THREE1 	150       	0.166561
665
HAWAT5         	HOT1   	50        	0.010344
666
HAWAT6         	COLD1  	50        	0.344678
667
HAWAT6         	THREE1 	150       	0.381098
668
HAWAT6         	HOT1   	50        	0.018687
669
HAWAT1         	COLD2  	50        	0.286649
670
HAWAT1         	THREE2 	150       	0.352596
671
HAWAT1         	HOT2   	50        	0.019889
672
HAWAT3         	COLD2  	50        	0.061187
673
HAWAT3         	THREE2 	150       	0.065349
674
HAWAT3         	HOT2   	50        	0.001997
675
HAWAT4         	COLD2  	50        	0.130636
676
HAWAT4         	THREE2 	150       	0.141123
677
HAWAT4         	HOT2   	50        	0.008501
678
HAWAT5         	COLD2  	50        	0.156581
679
HAWAT5         	THREE2 	150       	0.183726
680
HAWAT5         	HOT2   	50        	0.010956
681
HAWAT6         	COLD2  	50        	0.339211
682
HAWAT6         	THREE2 	150       	0.382840
683
HAWAT6         	HOT2   	50        	0.028312
684
HAWAT1         	COLD3  	50        	0.287384
685
HAWAT1         	THREE3 	150       	0.368686
686
HAWAT1         	HOT3   	50        	0.018125
687
HAWAT3         	COLD3  	50        	0.057564
688
HAWAT3         	THREE3 	150       	0.066732
689
HAWAT3         	HOT3   	50        	0.002119
690
HAWAT4         	COLD3  	50        	0.128341
691
HAWAT4         	THREE3 	150       	0.134054
692
HAWAT4         	HOT3   	50        	0.009560
693
HAWAT5         	COLD3  	50        	0.154989
694
HAWAT5         	THREE3 	150       	0.188828
695
HAWAT5         	HOT3   	50        	0.009799
696
HAWAT6         	COLD3  	50        	0.352284
697
HAWAT6         	THREE3 	150       	0.375376
698
HAWAT6         	HOT3   	50        	0.019983
699
HAWAT1         	COLD4  	50        	0.289518
700
HAWAT1         	THREE4 	150       	0.339122
701
HAWAT1         	HOT4   	50        	0.020648
702
HAWAT3         	COLD4  	50        	0.063436
703
HAWAT3         	THREE4 	150       	0.076769
704
HAWAT3         	HOT4   	50        	0.002339
705
HAWAT4         	COLD4  	50        	0.130035
706
HAWAT4         	THREE4 	150       	0.141575
707
HAWAT4         	HOT4   	50        	0.010565
708
HAWAT5         	COLD4  	50        	0.168916
709
HAWAT5         	THREE4 	150       	0.181826
710
HAWAT5         	HOT4   	50        	0.009660
711
HAWAT6         	COLD4  	50        	0.341016
712
HAWAT6         	THREE4 	150       	0.398718
713
HAWAT6         	HOT4   	50        	0.020076
714
HAWAT1         	COLD5  	50        	0.332977
715
HAWAT1         	THREE5 	150       	0.343529
716
HAWAT1         	HOT5   	50        	0.020070
717
HAWAT3         	COLD5  	50        	0.059369
718
HAWAT3         	THREE5 	150       	0.071662
719
HAWAT3         	HOT5   	50        	0.002133
720
HAWAT4         	COLD5  	50        	0.132725
721
HAWAT4         	THREE5 	150       	0.129857
722
HAWAT4         	HOT5   	50        	0.008815
723
HAWAT5         	COLD5  	50        	0.162713
724
HAWAT5         	THREE5 	150       	0.188010
725
HAWAT5         	HOT5   	50        	0.009627
726
HAWAT6         	COLD5  	50        	0.339471
727
HAWAT6         	THREE5 	150       	0.369050
728
HAWAT6         	HOT5   	50        	0.020359
729
HAWAT1         	COLD6  	50        	0.288665
730
HAWAT1         	THREE6 	150       	0.361659
731
HAWAT1         	HOT6   	50        	0.018608
732
HAWAT3         	COLD6  	50        	0.059126
733
HAWAT3         	THREE6 	150       	0.068089
734
HAWAT3         	HOT6   	50        	0.002689
735
HAWAT4         	COLD6  	50        	0.109814
736
HAWAT4         	THREE6 	150       	0.139188
737
HAWAT4         	HOT6   	50        	0.008901
738
HAWAT5         	COLD6  	50        	0.165926
739
HAWAT5         	THREE6 	150       	0.178364
740
HAWAT5         	HOT6   	50        	0.009939
741
HAWAT6         	COLD6  	50        	0.452627
742
HAWAT6         	THREE6 	150       	0.386198
743
HAWAT6         	HOT6   	50        	0.017823
744
HAWAT1         	COLD7  	50        	0.306619
745
HAWAT1         	THREE7 	150       	0.331932
746
HAWAT1         	HOT7   	50        	0.019387
747
HAWAT3         	COLD7  	50        	0.058720
748
HAWAT3         	THREE7 	150       	0.079863
749
HAWAT3         	HOT7   	50        	0.002816
750
HAWAT4         	COLD7  	50        	0.130145
751
HAWAT4         	THREE7 	150       	0.143578
752
HAWAT4         	HOT7   	50        	0.009174
753
HAWAT5         	COLD7  	50        	0.151356
754
HAWAT5         	THREE7 	150       	0.185967
755
HAWAT5         	HOT7   	50        	0.009257
756
HAWAT6         	COLD7  	50        	0.336810
757
HAWAT6         	THREE7 	150       	0.384950
758
HAWAT6         	HOT7   	50        	0.017582
759
HAWAT1         	COLD8  	50        	0.288099
760
HAWAT1         	THREE8 	150       	0.332176
761
HAWAT1         	HOT8   	50        	0.020650
762
HAWAT3         	COLD8  	50        	0.063274
763
HAWAT3         	THREE8 	150       	0.070790
764
HAWAT3         	HOT8   	50        	0.002840
765
HAWAT4         	COLD8  	50        	0.128762
766
HAWAT4         	THREE8 	150       	0.133202
767
HAWAT4         	HOT8   	50        	0.009512
768
HAWAT5         	COLD8  	50        	0.155758
769
HAWAT5         	THREE8 	150       	0.182928
770
HAWAT5         	HOT8   	50        	0.012838
771
HAWAT6         	COLD8  	50        	0.348620
772
HAWAT6         	THREE8 	150       	0.402376
773
HAWAT6         	HOT8   	50        	0.019534
774
HAWAT1         	COLD9  	50        	0.311904
775
HAWAT1         	THREE9 	150       	0.351017
776
HAWAT1         	HOT9   	50        	0.021685
777
HAWAT3         	COLD9  	50        	0.063418
778
HAWAT3         	THREE9 	150       	0.068045
779
HAWAT3         	HOT9   	50        	0.001852
780
HAWAT4         	COLD9  	50        	0.130207
781
HAWAT4         	THREE9 	150       	0.130562
782
HAWAT4         	HOT9   	50        	0.008250
783
HAWAT5         	COLD9  	50        	0.168705
784
HAWAT5         	THREE9 	150       	0.178656
785
HAWAT5         	HOT9   	50        	0.009238
786
HAWAT6         	COLD9  	50        	0.343381
787
HAWAT6         	THREE9 	150       	0.385462
788
HAWAT6         	HOT9   	50        	0.018114
789
TS3.4: Batched read using SKIP+LIMIT, HOT, descending order
790
!2016-08-29T04:09:28 TS3.4
791
Query		Run	Results [-]	Total Time [s]
792
HAWAT1         	COLD1  	50        	0.376849
793
HAWAT1         	THREE1 	150       	0.643383
794
HAWAT1         	HOT1   	50        	0.035493
795
HAWAT3         	COLD1  	50        	0.076166
796
HAWAT3         	THREE1 	150       	0.090699
797
HAWAT3         	HOT1   	50        	0.008745
798
HAWAT4         	COLD1  	50        	0.131166
799
HAWAT4         	THREE1 	150       	0.101464
800
HAWAT4         	HOT1   	50        	0.010781
801
HAWAT5         	COLD1  	50        	0.105577
802
HAWAT5         	THREE1 	150       	0.121844
803
HAWAT5         	HOT1   	50        	0.010110
804
HAWAT6         	COLD1  	50        	0.424986
805
HAWAT6         	THREE1 	150       	0.773769
806
HAWAT6         	HOT1   	50        	0.041624
807
HAWAT1         	COLD2  	50        	0.368931
808
HAWAT1         	THREE2 	150       	0.681875
809
HAWAT1         	HOT2   	50        	0.028119
810
HAWAT3         	COLD2  	50        	0.072713
811
HAWAT3         	THREE2 	150       	0.088781
812
HAWAT3         	HOT2   	50        	0.009618
813
HAWAT4         	COLD2  	50        	0.110219
814
HAWAT4         	THREE2 	150       	0.103166
815
HAWAT4         	HOT2   	50        	0.011984
816
HAWAT5         	COLD2  	50        	0.113746
817
HAWAT5         	THREE2 	150       	0.118670
818
HAWAT5         	HOT2   	50        	0.014767
819
HAWAT6         	COLD2  	50        	0.421266
820
HAWAT6         	THREE2 	150       	0.677665
821
HAWAT6         	HOT2   	50        	0.036158
822
HAWAT1         	COLD3  	50        	0.361327
823
HAWAT1         	THREE3 	150       	0.641746
824
HAWAT1         	HOT3   	50        	0.032243
825
HAWAT3         	COLD3  	50        	0.072916
826
HAWAT3         	THREE3 	150       	0.125911
827
HAWAT3         	HOT3   	50        	0.048249
828
HAWAT4         	COLD3  	50        	0.093690
829
HAWAT4         	THREE3 	150       	0.100123
830
HAWAT4         	HOT3   	50        	0.015383
831
HAWAT5         	COLD3  	50        	0.108173
832
HAWAT5         	THREE3 	150       	0.123933
833
HAWAT5         	HOT3   	50        	0.014082
834
HAWAT6         	COLD3  	50        	0.425276
835
HAWAT6         	THREE3 	150       	0.709894
836
HAWAT6         	HOT3   	50        	0.035248
837
HAWAT1         	COLD4  	50        	0.369732
838
HAWAT1         	THREE4 	150       	0.642046
839
HAWAT1         	HOT4   	50        	0.037910
840
HAWAT3         	COLD4  	50        	0.076105
841
HAWAT3         	THREE4 	150       	0.092706
842
HAWAT3         	HOT4   	50        	0.011200
843
HAWAT4         	COLD4  	50        	0.099613
844
HAWAT4         	THREE4 	150       	0.129716
845
HAWAT4         	HOT4   	50        	0.014992
846
HAWAT5         	COLD4  	50        	0.114889
847
HAWAT5         	THREE4 	150       	0.122415
848
HAWAT5         	HOT4   	50        	0.013883
849
HAWAT6         	COLD4  	50        	0.408770
850
HAWAT6         	THREE4 	150       	0.717548
851
HAWAT6         	HOT4   	50        	0.032633
852
HAWAT1         	COLD5  	50        	0.394298
853
HAWAT1         	THREE5 	150       	0.625751
854
HAWAT1         	HOT5   	50        	0.036592
855
HAWAT3         	COLD5  	50        	0.072117
856
HAWAT3         	THREE5 	150       	0.089744
857
HAWAT3         	HOT5   	50        	0.009250
858
HAWAT4         	COLD5  	50        	0.100378
859
HAWAT4         	THREE5 	150       	0.104867
860
HAWAT4         	HOT5   	50        	0.010904
861
HAWAT5         	COLD5  	50        	0.116917
862
HAWAT5         	THREE5 	150       	0.120457
863
HAWAT5         	HOT5   	50        	0.012706
864
HAWAT6         	COLD5  	50        	0.416855
865
HAWAT6         	THREE5 	150       	0.673236
866
HAWAT6         	HOT5   	50        	0.035178
867
HAWAT1         	COLD6  	50        	0.371882
868
HAWAT1         	THREE6 	150       	0.635888
869
HAWAT1         	HOT6   	50        	0.037244
870
HAWAT3         	COLD6  	50        	0.076056
871
HAWAT3         	THREE6 	150       	0.089355
872
HAWAT3         	HOT6   	50        	0.009076
873
HAWAT4         	COLD6  	50        	0.095267
874
HAWAT4         	THREE6 	150       	0.097756
875
HAWAT4         	HOT6   	50        	0.015809
876
HAWAT5         	COLD6  	50        	0.105297
877
HAWAT5         	THREE6 	150       	0.124330
878
HAWAT5         	HOT6   	50        	0.014937
879
HAWAT6         	COLD6  	50        	0.421190
880
HAWAT6         	THREE6 	150       	0.789711
881
HAWAT6         	HOT6   	50        	0.028590
882
HAWAT1         	COLD7  	50        	0.396029
883
HAWAT1         	THREE7 	150       	0.645980
884
HAWAT1         	HOT7   	50        	0.035208
885
HAWAT3         	COLD7  	50        	0.084196
886
HAWAT3         	THREE7 	150       	0.094293
887
HAWAT3         	HOT7   	50        	0.008628
888
HAWAT4         	COLD7  	50        	0.101437
889
HAWAT4         	THREE7 	150       	0.105299
890
HAWAT4         	HOT7   	50        	0.010170
891
HAWAT5         	COLD7  	50        	0.109393
892
HAWAT5         	THREE7 	150       	0.114172
893
HAWAT5         	HOT7   	50        	0.014517
894
HAWAT6         	COLD7  	50        	0.438680
895
HAWAT6         	THREE7 	150       	0.717870
896
HAWAT6         	HOT7   	50        	0.028345
897
HAWAT1         	COLD8  	50        	0.356971
898
HAWAT1         	THREE8 	150       	0.725775
899
HAWAT1         	HOT8   	50        	0.029471
900
HAWAT3         	COLD8  	50        	0.075919
901
HAWAT3         	THREE8 	150       	0.087727
902
HAWAT3         	HOT8   	50        	0.013277
903
HAWAT4         	COLD8  	50        	0.094454
904
HAWAT4         	THREE8 	150       	0.103936
905
HAWAT4         	HOT8   	50        	0.012673
906
HAWAT5         	COLD8  	50        	0.108493
907
HAWAT5         	THREE8 	150       	0.134076
908
HAWAT5         	HOT8   	50        	0.016344
909
HAWAT6         	COLD8  	50        	0.421305
910
HAWAT6         	THREE8 	150       	0.693844
911
HAWAT6         	HOT8   	50        	0.040571
912
HAWAT1         	COLD9  	50        	0.376871
913
HAWAT1         	THREE9 	150       	0.654656
914
HAWAT1         	HOT9   	50        	0.037762
915
HAWAT3         	COLD9  	50        	0.076160
916
HAWAT3         	THREE9 	150       	0.087668
917
HAWAT3         	HOT9   	50        	0.013826
918
HAWAT4         	COLD9  	50        	0.094395
919
HAWAT4         	THREE9 	150       	0.096633
920
HAWAT4         	HOT9   	50        	0.010132
921
HAWAT5         	COLD9  	50        	0.115535
922
HAWAT5         	THREE9 	150       	0.129056
923
HAWAT5         	HOT9   	50        	0.011085
924
HAWAT6         	COLD9  	50        	0.429119
925
HAWAT6         	THREE9 	150       	0.710183
926
HAWAT6         	HOT9   	50        	0.041005
(2-2/2)