|
1
|
MongoDB
|
|
2
|
TS3.1: Read the last page using SKIP+LIMIT, COLD
|
|
3
|
Query Run Results [-] Total Time [s]
|
|
4
|
HAWAT1 S1 364527 73.331127
|
|
5
|
HAWAT1 B1 27 60.318929
|
|
6
|
HAWAT1 S2 364527 72.708170
|
|
7
|
HAWAT1 B2 27 61.382293
|
|
8
|
HAWAT1 S3 364527 73.084338
|
|
9
|
HAWAT1 B3 27 60.649471
|
|
10
|
HAWAT1 S4 364527 72.970839
|
|
11
|
HAWAT1 B4 27 60.691290
|
|
12
|
HAWAT1 S5 364527 74.050864
|
|
13
|
HAWAT1 B5 27 60.902870
|
|
14
|
HAWAT1 S6 364527 72.715674
|
|
15
|
HAWAT1 B6 27 60.754222
|
|
16
|
HAWAT1 S7 364527 75.191494
|
|
17
|
HAWAT1 B7 27 60.688785
|
|
18
|
HAWAT1 S8 364527 73.750528
|
|
19
|
HAWAT1 B8 27 60.614245
|
|
20
|
HAWAT1 S9 364527 74.252452
|
|
21
|
HAWAT1 B9 27 60.535660
|
|
22
|
HAWAT3 S1 6237248 311.817208
|
|
23
|
HAWAT3 B1 48 46.926719
|
|
24
|
HAWAT3 S2 6237248 312.034997
|
|
25
|
HAWAT3 B2 48 46.651095
|
|
26
|
HAWAT3 S3 6237248 308.085345
|
|
27
|
HAWAT3 B3 48 47.821180
|
|
28
|
HAWAT3 S4 6237248 325.374519
|
|
29
|
HAWAT3 B4 48 46.777632
|
|
30
|
HAWAT3 S5 6237248 317.040665
|
|
31
|
HAWAT3 B5 48 46.560734
|
|
32
|
HAWAT3 S6 6237248 317.208399
|
|
33
|
HAWAT3 B6 48 46.199276
|
|
34
|
HAWAT3 S7 6237248 313.177328
|
|
35
|
HAWAT3 B7 48 48.378477
|
|
36
|
HAWAT3 S8 6237248 324.723180
|
|
37
|
HAWAT3 B8 48 47.069093
|
|
38
|
HAWAT3 S9 6237248 315.623365
|
|
39
|
HAWAT3 B9 48 46.308506
|
|
40
|
HAWAT4 S1 961836 80.350353
|
|
41
|
HAWAT4 B1 36 53.719755
|
|
42
|
HAWAT4 S2 961836 81.366919
|
|
43
|
HAWAT4 B2 36 52.216163
|
|
44
|
HAWAT4 S3 961836 81.579090
|
|
45
|
HAWAT4 B3 36 53.890189
|
|
46
|
HAWAT4 S4 961836 79.661436
|
|
47
|
HAWAT4 B4 36 52.126928
|
|
48
|
HAWAT4 S5 961836 81.943876
|
|
49
|
HAWAT4 B5 36 54.041247
|
|
50
|
HAWAT4 S6 961836 82.158544
|
|
51
|
HAWAT4 B6 36 51.940548
|
|
52
|
HAWAT4 S7 961836 81.726986
|
|
53
|
HAWAT4 B7 36 53.300778
|
|
54
|
HAWAT4 S8 961836 81.038540
|
|
55
|
HAWAT4 B8 36 52.389394
|
|
56
|
HAWAT4 S9 961836 81.568213
|
|
57
|
HAWAT4 B9 36 54.007048
|
|
58
|
HAWAT5 S1 961071 85.573796
|
|
59
|
HAWAT5 B1 21 64.004498
|
|
60
|
HAWAT5 S2 961071 86.029069
|
|
61
|
HAWAT5 B2 21 64.544012
|
|
62
|
HAWAT5 S3 961071 84.038189
|
|
63
|
HAWAT5 B3 21 63.408925
|
|
64
|
HAWAT5 S4 961071 85.550021
|
|
65
|
HAWAT5 B4 21 64.489434
|
|
66
|
HAWAT5 S5 961071 84.180069
|
|
67
|
HAWAT5 B5 21 63.269428
|
|
68
|
HAWAT5 S6 961071 85.845101
|
|
69
|
HAWAT5 B6 21 63.590410
|
|
70
|
HAWAT5 S7 961071 85.175629
|
|
71
|
HAWAT5 B7 21 63.650735
|
|
72
|
HAWAT5 S8 961071 86.470682
|
|
73
|
HAWAT5 B8 21 63.501737
|
|
74
|
HAWAT5 S9 961071 85.200583
|
|
75
|
HAWAT5 B9 21 63.333647
|
|
76
|
HAWAT6 S1 364527 76.689116
|
|
77
|
HAWAT6 B1 27 68.494936
|
|
78
|
HAWAT6 S2 364527 74.723818
|
|
79
|
HAWAT6 B2 27 69.014648
|
|
80
|
HAWAT6 S3 364527 75.892481
|
|
81
|
HAWAT6 B3 27 69.468544
|
|
82
|
HAWAT6 S4 364527 74.372645
|
|
83
|
HAWAT6 B4 27 68.846189
|
|
84
|
HAWAT6 S5 364527 75.571869
|
|
85
|
HAWAT6 B5 27 68.705451
|
|
86
|
HAWAT6 S6 364527 75.193777
|
|
87
|
HAWAT6 B6 27 69.147850
|
|
88
|
HAWAT6 S7 364527 75.847342
|
|
89
|
HAWAT6 B7 27 68.664244
|
|
90
|
HAWAT6 S8 364527 73.989575
|
|
91
|
HAWAT6 B8 27 69.864313
|
|
92
|
HAWAT6 S9 364527 74.612821
|
|
93
|
HAWAT6 B9 27 68.639225
|
|
94
|
TS3.2: Read the last page using SKIP+LIMIT, COLD, descending sort
|
|
95
|
Query Run Results [-] Total Time [s]
|
|
96
|
HAWAT1 S1 364527 286.102216
|
|
97
|
HAWAT1 B1 27 264.642958
|
|
98
|
HAWAT1 S2 364527 296.255664
|
|
99
|
HAWAT1 B2 27 266.168630
|
|
100
|
HAWAT1 S3 364527 287.304037
|
|
101
|
HAWAT1 B3 27 267.317614
|
|
102
|
HAWAT1 S4 364527 289.467703
|
|
103
|
HAWAT1 B4 27 271.137830
|
|
104
|
HAWAT1 S5 364527 291.035456
|
|
105
|
HAWAT1 B5 27 265.704299
|
|
106
|
HAWAT1 S6 364527 283.660866
|
|
107
|
HAWAT1 B6 27 264.674693
|
|
108
|
HAWAT1 S7 364527 283.917812
|
|
109
|
HAWAT1 B7 27 265.649791
|
|
110
|
HAWAT1 S8 364527 293.008920
|
|
111
|
HAWAT1 B8 27 270.734291
|
|
112
|
HAWAT1 S9 364527 290.973711
|
|
113
|
HAWAT1 B9 27 267.343013
|
|
114
|
HAWAT3 S1 6237248 531.178561
|
|
115
|
HAWAT3 B1 48 256.398078
|
|
116
|
HAWAT3 S2 6237248 524.425664
|
|
117
|
HAWAT3 B2 48 261.072628
|
|
118
|
HAWAT3 S3 6237248 533.035942
|
|
119
|
HAWAT3 B3 48 266.925226
|
|
120
|
HAWAT3 S4 6237248 528.374192
|
|
121
|
HAWAT3 B4 48 258.552181
|
|
122
|
HAWAT3 S5 6237248 525.428820
|
|
123
|
HAWAT3 B5 48 261.111335
|
|
124
|
HAWAT3 S6 6237248 518.511758
|
|
125
|
HAWAT3 B6 48 261.500710
|
|
126
|
HAWAT3 S7 6237248 525.967915
|
|
127
|
HAWAT3 B7 48 256.718223
|
|
128
|
HAWAT3 S8 6237248 557.753444
|
|
129
|
HAWAT3 B8 48 260.374340
|
|
130
|
HAWAT3 S9 6237248 529.416152
|
|
131
|
HAWAT3 B9 48 260.493048
|
|
132
|
HAWAT4 S1 961836 297.805764
|
|
133
|
HAWAT4 B1 36 266.246467
|
|
134
|
HAWAT4 S2 961836 293.975931
|
|
135
|
HAWAT4 B2 36 270.092070
|
|
136
|
HAWAT4 S3 961836 297.040148
|
|
137
|
HAWAT4 B3 36 274.103802
|
|
138
|
HAWAT4 S4 961836 291.770090
|
|
139
|
HAWAT4 B4 36 271.274228
|
|
140
|
HAWAT4 S5 961836 293.178747
|
|
141
|
HAWAT4 B5 36 264.521997
|
|
142
|
HAWAT4 S6 961836 299.993697
|
|
143
|
HAWAT4 B6 36 271.122416
|
|
144
|
HAWAT4 S7 961836 295.139809
|
|
145
|
HAWAT4 B7 36 266.915166
|
|
146
|
HAWAT4 S8 961836 302.329362
|
|
147
|
HAWAT4 B8 36 261.446087
|
|
148
|
HAWAT4 S9 961836 297.534778
|
|
149
|
HAWAT4 B9 36 264.989015
|
|
150
|
HAWAT5 S1 961071 300.521564
|
|
151
|
HAWAT5 B1 21 279.900726
|
|
152
|
HAWAT5 S2 961071 306.588527
|
|
153
|
HAWAT5 B2 21 284.686957
|
|
154
|
HAWAT5 S3 961071 305.990033
|
|
155
|
HAWAT5 B3 21 277.285300
|
|
156
|
HAWAT5 S4 961071 301.815735
|
|
157
|
HAWAT5 B4 21 279.627316
|
|
158
|
HAWAT5 S5 961071 308.314180
|
|
159
|
HAWAT5 B5 21 279.184726
|
|
160
|
HAWAT5 S6 961071 296.447473
|
|
161
|
HAWAT5 B6 21 278.548242
|
|
162
|
HAWAT5 S7 961071 298.522340
|
|
163
|
HAWAT5 B7 21 285.898471
|
|
164
|
HAWAT5 S8 961071 298.168677
|
|
165
|
HAWAT5 B8 21 286.059592
|
|
166
|
HAWAT5 S9 961071 305.795888
|
|
167
|
HAWAT5 B9 21 281.110404
|
|
168
|
HAWAT6 S1 364527 297.424483
|
|
169
|
HAWAT6 B1 27 287.576733
|
|
170
|
HAWAT6 S2 364527 294.523653
|
|
171
|
HAWAT6 B2 27 283.963278
|
|
172
|
HAWAT6 S3 364527 289.690169
|
|
173
|
HAWAT6 B3 27 285.315148
|
|
174
|
HAWAT6 S4 364527 288.615587
|
|
175
|
HAWAT6 B4 27 291.084450
|
|
176
|
HAWAT6 S5 364527 294.495411
|
|
177
|
HAWAT6 B5 27 295.698407
|
|
178
|
HAWAT6 S6 364527 300.457755
|
|
179
|
HAWAT6 B6 27 297.029526
|
|
180
|
HAWAT6 S7 364527 304.908720
|
|
181
|
HAWAT6 B7 27 290.184187
|
|
182
|
HAWAT6 S8 364527 304.943753
|
|
183
|
HAWAT6 B8 27 296.181375
|
|
184
|
HAWAT6 S9 364527 307.435567
|
|
185
|
HAWAT6 B9 27 300.331091
|