iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.604-36.617=-0.013 | | σ | 0.002-0.002=0.000 | | min | 36.603-36.616=-0.013 | | max | 36.607-36.619=-0.013 |
| | mean | 4282.875-4288.625=-5.750 | | σ | 1979.690-1975.521=4.169 | | min | 1546.000-1554.000=-8.000 | | max | 7207.000-7213.000=-6.000 |
| | mean | 71.392-76.096=-4.704 | | σ | 166.180-178.763=-12.583 | | min | 12.460-12.491=-0.031 | | max | 482.665-518.510=-35.845 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.604-36.618=-0.013 | | σ | 0.002-0.002=0.000 | | min | 36.603-36.616=-0.013 | | max | 36.607-36.620=-0.013 |
| | mean | 4282.875-4288.625=-5.750 | | σ | 1979.690-1975.521=4.169 | | min | 1546.000-1554.000=-8.000 | | max | 7207.000-7213.000=-6.000 |
| | mean | 13.134-13.073=0.061 | | σ | 1.233-0.652=0.581 | | min | 12.045-12.025=0.021 | | max | 16.014-13.802=2.212 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.922-41.930=-0.008 | | σ | 0.002-0.002=0.000 | | min | 41.920-41.928=-0.008 | | max | 41.924-41.932=-0.008 |
| | mean | 7207.000-7213.000=-6.000 | | σ | 0.000 | | min | 7207.000-7213.000=-6.000 | | max | 7207.000-7213.000=-6.000 |
| | mean | 14.806-15.090=-0.285 | | σ | 0.891-0.764=0.127 | | min | 12.769-13.499=-0.730 | | max | 15.466-15.627=-0.161 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.921-41.929=-0.008 | | σ | 0.002-0.002=0.000 | | min | 41.919-41.928=-0.009 | | max | 41.924-41.932=-0.008 |
| | mean | 7207.000-7213.000=-6.000 | | σ | 0.000 | | min | 7207.000-7213.000=-6.000 | | max | 7207.000-7213.000=-6.000 |
| | mean | 13.438-14.268=-0.829 | | σ | 0.990-1.479=-0.489 | | min | 12.005-11.522=0.483 | | max | 14.300-15.612=-1.312 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.920-41.928=-0.008 | | σ | 0.002-0.002=0.000 | | min | 41.919-41.927=-0.008 | | max | 41.923-41.931=-0.008 |
| | mean | 4166.500-4171.625=-5.125 | | σ | 1902.413-1898.209=4.204 | | min | 1546.000-1554.000=-8.000 | | max | 7207.000-7213.000=-6.000 |
| | mean | 13.331-13.881=-0.549 | | σ | 1.647-1.728=-0.080 | | min | 10.782-11.252=-0.470 | | max | 15.452-15.628=-0.175 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.582-27.604=-0.022 | | σ | 0.002-0.002=0.000 | | min | 27.581-27.603=-0.022 | | max | 27.585-27.607=-0.022 |
| | mean | 4166.500-4171.625=-5.125 | | σ | 1902.413-1898.209=4.204 | | min | 1546.000-1554.000=-8.000 | | max | 7207.000-7213.000=-6.000 |
| | mean | 8.918-9.338=-0.420 | | σ | 0.303-0.339=-0.036 | | min | 8.444-8.656=-0.212 | | max | 9.273-9.682=-0.409 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.378-26.400=-0.022 | | σ | 0.002-0.002=-0.000 | | min | 26.377-26.399=-0.022 | | max | 26.381-26.403=-0.022 |
| | mean | 4166.500-4171.625=-5.125 | | σ | 1902.413-1898.209=4.204 | | min | 1546.000-1554.000=-8.000 | | max | 7207.000-7213.000=-6.000 |
| | mean | 6.966-6.883=0.082 | | σ | 0.172-0.275=-0.103 | | min | 6.628-6.452=0.176 | | max | 7.173-7.248=-0.075 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.647-25.666=-0.019 | | σ | 0.002-0.002=0.000 | | min | 25.646-25.665=-0.019 | | max | 25.650-25.668=-0.019 |
| | mean | 4282.875-4288.625=-5.750 | | σ | 1979.690-1975.521=4.169 | | min | 1546.000-1554.000=-8.000 | | max | 7207.000-7213.000=-6.000 |
| | mean | 6.019-6.161=-0.142 | | σ | 0.174-0.097=0.077 | | min | 5.782-6.027=-0.244 | | max | 6.310-6.284=0.026 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed, repeat rows=200000 | | mean | 25.642-25.661=-0.019 | | σ | 0.002-0.002=0.000 | | min | 25.640-25.659=-0.019 | | max | 25.644-25.663=-0.019 |
| | mean | 4282.875-4288.625=-5.750 | | σ | 1979.690-1975.521=4.169 | | min | 1546.000-1554.000=-8.000 | | max | 7207.000-7213.000=-6.000 |
| | mean | 5.610-5.725=-0.116 | | σ | 0.046-0.081=-0.035 | | min | 5.535-5.581=-0.046 | | max | 5.655-5.820=-0.164 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.945-25.968=-0.023 | | σ | 0.002-0.002=0.001 | | min | 25.944-25.967=-0.023 | | max | 25.949-25.971=-0.022 |
| | mean | 4282.875-4288.625=-5.750 | | σ | 1979.690-1975.521=4.169 | | min | 1546.000-1554.000=-8.000 | | max | 7207.000-7213.000=-6.000 |
| | mean | 5.650-5.802=-0.152 | | σ | 0.057-0.061=-0.004 | | min | 5.563-5.711=-0.148 | | max | 5.724-5.886=-0.162 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.945-25.968=-0.023 | | σ | 0.002-0.001=0.000 | | min | 25.944-25.967=-0.023 | | max | 25.948-25.971=-0.023 |
| | mean | 4282.875-4288.625=-5.750 | | σ | 1979.690-1975.521=4.169 | | min | 1546.000-1554.000=-8.000 | | max | 7207.000-7213.000=-6.000 |
| | mean | 5.654-5.678=-0.024 | | σ | 0.260-0.073=0.186 | | min | 5.513-5.568=-0.055 | | max | 6.291-5.760=0.531 |
|