iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.619 |
| | mean | 4286.125 | | σ | 1980.215 | | min | 1551.000 | | max | 7208.000 |
| | mean | 76.868 | | σ | 181.120 | | min | 12.586 | | max | 525.116 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4286.125 | | σ | 1980.215 | | min | 1551.000 | | max | 7208.000 |
| | mean | 14.045 | | σ | 2.901 | | min | 11.956 | | max | 21.043 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.933 |
| | mean | 7208.000 | | σ | 0.000 | | min | 7208.000 | | max | 7208.000 |
| | mean | 15.040 | | σ | 0.953 | | min | 13.171 | | max | 15.752 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7208.000 | | σ | 0.000 | | min | 7208.000 | | max | 7208.000 |
| | mean | 14.163 | | σ | 1.054 | | min | 12.413 | | max | 15.790 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4170.625 | | σ | 1903.218 | | min | 1551.000 | | max | 7208.000 |
| | mean | 13.915 | | σ | 1.750 | | min | 11.501 | | max | 15.536 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605 | | σ | 0.002 | | min | 27.603 | | max | 27.607 |
| | mean | 4170.625 | | σ | 1903.218 | | min | 1551.000 | | max | 7208.000 |
| | mean | 8.974 | | σ | 0.238 | | min | 8.568 | | max | 9.229 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400 | | σ | 0.001 | | min | 26.399 | | max | 26.403 |
| | mean | 4170.625 | | σ | 1903.218 | | min | 1551.000 | | max | 7208.000 |
| | mean | 7.013 | | σ | 0.161 | | min | 6.837 | | max | 7.312 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.664 | | max | 25.668 |
| | mean | 4286.125 | | σ | 1980.215 | | min | 1551.000 | | max | 7208.000 |
| | mean | 6.248 | | σ | 0.554 | | min | 5.822 | | max | 7.546 |
|
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 | 4286.125 | | σ | 1980.215 | | min | 1551.000 | | max | 7208.000 |
| | mean | 5.821 | | σ | 0.538 | | min | 5.466 | | max | 7.138 |
|
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 | 4286.125 | | σ | 1980.215 | | min | 1551.000 | | max | 7208.000 |
| | mean | 5.929 | | σ | 0.558 | | min | 5.694 | | 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 | 4286.125 | | σ | 1980.215 | | min | 1551.000 | | max | 7208.000 |
| | mean | 5.791 | | σ | 0.545 | | min | 5.423 | | max | 7.122 |
|