iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4287.750 | | σ | 1980.500 | | min | 1552.000 | | max | 7216.000 |
| | mean | 78.806 | | σ | 186.924 | | min | 12.524 | | max | 541.418 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4287.750 | | σ | 1980.500 | | min | 1552.000 | | max | 7216.000 |
| | mean | 13.191 | | σ | 1.268 | | min | 11.820 | | max | 15.935 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7216.000 | | σ | 0.000 | | min | 7216.000 | | max | 7216.000 |
| | mean | 14.976 | | σ | 0.659 | | min | 13.401 | | max | 15.423 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7216.000 | | σ | 0.000 | | min | 7216.000 | | max | 7216.000 |
| | mean | 14.062 | | σ | 0.943 | | min | 12.508 | | max | 15.729 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.928 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4171.125 | | σ | 1903.138 | | min | 1552.000 | | max | 7216.000 |
| | mean | 13.606 | | σ | 1.939 | | min | 10.761 | | max | 15.591 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.604 | | σ | 0.002 | | min | 27.603 | | max | 27.607 |
| | mean | 4171.125 | | σ | 1903.138 | | min | 1552.000 | | max | 7216.000 |
| | mean | 9.229 | | σ | 0.382 | | min | 8.444 | | max | 9.652 |
|
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 | 4171.125 | | σ | 1903.138 | | min | 1552.000 | | max | 7216.000 |
| | mean | 6.955 | | σ | 0.230 | | min | 6.472 | | max | 7.146 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.665 | | max | 25.668 |
| | mean | 4287.750 | | σ | 1980.500 | | min | 1552.000 | | max | 7216.000 |
| | mean | 6.126 | | σ | 0.128 | | min | 6.037 | | max | 6.340 |
|
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 | 4287.750 | | σ | 1980.500 | | min | 1552.000 | | max | 7216.000 |
| | mean | 5.671 | | σ | 0.141 | | min | 5.590 | | max | 6.011 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.968 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4287.750 | | σ | 1980.500 | | min | 1552.000 | | max | 7216.000 |
| | mean | 5.674 | | σ | 0.189 | | min | 5.281 | | max | 5.890 |
|
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 | 4287.750 | | σ | 1980.500 | | min | 1552.000 | | max | 7216.000 |
| | mean | 5.477 | | σ | 0.195 | | min | 5.030 | | max | 5.652 |
|