iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617-36.617=0.000 | | σ | 0.002-0.002=-0.000 | | min | 36.615-36.615=-0.000 | | max | 36.620-36.620=-0.001 |
| | mean | 4284.875-4289.750=-4.875 | | σ | 1976.157-1981.976=-5.820 | | min | 1551.000-1554.000=-3.000 | | max | 7206.000-7211.000=-5.000 |
| | mean | 71.472-110.058=-38.586 | | σ | 166.443-275.426=-108.983 | | min | 12.300-12.516=-0.217 | | max | 483.397-791.702=-308.305 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618-36.617=0.000 | | σ | 0.002-0.002=0.000 | | min | 36.616-36.616=-0.000 | | max | 36.620-36.620=0.000 |
| | mean | 4284.875-4289.750=-4.875 | | σ | 1976.157-1981.976=-5.820 | | min | 1551.000-1554.000=-3.000 | | max | 7206.000-7211.000=-5.000 |
| | mean | 13.235-13.958=-0.724 | | σ | 1.306-2.788=-1.481 | | min | 11.851-12.092=-0.241 | | max | 16.175-20.793=-4.618 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930-41.930=0.001 | | σ | 0.002-0.002=0.000 | | min | 41.928-41.928=-0.000 | | max | 41.932-41.933=-0.000 |
| | mean | 7206.000-7211.000=-5.000 | | σ | 0.000 | | min | 7206.000-7211.000=-5.000 | | max | 7206.000-7211.000=-5.000 |
| | mean | 14.816-15.005=-0.189 | | σ | 1.200-0.883=0.317 | | min | 12.178-13.016=-0.838 | | max | 15.594-15.715=-0.120 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929-41.930=-0.001 | | σ | 0.002-0.002=-0.000 | | min | 41.928-41.928=-0.000 | | max | 41.932 |
| | mean | 7206.000-7211.000=-5.000 | | σ | 0.000 | | min | 7206.000-7211.000=-5.000 | | max | 7206.000-7211.000=-5.000 |
| | mean | 13.460-13.579=-0.118 | | σ | 1.392-0.896=0.495 | | min | 11.717-11.872=-0.155 | | max | 15.349-14.684=0.665 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929-41.929=-0.001 | | σ | 0.002-0.002=0.000 | | min | 41.927-41.927=-0.000 | | max | 41.931-41.931=-0.000 |
| | mean | 4168.125-4172.875=-4.750 | | σ | 1898.854-1904.076=-5.222 | | min | 1551.000-1554.000=-3.000 | | max | 7206.000-7211.000=-5.000 |
| | mean | 13.645-13.978=-0.333 | | σ | 1.758-1.674=0.084 | | min | 11.195-11.195=0.000 | | max | 15.401-15.415=-0.014 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605-27.605=-0.000 | | σ | 0.002-0.002=0.000 | | min | 27.603-27.603=-0.000 | | max | 27.607-27.607=0.000 |
| | mean | 4168.125-4172.875=-4.750 | | σ | 1898.854-1904.076=-5.222 | | min | 1551.000-1554.000=-3.000 | | max | 7206.000-7211.000=-5.000 |
| | mean | 9.300-9.108=0.192 | | σ | 0.326-0.383=-0.057 | | min | 8.896-8.561=0.335 | | max | 9.700-9.669=0.030 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400-26.400=-0.000 | | σ | 0.001-0.002=-0.000 | | min | 26.399 | | max | 26.403 |
| | mean | 4168.125-4172.875=-4.750 | | σ | 1898.854-1904.076=-5.222 | | min | 1551.000-1554.000=-3.000 | | max | 7206.000-7211.000=-5.000 |
| | mean | 6.608-6.876=-0.268 | | σ | 0.315-0.185=0.130 | | min | 6.067-6.510=-0.443 | | max | 7.104-7.107=-0.002 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666-25.666=0.000 | | σ | 0.002-0.002=-0.000 | | min | 25.664 | | max | 25.668-25.670=-0.001 |
| | mean | 4284.875-4289.750=-4.875 | | σ | 1976.157-1981.976=-5.820 | | min | 1551.000-1554.000=-3.000 | | max | 7206.000-7211.000=-5.000 |
| | mean | 6.050-6.206=-0.156 | | σ | 0.169-0.531=-0.362 | | min | 5.704-5.835=-0.131 | | max | 6.245-7.501=-1.256 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed, repeat rows=200000 | | mean | 25.661-25.661=0.001 | | σ | 0.002-0.002=0.000 | | min | 25.659 | | max | 25.663-25.663=0.000 |
| | mean | 4284.875-4289.750=-4.875 | | σ | 1976.157-1981.976=-5.820 | | min | 1551.000-1554.000=-3.000 | | max | 7206.000-7211.000=-5.000 |
| | mean | 5.593-5.877=-0.285 | | σ | 0.246-0.606=-0.360 | | min | 5.228-5.565=-0.337 | | max | 5.817-7.359=-1.543 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969-25.969=-0.001 | | σ | 0.002-0.002=-0.000 | | min | 25.967-25.967=0.000 | | max | 25.971-25.972=-0.001 |
| | mean | 4284.875-4289.750=-4.875 | | σ | 1976.157-1981.976=-5.820 | | min | 1551.000-1554.000=-3.000 | | max | 7206.000-7211.000=-5.000 |
| | mean | 5.713-5.930=-0.217 | | σ | 0.155-0.575=-0.419 | | min | 5.497-5.615=-0.119 | | max | 5.934-7.301=-1.367 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.968-25.968=-0.000 | | σ | 0.002-0.002=0.000 | | min | 25.967-25.967=-0.000 | | max | 25.971 |
| | mean | 4284.875-4289.750=-4.875 | | σ | 1976.157-1981.976=-5.820 | | min | 1551.000-1554.000=-3.000 | | max | 7206.000-7211.000=-5.000 |
| | mean | 5.550-5.920=-0.370 | | σ | 0.205-0.615=-0.409 | | min | 5.141-5.531=-0.390 | | max | 5.722-7.265=-1.543 |
|