iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4289.500 | | σ | 1982.961 | | min | 1550.000 | | max | 7213.000 |
| | mean | 68.592 | | σ | 157.728 | | min | 12.522 | | max | 458.949 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4289.500 | | σ | 1982.961 | | min | 1550.000 | | max | 7213.000 |
| | mean | 12.993 | | σ | 0.580 | | min | 12.034 | | max | 13.548 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7213.000 | | σ | 0.000 | | min | 7213.000 | | max | 7213.000 |
| | mean | 15.026 | | σ | 0.635 | | min | 13.580 | | max | 15.587 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7213.000 | | σ | 0.000 | | min | 7213.000 | | max | 7213.000 |
| | mean | 12.864 | | σ | 1.208 | | min | 11.397 | | max | 14.789 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4173.125 | | σ | 1905.372 | | min | 1550.000 | | max | 7213.000 |
| | mean | 14.045 | | σ | 1.522 | | min | 11.062 | | max | 15.389 |
|
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 | 4173.125 | | σ | 1905.372 | | min | 1550.000 | | max | 7213.000 |
| | mean | 8.947 | | σ | 0.230 | | min | 8.564 | | max | 9.306 |
|
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 | 4173.125 | | σ | 1905.372 | | min | 1550.000 | | max | 7213.000 |
| | mean | 6.814 | | σ | 0.303 | | min | 6.137 | | max | 7.091 |
|
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 | 4289.500 | | σ | 1982.961 | | min | 1550.000 | | max | 7213.000 |
| | mean | 6.071 | | σ | 0.078 | | min | 5.958 | | max | 6.193 |
|
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 | 4289.500 | | σ | 1982.961 | | min | 1550.000 | | max | 7213.000 |
| | mean | 5.604 | | σ | 0.120 | | min | 5.401 | | max | 5.770 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969 | | σ | 0.003 | | min | 25.967 | | max | 25.975 |
| | mean | 4289.500 | | σ | 1982.961 | | min | 1550.000 | | max | 7213.000 |
| | mean | 5.768 | | σ | 0.078 | | min | 5.626 | | max | 5.865 |
|
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 | 4289.500 | | σ | 1982.961 | | min | 1550.000 | | max | 7213.000 |
| | mean | 5.616 | | σ | 0.147 | | min | 5.409 | | max | 5.843 |
|