MongoDB Running testplan !2016-08-26T14:49:02 Init TS1.1: Impact of fragmentation on INSERT !2016-08-26T14:56:42 TS1.1 Run Empty [s] First [s] Middle [s] Delete [s] Fragmented [s] 1 127.922201 129.392131 129.354367 7.603520 130.301279 2 130.302063 129.946774 132.418760 7.608551 131.156769 3 129.552224 128.700161 132.994419 7.542808 130.664446 4 126.847849 127.684087 131.240836 7.597966 130.372580 5 129.696564 128.195218 132.982633 7.562814 130.898716 6 128.377722 126.907665 130.065722 7.521640 130.169196 7 129.502944 128.030488 131.437991 7.643319 131.553265 8 129.240116 129.007747 130.110507 7.581124 131.880039 9 130.553518 128.646558 132.235081 7.515750 131.059796 TS1.2: Impact of indexing and fragmentation on INSERT !2016-08-26T16:16:58 TS1.2 Run Empty [s] First [s] Middle [s] Delete [s] Fragmented [s] 1 173.647710 177.968113 183.993663 30.069588 184.758466 2 173.629722 178.415824 183.969028 30.070325 186.556422 3 174.022939 176.095028 182.031965 30.170620 184.657400 4 175.535268 177.974228 184.986954 29.766625 185.885353 5 175.615344 179.148640 187.290543 30.439705 187.112232 6 174.830304 178.366894 182.815570 30.042563 185.856504 7 173.601921 177.102745 182.955350 30.025276 184.144057 8 176.025728 177.213952 184.054311 30.023341 185.719333 9 175.469983 176.546728 184.125221 30.591613 185.935915 TS1.3: Index creation timing !2016-08-26T18:10:56 TS1.3 Run INSERT [s] DetectTime [s] ts [s] Name [s] !Detector [s] Src IP [s] !Src Range [s] 1 394.282975 6.756382 4.112482 17.050397 22.302891 8.520851 11.711954 2 394.209425 6.736578 4.117324 17.118401 22.194257 8.574414 11.774997 3 390.860696 6.710911 4.086974 17.112138 22.305206 8.593174 11.757838 4 391.908978 6.699310 4.100555 17.210869 22.235549 8.535727 11.632488 5 397.137158 6.729598 4.116091 17.489018 22.386854 8.523736 11.559902 6 391.927438 6.690400 4.126439 17.397926 22.480825 8.386318 11.796966 7 396.679676 6.602872 4.042784 16.909235 22.115287 8.416613 11.833548 8 394.259255 6.670743 4.076836 16.968165 22.299115 8.469255 11.620068 9 393.093860 6.720491 4.070675 16.935772 22.103473 8.478802 11.750964 TS1.4: Impact of indexing on INSERT time !2016-08-26T19:21:39 TS1.4 Run DetectTime [s] ts [s] Name [s] !Detector [s] Src IP [s] !Src Range [s] INSERT [s] 1 0.095333 0.007732 0.007909 0.009209 0.008688 0.008170 542.007565 2 0.028094 0.004556 0.005994 0.006236 0.005891 0.005027 551.804655 3 0.031046 0.004694 0.006085 0.008681 0.008709 0.004849 549.001550 4 0.035373 0.009057 0.007306 0.006811 0.007153 0.008803 546.248195 5 0.035590 0.009269 0.008941 0.009804 0.009003 0.006746 545.113158 6 0.036306 0.005918 0.007224 0.009196 0.007952 0.008808 552.632978 7 0.038022 0.008932 0.008672 0.008664 0.008570 0.009038 547.686718 8 0.072588 0.009210 0.008470 0.007839 0.007578 0.008251 546.923785 9 0.037439 0.009226 0.009427 0.008425 0.005091 0.008515 547.406995 TS2.1: Cold read !2016-08-26T20:45:10 TS2.1 Query Run find [s] sort [s] iterate [s] Results [-] Total Time [s] MENTAT 1 0.000283 0.000187 511.033009 6747529 511.035800 MENTAT 2 0.000268 0.000187 515.743728 6747529 515.746490 MENTAT 3 0.000262 0.000187 420.844979 6747529 420.847032 MENTAT 4 0.000265 0.000187 508.426094 6747529 508.427047 MENTAT 5 0.000267 0.000189 507.606699 6747529 507.607818 MENTAT 6 0.000268 0.000190 506.150227 6747529 506.151223 MENTAT 7 0.000264 0.000188 509.515272 6747529 509.517369 MENTAT 8 0.000264 0.000185 520.272144 6747529 520.274866 MENTAT 9 0.000268 0.000186 418.551855 6747529 418.553592 HAWAT1 1 0.000263 0.000193 86.109275 364527 86.109964 HAWAT1 2 0.000268 0.000190 86.152511 364527 86.153862 HAWAT1 3 0.000267 0.000192 85.538912 364527 85.540184 HAWAT1 4 0.000268 0.000188 84.850769 364527 84.851902 HAWAT1 5 0.000271 0.000194 81.707942 364527 81.708961 HAWAT1 6 0.000268 0.000193 85.110888 364527 85.112008 HAWAT1 7 0.000273 0.000193 78.681353 364527 78.682369 HAWAT1 8 0.000267 0.000188 86.021770 364527 86.022532 HAWAT1 9 0.000302 0.000195 78.741570 364527 78.742354 HAWAT2 1 0.000268 0.000190 87.096650 72334 87.097303 HAWAT2 2 0.000266 0.000198 87.789435 72334 87.790144 HAWAT2 3 0.000268 0.000211 88.842009 72334 88.842721 HAWAT2 4 0.000269 0.000196 88.513749 72334 88.514447 HAWAT2 5 0.000290 0.000196 87.926340 72334 87.927062 HAWAT2 6 0.000267 0.000195 88.451478 72334 88.452186 HAWAT2 7 0.000271 0.000196 87.127282 72334 87.127966 HAWAT2 8 0.000263 0.000198 88.195420 72334 88.196128 HAWAT2 9 0.000270 0.000195 90.182639 72334 90.183338 HAWAT3 1 0.000269 0.000195 490.509768 6237248 490.511532 HAWAT3 2 0.000270 0.000190 432.371037 6237248 432.372198 HAWAT3 3 0.000144 0.000096 454.269072 6237248 454.269495 HAWAT3 4 0.000266 0.000184 475.578615 6237248 475.579316 HAWAT3 5 0.000263 0.000183 461.287815 6237248 461.289052 HAWAT3 6 0.000268 0.000184 479.793021 6237248 479.793863 HAWAT3 7 0.000265 0.000187 487.537971 6237248 487.539051 HAWAT3 8 0.000267 0.000188 479.156575 6237248 479.158198 HAWAT3 9 0.000293 0.000195 418.960975 6237248 418.962579 HAWAT4 1 0.000263 0.000189 97.757782 961836 97.759354 HAWAT4 2 0.000268 0.000191 88.001651 961836 88.002373 HAWAT4 3 0.000267 0.000187 99.461632 961836 99.462742 HAWAT4 4 0.000271 0.000189 94.231371 961836 94.232250 HAWAT4 5 0.000272 0.000189 94.985798 961836 94.986669 HAWAT4 6 0.000267 0.000189 98.964201 961836 98.965096 HAWAT4 7 0.000268 0.000188 98.502563 961836 98.503450 HAWAT4 8 0.000268 0.000188 98.322375 961836 98.323237 HAWAT4 9 0.000265 0.000189 97.203095 961836 97.204188 HAWAT5 1 0.000264 0.000185 101.429182 961071 101.429867 HAWAT5 2 0.000269 0.000187 93.023187 961071 93.023861 HAWAT5 3 0.000273 0.000186 101.553183 961071 101.553852 HAWAT5 4 0.000298 0.000185 102.023856 961071 102.024561 HAWAT5 5 0.000269 0.000203 100.491724 961071 100.492429 HAWAT5 6 0.000305 0.000184 101.747961 961071 101.748663 HAWAT5 7 0.000268 0.000188 94.446469 961071 94.447141 HAWAT5 8 0.000272 0.000185 98.728326 961071 98.729004 HAWAT5 9 0.000275 0.000206 101.019464 961071 101.020175 HAWAT6 1 0.000268 0.000183 79.173390 364527 79.174537 HAWAT6 2 0.000270 0.000190 86.328840 364527 86.329747 HAWAT6 3 0.000269 0.000188 79.272074 364527 79.272844 HAWAT6 4 0.000273 0.000187 85.984156 364527 85.984929 HAWAT6 5 0.000270 0.000212 86.358828 364527 86.360034 HAWAT6 6 0.000270 0.000210 85.367100 364527 85.367907 HAWAT6 7 0.000263 0.000206 81.383568 364527 81.384375 HAWAT6 8 0.000265 0.000186 79.754849 364527 79.755697 HAWAT6 9 0.000269 0.000189 86.168911 364527 86.169820 HAWAT7 1 0.000268 0.000185 91.493113 68964 91.494022 HAWAT7 2 0.000270 0.000190 92.099406 68964 92.100378 HAWAT7 3 0.000271 0.000205 92.915546 68964 92.916550 HAWAT7 4 0.000276 0.000211 92.386829 68964 92.387583 HAWAT7 5 0.000268 0.000187 91.476902 68964 91.477834 HAWAT7 6 0.000274 0.000193 92.603941 68964 92.605127 HAWAT7 7 0.000270 0.000208 92.466109 68964 92.467113 HAWAT7 8 0.000271 0.000192 92.373811 68964 92.374530 HAWAT7 9 0.000273 0.000196 94.189761 68964 94.190721 TS2.2: Hot read !2016-08-27T00:38:02 TS2.2 Query Run find [s] sort [s] iterate [s] Results [-] Total Time [s] HAWAT1 COLD1 0.000271 0.000195 86.350134 364527 86.351100 HAWAT1 HOT1 0.000056 0.000065 59.839078 364525 59.839830 HAWAT2 COLD1 0.000266 0.000194 88.124338 72334 88.125024 HAWAT2 HOT1 0.000045 0.000054 51.832817 72334 51.832992 HAWAT3 COLD1 0.000273 0.000198 480.688220 6237248 480.689853 HAWAT3 HOT1 0.000056 0.000050 374.665166 6237343 374.666367 HAWAT4 COLD1 0.000269 0.000192 98.394072 961836 98.394850 HAWAT4 HOT1 0.000056 0.000050 61.603166 961836 61.603455 HAWAT5 COLD1 0.000273 0.000193 92.285556 961071 92.286211 HAWAT5 HOT1 0.000051 0.000045 65.179411 961071 65.179566 HAWAT6 COLD1 0.000268 0.000191 80.367874 364527 80.369202 HAWAT6 HOT1 0.000056 0.000050 59.492005 364525 59.492206 HAWAT7 COLD1 0.000263 0.000193 92.588143 68964 92.589450 HAWAT7 HOT1 0.000057 0.000049 50.524505 68964 50.524996 HAWAT1 COLD2 0.000269 0.000195 79.422035 364527 79.423050 HAWAT1 HOT2 0.000056 0.000049 56.223618 364525 56.224339 HAWAT2 COLD2 0.000319 0.000193 88.068263 72334 88.068986 HAWAT2 HOT2 0.000049 0.000042 51.055803 72334 51.055965 HAWAT3 COLD2 0.000270 0.000196 488.767272 6237248 488.769152 HAWAT3 HOT2 0.000058 0.000067 465.471592 6237343 465.473117 HAWAT4 COLD2 0.000269 0.000191 97.345328 961836 97.346322 HAWAT4 HOT2 0.000055 0.000064 71.348367 961836 71.348870 HAWAT5 COLD2 0.000274 0.000190 93.040005 961071 93.040659 HAWAT5 HOT2 0.000051 0.000044 68.285577 961071 68.285740 HAWAT6 COLD2 0.000269 0.000194 86.099274 364527 86.100787 HAWAT6 HOT2 0.000056 0.000065 59.075523 364525 59.075996 HAWAT7 COLD2 0.000268 0.000192 92.084753 68964 92.085677 HAWAT7 HOT2 0.000057 0.000050 50.771242 68964 50.771631 HAWAT1 COLD3 0.000269 0.000196 84.866414 364527 84.867539 HAWAT1 HOT3 0.000056 0.000065 58.278766 364525 58.279309 HAWAT2 COLD3 0.000274 0.000191 86.297139 72334 86.297853 HAWAT2 HOT3 0.000046 0.000041 54.607638 72334 54.607778 HAWAT3 COLD3 0.000268 0.000197 413.218996 6237248 413.220676 HAWAT3 HOT3 0.000055 0.000064 436.428298 6237343 436.429414 HAWAT4 COLD3 0.000274 0.000192 106.867295 961836 106.868316 HAWAT4 HOT3 0.000056 0.000066 70.525083 961836 70.525443 HAWAT5 COLD3 0.000118 0.000084 110.904617 961071 110.904935 HAWAT5 HOT3 0.000048 0.000057 75.227087 961071 75.227395 HAWAT6 COLD3 0.000271 0.000188 80.026302 364527 80.028014 HAWAT6 HOT3 0.000058 0.000051 56.913023 364525 56.914016 HAWAT7 COLD3 0.000268 0.000193 90.350966 68964 90.352011 HAWAT7 HOT3 0.000055 0.000067 51.701086 68964 51.701642 HAWAT1 COLD4 0.000271 0.000192 82.217079 364527 82.219270 HAWAT1 HOT4 0.000058 0.000064 56.243818 364525 56.244493 HAWAT2 COLD4 0.000272 0.000193 85.977842 72334 85.978574 HAWAT2 HOT4 0.000098 0.000097 51.059915 72334 51.060270 HAWAT3 COLD4 0.000273 0.000198 464.269669 6237248 464.271135 HAWAT3 HOT4 0.000057 0.000050 424.541086 6237343 424.542459 HAWAT4 COLD4 0.000264 0.000192 97.655963 961836 97.657040 HAWAT4 HOT4 0.000054 0.000064 65.650673 961836 65.651183 HAWAT5 COLD4 0.000270 0.000192 98.188798 961071 98.189462 HAWAT5 HOT4 0.000047 0.000056 74.329437 961071 74.329614 HAWAT6 COLD4 0.000269 0.000188 80.682261 364527 80.683353 HAWAT6 HOT4 0.000055 0.000062 58.936366 364525 58.936718 HAWAT7 COLD4 0.000268 0.000192 90.840174 68964 90.841126 HAWAT7 HOT4 0.000055 0.000050 51.019533 68964 51.020015 HAWAT1 COLD5 0.000305 0.000192 79.443524 364527 79.444369 HAWAT1 HOT5 0.000055 0.000049 58.925452 364525 58.925958 HAWAT2 COLD5 0.000269 0.000195 86.481730 72334 86.482396 HAWAT2 HOT5 0.000051 0.000054 51.852800 72334 51.852974 HAWAT3 COLD5 0.000270 0.000196 491.774496 6237248 491.775254 HAWAT3 HOT5 0.000054 0.000064 467.174607 6237343 467.175539 HAWAT4 COLD5 0.000271 0.000191 92.083364 961836 92.084231 HAWAT4 HOT5 0.000055 0.000048 61.444613 961836 61.444865 HAWAT5 COLD5 0.000273 0.000207 98.199694 961071 98.200372 HAWAT5 HOT5 0.000049 0.000044 73.102331 961071 73.102562 HAWAT6 COLD5 0.000274 0.000207 79.850924 364527 79.852113 HAWAT6 HOT5 0.000056 0.000049 53.353052 364525 53.354438 HAWAT7 COLD5 0.000289 0.000190 90.780127 68964 90.781174 HAWAT7 HOT5 0.000055 0.000063 52.026994 68964 52.027561 HAWAT1 COLD6 0.000269 0.000195 85.158191 364527 85.159693 HAWAT1 HOT6 0.000056 0.000065 59.340312 364525 59.340586 HAWAT2 COLD6 0.000273 0.000209 86.355776 72334 86.356491 HAWAT2 HOT6 0.000045 0.000053 52.247903 72334 52.248070 HAWAT3 COLD6 0.000273 0.000215 452.424948 6237248 452.425812 HAWAT3 HOT6 0.000056 0.000066 454.966447 6237343 454.966741 HAWAT4 COLD6 0.000270 0.000240 88.347305 961836 88.348448 HAWAT4 HOT6 0.000055 0.000051 61.724150 961836 61.724722 HAWAT5 COLD6 0.000271 0.000192 98.887185 961071 98.887846 HAWAT5 HOT6 0.000050 0.000045 69.763538 961071 69.763829 HAWAT6 COLD6 0.000263 0.000191 79.578916 364527 79.580157 HAWAT6 HOT6 0.000055 0.000049 53.637540 364525 53.638302 HAWAT7 COLD6 0.000268 0.000189 91.595693 68964 91.596700 HAWAT7 HOT6 0.000055 0.000064 51.864407 68964 51.864981 HAWAT1 COLD7 0.000269 0.000192 85.153012 364527 85.154322 HAWAT1 HOT7 0.000057 0.000064 58.296536 364525 58.298232 HAWAT2 COLD7 0.000269 0.000192 85.811315 72334 85.811977 HAWAT2 HOT7 0.000046 0.000041 50.432978 72334 50.433130 HAWAT3 COLD7 0.000277 0.000222 419.991227 6237248 419.992487 HAWAT3 HOT7 0.000056 0.000058 439.848673 6237343 439.850127 HAWAT4 COLD7 0.000266 0.000191 89.880599 961836 89.881574 HAWAT4 HOT7 0.000056 0.000049 70.705241 961836 70.705764 HAWAT5 COLD7 0.000268 0.000336 101.883743 961071 101.884555 HAWAT5 HOT7 0.000049 0.000058 75.197966 961071 75.198167 HAWAT6 COLD7 0.000306 0.000193 85.612869 364527 85.614216 HAWAT6 HOT7 0.000056 0.000064 59.178073 364525 59.179053 HAWAT7 COLD7 0.000264 0.000186 89.705307 68964 89.706367 HAWAT7 HOT7 0.000056 0.000065 51.739018 68964 51.740064 HAWAT1 COLD8 0.000267 0.000191 85.592848 364527 85.594331 HAWAT1 HOT8 0.000057 0.000067 59.510033 364525 59.510559 HAWAT2 COLD8 0.000270 0.000192 85.085181 72334 85.085845 HAWAT2 HOT8 0.000048 0.000042 50.468642 72334 50.468900 HAWAT3 COLD8 0.000273 0.000197 477.129824 6237248 477.131536 HAWAT3 HOT8 0.000055 0.000064 459.945071 6237343 459.946546 HAWAT4 COLD8 0.000272 0.000193 95.979044 961836 95.979838 HAWAT4 HOT8 0.000055 0.000065 71.386775 961836 71.387086 HAWAT5 COLD8 0.000271 0.000188 100.400267 961071 100.400928 HAWAT5 HOT8 0.000049 0.000058 74.688736 961071 74.688917 HAWAT6 COLD8 0.000269 0.000196 79.192888 364527 79.194048 HAWAT6 HOT8 0.000057 0.000050 53.385759 364525 53.386327 HAWAT7 COLD8 0.000267 0.000187 90.875301 68964 90.876903 HAWAT7 HOT8 0.000056 0.000049 50.837946 68964 50.838133 HAWAT1 COLD9 0.000269 0.000195 84.566740 364527 84.568187 HAWAT1 HOT9 0.000054 0.000065 54.371072 364525 54.371272 HAWAT2 COLD9 0.000267 0.000192 86.409299 72334 86.410055 HAWAT2 HOT9 0.000097 0.000108 51.874347 72334 51.874673 HAWAT3 COLD9 0.000268 0.000195 402.670680 6237248 402.672175 HAWAT3 HOT9 0.000057 0.000050 371.736473 6237343 371.737121 HAWAT4 COLD9 0.000269 0.000195 98.993367 961836 98.994545 HAWAT4 HOT9 0.000056 0.000067 71.850909 961836 71.851500 HAWAT5 COLD9 0.000271 0.000192 101.040562 961071 101.041226 HAWAT5 HOT9 0.000049 0.000058 69.058299 961071 69.058480 HAWAT6 COLD9 0.000271 0.000194 81.434117 364527 81.435546 HAWAT6 HOT9 0.000055 0.000065 59.390276 364525 59.391805 HAWAT7 COLD9 0.000266 0.000194 88.817852 68964 88.819276 HAWAT7 HOT9 0.000056 0.000050 50.447492 68964 50.447922 TS2.3: Impact of count() !2016-08-27T05:12:21 TS2.3 Query Run find [s] count [s] sort [s] iterate [s] Results [-] Total Time [s] HAWAT1 1 0.000265 56.128928 0.000105 55.175659 364527 111.305859 HAWAT1 2 0.000275 56.619195 0.000118 58.982486 364527 115.603125 HAWAT1 3 0.000270 57.923089 0.000116 53.116699 364527 111.040879 HAWAT1 4 0.000272 56.409457 0.000123 53.672709 364527 110.083271 HAWAT1 5 0.000301 56.407964 0.000121 56.473951 364527 112.882714 HAWAT1 6 0.000268 56.517492 0.000116 53.885593 364527 110.404270 HAWAT1 7 0.000273 56.580462 0.000114 53.781483 364527 110.362589 HAWAT1 8 0.000270 57.892323 0.000125 53.933985 364527 111.827511 HAWAT1 9 0.000271 56.875050 0.000125 53.746121 364527 110.622045 HAWAT2 1 0.000275 545.386286 0.000138 67.437590 72334 612.824560 HAWAT2 2 0.000274 520.923400 0.000116 66.635103 72334 587.559189 HAWAT2 3 0.000271 521.423326 0.000106 66.282444 72334 587.706428 HAWAT2 4 0.000270 535.550393 0.000116 66.925380 72334 602.476458 HAWAT2 5 0.000269 525.072939 0.000106 65.986712 72334 591.060318 HAWAT2 6 0.000268 530.178149 0.000113 66.356582 72334 596.535399 HAWAT2 7 0.000274 525.080818 0.000116 65.649010 72334 590.730485 HAWAT2 8 0.000270 526.597107 0.000115 66.585503 72334 593.183272 HAWAT2 9 0.000270 532.462767 0.000116 65.148566 72334 597.611981 HAWAT3 1 0.000272 40.610421 0.000105 425.069880 6237248 465.681156 HAWAT3 2 0.000272 42.287293 0.000104 407.870217 6237248 450.158406 HAWAT3 3 0.000264 42.015835 0.000105 405.769728 6237248 447.786370 HAWAT3 4 0.000269 41.534883 0.000104 393.948733 6237248 435.485238 HAWAT3 5 0.000266 41.808353 0.000103 446.122121 6237248 487.931374 HAWAT3 6 0.000267 41.466127 0.000114 440.741263 6237248 482.208312 HAWAT3 7 0.000269 41.480116 0.000116 462.657218 6237248 504.138291 HAWAT3 8 0.000272 41.759483 0.000115 405.576725 6237248 447.337284 HAWAT3 9 0.000270 41.365098 0.000104 368.848111 6237248 410.214217 HAWAT4 1 0.000277 50.185940 0.000103 64.458868 961836 114.645810 HAWAT4 2 0.000303 49.284152 0.000114 71.929763 961836 121.215014 HAWAT4 3 0.000275 50.194549 0.000114 72.467082 961836 122.662324 HAWAT4 4 0.000274 51.620420 0.000115 72.732308 961836 124.353441 HAWAT4 5 0.000278 50.334418 0.000105 63.241550 961836 113.576600 HAWAT4 6 0.000277 50.400753 0.000105 72.326241 961836 122.727770 HAWAT4 7 0.000279 49.781486 0.000105 62.670643 961836 112.453159 HAWAT4 8 0.000272 49.506952 0.000103 63.869591 961836 113.377262 HAWAT4 9 0.000275 49.393610 0.000104 62.248968 961836 111.643352 HAWAT5 1 0.000272 52.819272 0.000105 74.995112 961071 127.815008 HAWAT5 2 0.000273 54.081149 0.000105 65.552282 961071 119.634043 HAWAT5 3 0.000274 53.047477 0.000104 72.203634 961071 125.251757 HAWAT5 4 0.000271 53.931743 0.000103 74.637085 961071 128.569446 HAWAT5 5 0.000267 53.681319 0.000103 67.185935 961071 120.867864 HAWAT5 6 0.000274 53.130693 0.000105 68.430763 961071 121.562081 HAWAT5 7 0.000268 52.953536 0.000105 70.264384 961071 123.218541 HAWAT5 8 0.000272 52.782377 0.000105 66.269955 961071 119.052940 HAWAT5 9 0.000269 55.683445 0.000107 67.374636 961071 123.058842 HAWAT6 1 0.000118 57.452906 0.000103 53.904840 364527 111.358372 HAWAT6 2 0.000273 57.116536 0.000121 57.293111 364527 114.410359 HAWAT6 3 0.000275 56.867077 0.000118 53.684758 364527 110.552542 HAWAT6 4 0.000276 57.427454 0.000126 59.469088 364527 116.897273 HAWAT6 5 0.000270 58.479639 0.000065 56.234956 364527 114.715174 HAWAT6 6 0.000272 57.427493 0.000119 58.090372 364527 115.518521 HAWAT6 7 0.000272 57.433875 0.000119 54.067726 364527 111.502295 HAWAT6 8 0.000271 57.681110 0.000055 56.305394 364527 113.987071 HAWAT6 9 0.000276 57.611272 0.000118 54.256333 364527 111.868387 HAWAT7 1 0.000268 523.119257 0.000135 68.386140 68964 591.506137 HAWAT7 2 0.000275 521.163840 0.000118 68.011978 68964 589.176545 HAWAT7 3 0.000273 516.672529 0.000107 68.624607 68964 585.297777 HAWAT7 4 0.000272 522.729522 0.000121 69.636561 68964 592.367445 HAWAT7 5 0.000345 519.303917 0.000120 70.638318 68964 589.943218 HAWAT7 6 0.000273 527.421646 0.000119 69.414657 68964 596.836961 HAWAT7 7 0.000175 522.820333 0.000108 69.777803 68964 592.598865 HAWAT7 8 0.000272 523.975258 0.000115 69.591383 68964 593.567577 HAWAT7 9 0.000274 523.020736 0.000115 69.817426 68964 592.839587 OTHER2 1 0.000276 59.960017 0.000117 60.012506 353365 119.973234 OTHER2 2 0.000116 58.370723 0.000104 54.329250 353365 112.700368 OTHER2 3 0.000273 57.669037 0.000114 57.791307 353365 115.461017 OTHER2 4 0.000274 58.107281 0.000046 53.999477 353365 112.107297 OTHER2 5 0.000300 57.776713 0.000103 53.757529 353365 111.534904 OTHER2 6 0.000269 59.177150 0.000104 57.460360 353365 116.638291 OTHER2 7 0.000275 58.156169 0.000104 54.444806 353365 112.601741 OTHER2 8 0.000275 57.770462 0.000104 57.488160 353365 115.259349 OTHER2 9 0.000267 57.737532 0.000104 53.876072 353365 111.614220 TS2.4: Descending sort !2016-08-27T10:54:20 TS2.4 Query Run find [s] sort [s] iterate [s] Results [-] Total Time [s] HAWAT1 1 0.000262 0.000190 303.946681 364527 303.947616 HAWAT1 2 0.000271 0.000190 304.008823 364527 304.009784 HAWAT1 3 0.000265 0.000190 308.690606 364527 308.691580 HAWAT1 4 0.000270 0.000191 309.447409 364527 309.448667 HAWAT1 5 0.000273 0.000194 302.190748 364527 302.191455 HAWAT1 6 0.000264 0.000189 306.066466 364527 306.067569 HAWAT1 7 0.000264 0.000189 300.134607 364527 300.135810 HAWAT1 8 0.000270 0.000191 312.552629 364527 312.553873 HAWAT1 9 0.000269 0.000190 307.377933 364527 307.378777 HAWAT2 1 0.000311 0.000189 296.082076 72334 296.082824 HAWAT2 2 0.000271 0.000196 296.880929 72334 296.881668 HAWAT2 3 0.000270 0.000197 292.862825 72334 292.863523 HAWAT2 4 0.000277 0.000196 293.976519 72334 293.977413 HAWAT2 5 0.000115 0.000099 303.263950 72334 303.264529 HAWAT2 6 0.000273 0.000194 301.593339 72334 301.594052 HAWAT2 7 0.000276 0.000198 294.940591 72334 294.941358 HAWAT2 8 0.000273 0.000197 301.273740 72334 301.274544 HAWAT2 9 0.000270 0.000210 298.578141 72334 298.578881 HAWAT3 1 0.000314 0.000216 625.641411 6237248 625.642276 HAWAT3 2 0.000268 0.000226 633.984323 6237248 633.985146 HAWAT3 3 0.000267 0.000216 625.320163 6237248 625.320983 HAWAT3 4 0.000267 0.000211 637.394384 6237248 637.395193 HAWAT3 5 0.000269 0.000222 643.048944 6237248 643.049749 HAWAT3 6 0.000267 0.000197 627.043752 6237248 627.044628 HAWAT3 7 0.000268 0.000195 640.376453 6237248 640.377227 HAWAT3 8 0.000264 0.000196 655.550836 6237248 655.552005 HAWAT3 9 0.000268 0.000192 632.926614 6237248 632.927758 HAWAT4 1 0.000265 0.000194 309.587799 961836 309.588707 HAWAT4 2 0.000269 0.000195 320.926643 961836 320.927893 HAWAT4 3 0.000268 0.000190 316.522752 961836 316.523815 HAWAT4 4 0.000271 0.000192 311.558165 961836 311.559136 HAWAT4 5 0.000271 0.000193 310.167622 961836 310.168983 HAWAT4 6 0.000271 0.000188 309.826669 961836 309.827691 HAWAT4 7 0.000268 0.000190 311.627138 961836 311.627991 HAWAT4 8 0.000270 0.000193 320.967746 961836 320.969014 HAWAT4 9 0.000270 0.000187 309.000765 961836 309.001744 HAWAT5 1 0.000269 0.000192 318.498921 961071 318.499641 HAWAT5 2 0.000270 0.000195 318.273743 961071 318.274469 HAWAT5 3 0.000270 0.000195 320.479179 961071 320.479978 HAWAT5 4 0.000270 0.000195 311.816791 961071 311.817543 HAWAT5 5 0.000271 0.000209 324.863733 961071 324.864540 HAWAT5 6 0.000269 0.000246 321.490107 961071 321.490934 HAWAT5 7 0.000267 0.000193 346.196830 961071 346.197648 HAWAT5 8 0.000270 0.000195 363.158751 961071 363.159541 HAWAT5 9 0.000268 0.000192 379.695570 961071 379.696242 HAWAT6 1 0.000306 0.000197 359.229975 364527 359.231253 HAWAT6 2 0.000267 0.000191 377.495457 364527 377.497386 HAWAT6 3 0.000268 0.000195 351.360839 364527 351.361630 HAWAT6 4 0.000274 0.000194 349.121862 364527 349.122673 HAWAT6 5 0.000272 0.000193 357.726026 364527 357.727948 HAWAT6 6 0.000268 0.000188 352.029644 364527 352.030874 HAWAT6 7 0.000264 0.000190 368.647001 364527 368.648114 HAWAT6 8 0.000265 0.000190 362.230575 364527 362.231702 HAWAT6 9 0.000267 0.000191 373.849453 364527 373.851310 HAWAT7 1 0.000272 0.000191 364.863858 68964 364.865528 HAWAT7 2 0.000270 0.000198 360.247088 68964 360.248008 HAWAT7 3 0.000273 0.000195 380.012131 68964 380.013898 HAWAT7 4 0.000272 0.000196 380.327933 68964 380.328910 HAWAT7 5 0.000270 0.000193 347.522429 68964 347.523425 HAWAT7 6 0.000272 0.000192 349.819539 68964 349.820275 HAWAT7 7 0.000268 0.000194 391.997389 68964 391.998318 HAWAT7 8 0.000275 0.000193 393.938469 68964 393.939606 HAWAT7 9 0.000299 0.000191 382.269969 68964 382.270966 End !2016-08-27T17:34:34 TS2.5 TS2.5: Impact of list size on query time !2016-08-28T19:29:12 TS2.5 Query Run find [s] iterate [s] Results [-] Total Time [s] OTHER1 LIST(2) 1 0.000292 85.309108 585092 85.309621 OTHER1 LIST(2) 2 0.000248 85.403787 585092 85.404724 OTHER1 LIST(2) 3 0.000246 85.158338 585092 85.159557 OTHER1 LIST(2) 4 0.000275 84.714374 585092 84.715073 OTHER1 LIST(2) 5 0.000243 84.193268 585092 84.193941 OTHER1 LIST(2) 6 0.000249 85.336396 585092 85.337574 OTHER1 LIST(2) 7 0.000249 84.581644 585092 84.583087 OTHER1 LIST(2) 8 0.000248 83.842330 585092 83.843740 OTHER1 LIST(2) 9 0.000247 84.939007 585092 84.939798 OTHER1 LIST(4) 1 0.000256 106.617359 1065895 106.620152 OTHER1 LIST(4) 2 0.000251 107.545930 1065895 107.547145 OTHER1 LIST(4) 3 0.000244 108.144930 1065895 108.146751 OTHER1 LIST(4) 4 0.000245 107.500582 1065895 107.502743 OTHER1 LIST(4) 5 0.000244 108.707623 1065895 108.710490 OTHER1 LIST(4) 6 0.000248 107.563322 1065895 107.566289 OTHER1 LIST(4) 7 0.000248 107.839557 1065895 107.842582 OTHER1 LIST(4) 8 0.000245 108.215022 1065895 108.217696 OTHER1 LIST(4) 9 0.000245 108.293715 1065895 108.296603 OTHER1 LIST(8) 1 0.000255 148.623771 1949772 148.624436 OTHER1 LIST(8) 2 0.000246 149.623780 1949772 149.624517 OTHER1 LIST(8) 3 0.000249 151.038550 1949772 151.039086 OTHER1 LIST(8) 4 0.000252 149.656575 1949772 149.657225 OTHER1 LIST(8) 5 0.000254 151.882990 1949772 151.883733 OTHER1 LIST(8) 6 0.000252 152.948044 1949772 152.948698 OTHER1 LIST(8) 7 0.000255 153.823821 1949772 153.825296 OTHER1 LIST(8) 8 0.000250 153.956117 1949772 153.957514 OTHER1 LIST(8) 9 0.000253 152.646311 1949772 152.646977 OTHER1 LIST(16) 1 0.000259 252.003717 2141519 252.004172 OTHER1 LIST(16) 2 0.000253 247.438853 2141519 247.439316 OTHER1 LIST(16) 3 0.000248 246.683937 2141519 246.684413 OTHER1 LIST(16) 4 0.000253 249.808197 2141519 249.808634 OTHER1 LIST(16) 5 0.000253 247.054645 2141519 247.055120 OTHER1 LIST(16) 6 0.000249 249.880643 2141519 249.881075 OTHER1 LIST(16) 7 0.000250 247.243855 2141519 247.244303 OTHER1 LIST(16) 8 0.000251 247.447255 2141519 247.447695 OTHER1 LIST(16) 9 0.000248 247.579152 2141519 247.579582 OTHER1 LIST(32) 1 0.000260 176.692752 2454499 176.695219 OTHER1 LIST(32) 2 0.000250 173.962569 2454499 173.964572 OTHER1 LIST(32) 3 0.000250 176.502946 2454499 176.505006 OTHER1 LIST(32) 4 0.000249 171.298658 2454499 171.300236 OTHER1 LIST(32) 5 0.000248 171.208730 2454499 171.211086 OTHER1 LIST(32) 6 0.000252 174.746956 2454499 174.749243 OTHER1 LIST(32) 7 0.000249 170.800640 2454499 170.801110 OTHER1 LIST(32) 8 0.000284 173.521612 2454499 173.522413 OTHER1 LIST(32) 9 0.000250 172.459550 2454499 172.460370 OTHER1 LIST(64) 1 0.000263 192.689700 2877964 192.691241 OTHER1 LIST(64) 2 0.000257 191.558554 2877964 191.559122 OTHER1 LIST(64) 3 0.000260 191.924855 2877964 191.926381 OTHER1 LIST(64) 4 0.000262 199.189215 2877964 199.190691 OTHER1 LIST(64) 5 0.000170 196.708135 2877964 196.709518 OTHER1 LIST(64) 6 0.000260 197.146672 2877964 197.147262 OTHER1 LIST(64) 7 0.000258 196.663581 2877964 196.665028 OTHER1 LIST(64) 8 0.000303 195.885461 2877964 195.886906 OTHER1 LIST(64) 9 0.000256 195.093681 2877964 195.095290 OTHER1 LIST(128) 1 0.000264 540.932335 3274716 540.932839 OTHER1 LIST(128) 2 0.000255 536.876381 3274716 536.876819 OTHER1 LIST(128) 3 0.000259 532.903233 3274716 532.903668 OTHER1 LIST(128) 4 0.000259 534.650791 3274716 534.651276 OTHER1 LIST(128) 5 0.000258 534.705771 3274716 534.706209 OTHER1 LIST(128) 6 0.000255 533.465872 3274716 533.466307 OTHER1 LIST(128) 7 0.000256 534.572861 3274716 534.573309 OTHER1 LIST(128) 8 0.000262 531.801165 3274716 531.801703 OTHER1 LIST(128) 9 0.000259 532.657019 3274716 532.657574 TS3.1: Batched read using SKIP+LIMIT, COLD !2016-08-28T23:19:39 TS3.1 Query Run Results [-] Total Time [s] HAWAT1 S1 7068 2.041117 HAWAT1 B1 7068 46.274450 HAWAT1 S2 7068 1.974957 HAWAT1 B2 7068 46.484994 HAWAT1 S3 7068 2.637872 HAWAT1 B3 7068 46.374636 HAWAT1 S4 7068 2.202773 HAWAT1 B4 7068 46.513879 HAWAT1 S5 7068 2.014362 HAWAT1 B5 7068 46.504773 HAWAT1 S6 7068 2.111150 HAWAT1 B6 7068 46.234607 HAWAT1 S7 7068 2.103107 HAWAT1 B7 7068 46.546200 HAWAT1 S8 7068 2.123680 HAWAT1 B8 7068 46.408190 HAWAT1 S9 7068 2.117512 HAWAT1 B9 7068 46.958138 HAWAT3 S1 143657 7.759152 HAWAT3 B1 143657 502.120570 HAWAT3 S2 143657 7.739480 HAWAT3 B2 143657 501.900951 HAWAT3 S3 143657 7.812472 HAWAT3 B3 143657 502.277066 HAWAT3 S4 143657 7.792722 HAWAT3 B4 143657 492.111689 HAWAT3 S5 143657 7.823419 HAWAT3 B5 143657 496.734792 HAWAT3 S6 143657 7.921954 HAWAT3 B6 143657 498.273288 HAWAT3 S7 143657 7.854594 HAWAT3 B7 143657 500.296681 HAWAT3 S8 143657 7.541185 HAWAT3 B8 143657 500.481219 HAWAT3 S9 143657 7.759399 HAWAT3 B9 143657 492.787675 HAWAT4 S1 17730 2.143916 HAWAT4 B1 17730 102.667594 HAWAT4 S2 17730 2.058725 HAWAT4 B2 17730 105.092041 HAWAT4 S3 17730 2.096076 HAWAT4 B3 17730 104.796015 HAWAT4 S4 17730 1.975656 HAWAT4 B4 17730 102.386076 HAWAT4 S5 17730 1.954580 HAWAT4 B5 17730 102.946305 HAWAT4 S6 17730 1.883833 HAWAT4 B6 17730 102.850934 HAWAT4 S7 17730 2.044334 HAWAT4 B7 17730 103.603665 HAWAT4 S8 17730 1.985562 HAWAT4 B8 17730 101.773075 HAWAT4 S9 17730 2.396481 HAWAT4 B9 17730 104.955900 HAWAT5 S1 17724 1.963812 HAWAT5 B1 17724 119.895189 HAWAT5 S2 17724 2.225648 HAWAT5 B2 17724 119.853201 HAWAT5 S3 17724 2.171825 HAWAT5 B3 17724 118.239951 HAWAT5 S4 17724 2.113179 HAWAT5 B4 17724 121.077077 HAWAT5 S5 17724 1.996060 HAWAT5 B5 17724 120.299923 HAWAT5 S6 17724 2.215032 HAWAT5 B6 17724 120.410087 HAWAT5 S7 17724 2.170963 HAWAT5 B7 17724 119.963739 HAWAT5 S8 17724 2.186691 HAWAT5 B8 17724 119.405156 HAWAT5 S9 17724 2.106899 HAWAT5 B9 17724 120.339450 HAWAT6 S1 7068 2.193597 HAWAT6 B1 7068 47.367378 HAWAT6 S2 7068 2.324118 HAWAT6 B2 7068 47.020386 HAWAT6 S3 7068 2.261488 HAWAT6 B3 7068 46.744962 HAWAT6 S4 7068 2.222433 HAWAT6 B4 7068 47.698421 HAWAT6 S5 7068 2.232777 HAWAT6 B5 7068 46.406152 HAWAT6 S6 7068 2.210899 HAWAT6 B6 7068 46.876552 HAWAT6 S7 7068 2.172889 HAWAT6 B7 7068 46.948755 HAWAT6 S8 7068 2.223305 HAWAT6 B8 7068 46.523153 HAWAT6 S9 7068 2.351850 HAWAT6 B9 7068 47.924846 TS3.2: Batched read using SKIP+LIMIT, COLD, descending sort !2016-08-29T01:32:33 TS3.2 Query Run Results [-] Total Time [s] HAWAT1 S1 7068 6.832209 HAWAT1 B1 7068 68.421570 HAWAT1 S2 7068 6.871713 HAWAT1 B2 7068 69.937015 HAWAT1 S3 7068 6.643312 HAWAT1 B3 7068 68.553704 HAWAT1 S4 7068 6.718763 HAWAT1 B4 7068 69.297647 HAWAT1 S5 7068 6.948518 HAWAT1 B5 7068 69.523425 HAWAT1 S6 7068 6.724933 HAWAT1 B6 7068 68.820351 HAWAT1 S7 7068 6.918917 HAWAT1 B7 7068 69.978024 HAWAT1 S8 7068 6.738763 HAWAT1 B8 7068 68.904353 HAWAT1 S9 7068 6.762707 HAWAT1 B9 7068 68.711615 HAWAT3 S1 143657 11.885667 HAWAT3 B1 143657 548.665974 HAWAT3 S2 143657 11.998656 HAWAT3 B2 143657 547.565119 HAWAT3 S3 143657 12.258986 HAWAT3 B3 143657 559.434639 HAWAT3 S4 143657 11.833114 HAWAT3 B4 143657 538.467030 HAWAT3 S5 143657 11.813205 HAWAT3 B5 143657 529.839122 HAWAT3 S6 143657 11.985153 HAWAT3 B6 143657 540.301619 HAWAT3 S7 143657 11.644954 HAWAT3 B7 143657 534.533140 HAWAT3 S8 143657 12.674420 HAWAT3 B8 143657 531.582379 HAWAT3 S9 143657 12.186682 HAWAT3 B9 143657 558.585608 HAWAT4 S1 17730 6.700466 HAWAT4 B1 17730 101.522750 HAWAT4 S2 17730 6.615232 HAWAT4 B2 17730 101.912969 HAWAT4 S3 17730 6.481664 HAWAT4 B3 17730 98.587956 HAWAT4 S4 17730 6.308944 HAWAT4 B4 17730 100.744002 HAWAT4 S5 17730 6.508421 HAWAT4 B5 17730 99.489153 HAWAT4 S6 17730 6.502958 HAWAT4 B6 17730 102.499532 HAWAT4 S7 17730 6.545856 HAWAT4 B7 17730 98.543858 HAWAT4 S8 17730 6.655805 HAWAT4 B8 17730 100.065373 HAWAT4 S9 17730 6.555724 HAWAT4 B9 17730 99.887305 HAWAT5 S1 17724 6.744722 HAWAT5 B1 17724 117.729866 HAWAT5 S2 17724 6.508594 HAWAT5 B2 17724 115.029915 HAWAT5 S3 17724 6.529837 HAWAT5 B3 17724 116.285848 HAWAT5 S4 17724 6.516873 HAWAT5 B4 17724 119.371877 HAWAT5 S5 17724 6.572405 HAWAT5 B5 17724 115.309178 HAWAT5 S6 17724 6.528806 HAWAT5 B6 17724 114.658110 HAWAT5 S7 17724 6.758385 HAWAT5 B7 17724 117.408255 HAWAT5 S8 17724 6.587494 HAWAT5 B8 17724 116.239774 HAWAT5 S9 17724 6.720783 HAWAT5 B9 17724 116.343932 HAWAT6 S1 7068 6.728187 HAWAT6 B1 7068 69.895496 HAWAT6 S2 7068 6.662333 HAWAT6 B2 7068 70.071798 HAWAT6 S3 7068 7.035845 HAWAT6 B3 7068 68.708470 HAWAT6 S4 7068 6.819496 HAWAT6 B4 7068 68.976871 HAWAT6 S5 7068 6.694632 HAWAT6 B5 7068 69.143331 HAWAT6 S6 7068 6.924413 HAWAT6 B6 7068 69.497977 HAWAT6 S7 7068 6.835949 HAWAT6 B7 7068 69.471609 HAWAT6 S8 7068 6.778259 HAWAT6 B8 7068 68.931042 HAWAT6 S9 7068 6.639160 HAWAT6 B9 7068 68.883142 TS3.3: Batched read using SKIP+LIMIT, HOT !2016-08-29T04:01:09 TS3.3 Query Run Results [-] Total Time [s] HAWAT1 COLD1 50 0.278733 HAWAT1 THREE1 150 0.329743 HAWAT1 HOT1 50 0.020097 HAWAT3 COLD1 50 0.067436 HAWAT3 THREE1 150 0.066342 HAWAT3 HOT1 50 0.001818 HAWAT4 COLD1 50 0.134319 HAWAT4 THREE1 150 0.128998 HAWAT4 HOT1 50 0.008289 HAWAT5 COLD1 50 0.220432 HAWAT5 THREE1 150 0.166561 HAWAT5 HOT1 50 0.010344 HAWAT6 COLD1 50 0.344678 HAWAT6 THREE1 150 0.381098 HAWAT6 HOT1 50 0.018687 HAWAT1 COLD2 50 0.286649 HAWAT1 THREE2 150 0.352596 HAWAT1 HOT2 50 0.019889 HAWAT3 COLD2 50 0.061187 HAWAT3 THREE2 150 0.065349 HAWAT3 HOT2 50 0.001997 HAWAT4 COLD2 50 0.130636 HAWAT4 THREE2 150 0.141123 HAWAT4 HOT2 50 0.008501 HAWAT5 COLD2 50 0.156581 HAWAT5 THREE2 150 0.183726 HAWAT5 HOT2 50 0.010956 HAWAT6 COLD2 50 0.339211 HAWAT6 THREE2 150 0.382840 HAWAT6 HOT2 50 0.028312 HAWAT1 COLD3 50 0.287384 HAWAT1 THREE3 150 0.368686 HAWAT1 HOT3 50 0.018125 HAWAT3 COLD3 50 0.057564 HAWAT3 THREE3 150 0.066732 HAWAT3 HOT3 50 0.002119 HAWAT4 COLD3 50 0.128341 HAWAT4 THREE3 150 0.134054 HAWAT4 HOT3 50 0.009560 HAWAT5 COLD3 50 0.154989 HAWAT5 THREE3 150 0.188828 HAWAT5 HOT3 50 0.009799 HAWAT6 COLD3 50 0.352284 HAWAT6 THREE3 150 0.375376 HAWAT6 HOT3 50 0.019983 HAWAT1 COLD4 50 0.289518 HAWAT1 THREE4 150 0.339122 HAWAT1 HOT4 50 0.020648 HAWAT3 COLD4 50 0.063436 HAWAT3 THREE4 150 0.076769 HAWAT3 HOT4 50 0.002339 HAWAT4 COLD4 50 0.130035 HAWAT4 THREE4 150 0.141575 HAWAT4 HOT4 50 0.010565 HAWAT5 COLD4 50 0.168916 HAWAT5 THREE4 150 0.181826 HAWAT5 HOT4 50 0.009660 HAWAT6 COLD4 50 0.341016 HAWAT6 THREE4 150 0.398718 HAWAT6 HOT4 50 0.020076 HAWAT1 COLD5 50 0.332977 HAWAT1 THREE5 150 0.343529 HAWAT1 HOT5 50 0.020070 HAWAT3 COLD5 50 0.059369 HAWAT3 THREE5 150 0.071662 HAWAT3 HOT5 50 0.002133 HAWAT4 COLD5 50 0.132725 HAWAT4 THREE5 150 0.129857 HAWAT4 HOT5 50 0.008815 HAWAT5 COLD5 50 0.162713 HAWAT5 THREE5 150 0.188010 HAWAT5 HOT5 50 0.009627 HAWAT6 COLD5 50 0.339471 HAWAT6 THREE5 150 0.369050 HAWAT6 HOT5 50 0.020359 HAWAT1 COLD6 50 0.288665 HAWAT1 THREE6 150 0.361659 HAWAT1 HOT6 50 0.018608 HAWAT3 COLD6 50 0.059126 HAWAT3 THREE6 150 0.068089 HAWAT3 HOT6 50 0.002689 HAWAT4 COLD6 50 0.109814 HAWAT4 THREE6 150 0.139188 HAWAT4 HOT6 50 0.008901 HAWAT5 COLD6 50 0.165926 HAWAT5 THREE6 150 0.178364 HAWAT5 HOT6 50 0.009939 HAWAT6 COLD6 50 0.452627 HAWAT6 THREE6 150 0.386198 HAWAT6 HOT6 50 0.017823 HAWAT1 COLD7 50 0.306619 HAWAT1 THREE7 150 0.331932 HAWAT1 HOT7 50 0.019387 HAWAT3 COLD7 50 0.058720 HAWAT3 THREE7 150 0.079863 HAWAT3 HOT7 50 0.002816 HAWAT4 COLD7 50 0.130145 HAWAT4 THREE7 150 0.143578 HAWAT4 HOT7 50 0.009174 HAWAT5 COLD7 50 0.151356 HAWAT5 THREE7 150 0.185967 HAWAT5 HOT7 50 0.009257 HAWAT6 COLD7 50 0.336810 HAWAT6 THREE7 150 0.384950 HAWAT6 HOT7 50 0.017582 HAWAT1 COLD8 50 0.288099 HAWAT1 THREE8 150 0.332176 HAWAT1 HOT8 50 0.020650 HAWAT3 COLD8 50 0.063274 HAWAT3 THREE8 150 0.070790 HAWAT3 HOT8 50 0.002840 HAWAT4 COLD8 50 0.128762 HAWAT4 THREE8 150 0.133202 HAWAT4 HOT8 50 0.009512 HAWAT5 COLD8 50 0.155758 HAWAT5 THREE8 150 0.182928 HAWAT5 HOT8 50 0.012838 HAWAT6 COLD8 50 0.348620 HAWAT6 THREE8 150 0.402376 HAWAT6 HOT8 50 0.019534 HAWAT1 COLD9 50 0.311904 HAWAT1 THREE9 150 0.351017 HAWAT1 HOT9 50 0.021685 HAWAT3 COLD9 50 0.063418 HAWAT3 THREE9 150 0.068045 HAWAT3 HOT9 50 0.001852 HAWAT4 COLD9 50 0.130207 HAWAT4 THREE9 150 0.130562 HAWAT4 HOT9 50 0.008250 HAWAT5 COLD9 50 0.168705 HAWAT5 THREE9 150 0.178656 HAWAT5 HOT9 50 0.009238 HAWAT6 COLD9 50 0.343381 HAWAT6 THREE9 150 0.385462 HAWAT6 HOT9 50 0.018114 TS3.4: Batched read using SKIP+LIMIT, HOT, descending order !2016-08-29T04:09:28 TS3.4 Query Run Results [-] Total Time [s] HAWAT1 COLD1 50 0.376849 HAWAT1 THREE1 150 0.643383 HAWAT1 HOT1 50 0.035493 HAWAT3 COLD1 50 0.076166 HAWAT3 THREE1 150 0.090699 HAWAT3 HOT1 50 0.008745 HAWAT4 COLD1 50 0.131166 HAWAT4 THREE1 150 0.101464 HAWAT4 HOT1 50 0.010781 HAWAT5 COLD1 50 0.105577 HAWAT5 THREE1 150 0.121844 HAWAT5 HOT1 50 0.010110 HAWAT6 COLD1 50 0.424986 HAWAT6 THREE1 150 0.773769 HAWAT6 HOT1 50 0.041624 HAWAT1 COLD2 50 0.368931 HAWAT1 THREE2 150 0.681875 HAWAT1 HOT2 50 0.028119 HAWAT3 COLD2 50 0.072713 HAWAT3 THREE2 150 0.088781 HAWAT3 HOT2 50 0.009618 HAWAT4 COLD2 50 0.110219 HAWAT4 THREE2 150 0.103166 HAWAT4 HOT2 50 0.011984 HAWAT5 COLD2 50 0.113746 HAWAT5 THREE2 150 0.118670 HAWAT5 HOT2 50 0.014767 HAWAT6 COLD2 50 0.421266 HAWAT6 THREE2 150 0.677665 HAWAT6 HOT2 50 0.036158 HAWAT1 COLD3 50 0.361327 HAWAT1 THREE3 150 0.641746 HAWAT1 HOT3 50 0.032243 HAWAT3 COLD3 50 0.072916 HAWAT3 THREE3 150 0.125911 HAWAT3 HOT3 50 0.048249 HAWAT4 COLD3 50 0.093690 HAWAT4 THREE3 150 0.100123 HAWAT4 HOT3 50 0.015383 HAWAT5 COLD3 50 0.108173 HAWAT5 THREE3 150 0.123933 HAWAT5 HOT3 50 0.014082 HAWAT6 COLD3 50 0.425276 HAWAT6 THREE3 150 0.709894 HAWAT6 HOT3 50 0.035248 HAWAT1 COLD4 50 0.369732 HAWAT1 THREE4 150 0.642046 HAWAT1 HOT4 50 0.037910 HAWAT3 COLD4 50 0.076105 HAWAT3 THREE4 150 0.092706 HAWAT3 HOT4 50 0.011200 HAWAT4 COLD4 50 0.099613 HAWAT4 THREE4 150 0.129716 HAWAT4 HOT4 50 0.014992 HAWAT5 COLD4 50 0.114889 HAWAT5 THREE4 150 0.122415 HAWAT5 HOT4 50 0.013883 HAWAT6 COLD4 50 0.408770 HAWAT6 THREE4 150 0.717548 HAWAT6 HOT4 50 0.032633 HAWAT1 COLD5 50 0.394298 HAWAT1 THREE5 150 0.625751 HAWAT1 HOT5 50 0.036592 HAWAT3 COLD5 50 0.072117 HAWAT3 THREE5 150 0.089744 HAWAT3 HOT5 50 0.009250 HAWAT4 COLD5 50 0.100378 HAWAT4 THREE5 150 0.104867 HAWAT4 HOT5 50 0.010904 HAWAT5 COLD5 50 0.116917 HAWAT5 THREE5 150 0.120457 HAWAT5 HOT5 50 0.012706 HAWAT6 COLD5 50 0.416855 HAWAT6 THREE5 150 0.673236 HAWAT6 HOT5 50 0.035178 HAWAT1 COLD6 50 0.371882 HAWAT1 THREE6 150 0.635888 HAWAT1 HOT6 50 0.037244 HAWAT3 COLD6 50 0.076056 HAWAT3 THREE6 150 0.089355 HAWAT3 HOT6 50 0.009076 HAWAT4 COLD6 50 0.095267 HAWAT4 THREE6 150 0.097756 HAWAT4 HOT6 50 0.015809 HAWAT5 COLD6 50 0.105297 HAWAT5 THREE6 150 0.124330 HAWAT5 HOT6 50 0.014937 HAWAT6 COLD6 50 0.421190 HAWAT6 THREE6 150 0.789711 HAWAT6 HOT6 50 0.028590 HAWAT1 COLD7 50 0.396029 HAWAT1 THREE7 150 0.645980 HAWAT1 HOT7 50 0.035208 HAWAT3 COLD7 50 0.084196 HAWAT3 THREE7 150 0.094293 HAWAT3 HOT7 50 0.008628 HAWAT4 COLD7 50 0.101437 HAWAT4 THREE7 150 0.105299 HAWAT4 HOT7 50 0.010170 HAWAT5 COLD7 50 0.109393 HAWAT5 THREE7 150 0.114172 HAWAT5 HOT7 50 0.014517 HAWAT6 COLD7 50 0.438680 HAWAT6 THREE7 150 0.717870 HAWAT6 HOT7 50 0.028345 HAWAT1 COLD8 50 0.356971 HAWAT1 THREE8 150 0.725775 HAWAT1 HOT8 50 0.029471 HAWAT3 COLD8 50 0.075919 HAWAT3 THREE8 150 0.087727 HAWAT3 HOT8 50 0.013277 HAWAT4 COLD8 50 0.094454 HAWAT4 THREE8 150 0.103936 HAWAT4 HOT8 50 0.012673 HAWAT5 COLD8 50 0.108493 HAWAT5 THREE8 150 0.134076 HAWAT5 HOT8 50 0.016344 HAWAT6 COLD8 50 0.421305 HAWAT6 THREE8 150 0.693844 HAWAT6 HOT8 50 0.040571 HAWAT1 COLD9 50 0.376871 HAWAT1 THREE9 150 0.654656 HAWAT1 HOT9 50 0.037762 HAWAT3 COLD9 50 0.076160 HAWAT3 THREE9 150 0.087668 HAWAT3 HOT9 50 0.013826 HAWAT4 COLD9 50 0.094395 HAWAT4 THREE9 150 0.096633 HAWAT4 HOT9 50 0.010132 HAWAT5 COLD9 50 0.115535 HAWAT5 THREE9 150 0.129056 HAWAT5 HOT9 50 0.011085 HAWAT6 COLD9 50 0.429119 HAWAT6 THREE9 150 0.710183 HAWAT6 HOT9 50 0.041005