iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.619 |
| | mean | 4284.875 | | σ | 1975.464 | | min | 1550.000 | | max | 7211.000 |
| | mean | 72.618 | | σ | 169.170 | | min | 12.512 | | max | 491.292 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4284.875 | | σ | 1975.464 | | min | 1550.000 | | max | 7211.000 |
| | mean | 14.035 | | σ | 2.992 | | min | 11.966 | | max | 21.265 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.933 |
| | mean | 7211.000 | | σ | 0.000 | | min | 7211.000 | | max | 7211.000 |
| | mean | 15.118 | | σ | 0.859 | | min | 13.644 | | max | 15.848 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7211.000 | | σ | 0.000 | | min | 7211.000 | | max | 7211.000 |
| | mean | 13.488 | | σ | 1.520 | | min | 11.159 | | max | 15.382 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.003 | | min | 41.927 | | max | 41.935 |
| | mean | 4168.375 | | σ | 1898.522 | | min | 1550.000 | | max | 7211.000 |
| | mean | 13.556 | | σ | 1.751 | | min | 11.088 | | max | 15.340 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605 | | σ | 0.003 | | min | 27.603 | | max | 27.611 |
| | mean | 4168.375 | | σ | 1898.522 | | min | 1550.000 | | max | 7211.000 |
| | mean | 9.217 | | σ | 0.424 | | min | 8.646 | | max | 9.796 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400 | | σ | 0.002 | | min | 26.399 | | max | 26.403 |
| | mean | 4168.375 | | σ | 1898.522 | | min | 1550.000 | | max | 7211.000 |
| | mean | 6.644 | | σ | 0.316 | | min | 6.058 | | max | 6.993 |
|
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 | 4284.875 | | σ | 1975.464 | | min | 1550.000 | | max | 7211.000 |
| | mean | 6.305 | | σ | 0.573 | | min | 5.944 | | max | 7.647 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed, repeat rows=200000 | | mean | 25.661 | | σ | 0.002 | | min | 25.659 | | max | 25.663 |
| | mean | 4284.875 | | σ | 1975.464 | | min | 1550.000 | | max | 7211.000 |
| | mean | 5.801 | | σ | 0.582 | | min | 5.421 | | max | 7.225 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4284.875 | | σ | 1975.464 | | min | 1550.000 | | max | 7211.000 |
| | mean | 5.868 | | σ | 0.603 | | min | 5.304 | | max | 7.306 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.968 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4284.875 | | σ | 1975.464 | | min | 1550.000 | | max | 7211.000 |
| | mean | 5.729 | | σ | 0.612 | | min | 5.156 | | max | 7.197 |
|