iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.619 |
| | mean | 4168.500 | | σ | 1899.061 | | min | 1551.000 | | max | 7202.000 |
| | mean | 12.855 | | σ | 0.244 | | min | 12.537 | | max | 13.238 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.621 |
| | mean | 4288.750 | | σ | 1978.964 | | min | 1551.000 | | max | 7202.000 |
| | mean | 113.762 | | σ | 284.029 | | min | 13.146 | | max | 816.698 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7202.000 | | σ | 0.000 | | min | 7202.000 | | max | 7202.000 |
| | mean | 14.813 | | σ | 1.293 | | min | 12.072 | | max | 15.736 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7202.000 | | σ | 0.000 | | min | 7202.000 | | max | 7202.000 |
| | mean | 13.694 | | σ | 1.245 | | min | 11.611 | | max | 14.500 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4168.500 | | σ | 1899.061 | | min | 1551.000 | | max | 7202.000 |
| | mean | 13.317 | | σ | 1.179 | | min | 10.936 | | max | 14.900 |
|
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.500 | | σ | 1899.061 | | min | 1551.000 | | max | 7202.000 |
| | mean | 9.140 | | σ | 0.324 | | min | 8.564 | | max | 9.472 |
|
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.500 | | σ | 1899.061 | | min | 1551.000 | | max | 7202.000 |
| | mean | 7.152 | | σ | 0.158 | | min | 6.899 | | max | 7.351 |
|
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 | 4288.750 | | σ | 1978.964 | | min | 1551.000 | | max | 7202.000 |
| | mean | 6.225 | | σ | 0.549 | | min | 5.810 | | max | 7.496 |
|
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 | 4288.750 | | σ | 1978.964 | | min | 1551.000 | | max | 7202.000 |
| | mean | 5.813 | | σ | 0.604 | | min | 5.462 | | max | 7.296 |
|
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 | 4288.750 | | σ | 1978.964 | | min | 1551.000 | | max | 7202.000 |
| | mean | 5.895 | | σ | 0.582 | | min | 5.599 | | max | 7.316 |
|
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 | 4288.750 | | σ | 1978.964 | | min | 1551.000 | | max | 7202.000 |
| | mean | 5.787 | | σ | 0.554 | | min | 5.553 | | max | 7.156 |
|