iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4391.500 | | σ | 2048.755 | | min | 1350.000 | | max | 6795.000 |
| | mean | 12.893 | | σ | 0.260 | | min | 12.516 | | max | 13.294 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4391.500 | | σ | 2048.755 | | min | 1350.000 | | max | 6795.000 |
| | mean | 12.575 | | σ | 0.619 | | min | 11.992 | | max | 13.667 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 6795.000 | | σ | 0.000 | | min | 6795.000 | | max | 6795.000 |
| | mean | 14.297 | | σ | 1.748 | | min | 11.589 | | max | 15.960 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.933 |
| | mean | 6795.000 | | σ | 0.000 | | min | 6795.000 | | max | 6795.000 |
| | mean | 13.386 | | σ | 2.055 | | min | 10.317 | | max | 15.814 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 4391.500 | | σ | 2048.755 | | min | 1350.000 | | max | 6795.000 |
| | mean | 13.105 | | σ | 2.172 | | min | 11.086 | | max | 16.062 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605 | | σ | 0.002 | | min | 27.604 | | max | 27.608 |
| | mean | 4391.500 | | σ | 2048.755 | | min | 1350.000 | | max | 6795.000 |
| | mean | 9.700 | | σ | 1.460 | | min | 8.655 | | max | 13.026 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400 | | σ | 0.001 | | min | 26.400 | | max | 26.404 |
| | mean | 4391.500 | | σ | 2048.755 | | min | 1350.000 | | max | 6795.000 |
| | mean | 7.016 | | σ | 1.259 | | min | 6.238 | | max | 10.037 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.664 | | max | 25.669 |
| | mean | 4391.500 | | σ | 2048.755 | | min | 1350.000 | | max | 6795.000 |
| | mean | 5.978 | | σ | 0.158 | | min | 5.777 | | max | 6.272 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed, repeat rows=200000 | | mean | 25.660 | | σ | 0.002 | | min | 25.659 | | max | 25.663 |
| | mean | 4391.500 | | σ | 2048.755 | | min | 1350.000 | | max | 6795.000 |
| | mean | 5.470 | | σ | 0.223 | | min | 5.033 | | max | 5.679 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.968 | | σ | 0.002 | | min | 25.966 | | max | 25.970 |
| | mean | 4391.500 | | σ | 2048.755 | | min | 1350.000 | | max | 6795.000 |
| | mean | 5.501 | | σ | 0.240 | | min | 5.119 | | max | 5.740 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.967 | | σ | 0.001 | | min | 25.966 | | max | 25.970 |
| | mean | 4391.500 | | σ | 2048.755 | | min | 1350.000 | | max | 6795.000 |
| | mean | 5.496 | | σ | 0.293 | | min | 4.965 | | max | 5.794 |
|