iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4284.625 | | σ | 1978.234 | | min | 1551.000 | | max | 7208.000 |
| | mean | 83.327 | | σ | 199.084 | | min | 12.611 | | max | 576.035 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4284.625 | | σ | 1978.234 | | min | 1551.000 | | max | 7208.000 |
| | mean | 13.908 | | σ | 3.127 | | min | 11.928 | | max | 21.455 |
|
iterations=8 operation_display=table_records(), no indexes 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.908 | | σ | 1.034 | | min | 12.663 | | max | 15.875 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7208.000 | | σ | 0.000 | | min | 7208.000 | | max | 7208.000 |
| | mean | 14.109 | | σ | 0.980 | | min | 12.044 | | max | 14.845 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4168.000 | | σ | 1900.842 | | min | 1551.000 | | max | 7208.000 |
| | mean | 13.554 | | σ | 1.479 | | min | 11.026 | | max | 15.333 |
|
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 | 4168.000 | | σ | 1900.842 | | min | 1551.000 | | max | 7208.000 |
| | mean | 9.265 | | σ | 0.385 | | min | 8.688 | | max | 9.765 |
|
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 | 4168.000 | | σ | 1900.842 | | min | 1551.000 | | max | 7208.000 |
| | mean | 7.205 | | σ | 0.343 | | min | 6.498 | | max | 7.510 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.667 | | σ | 0.002 | | min | 25.664 | | max | 25.670 |
| | mean | 4284.625 | | σ | 1978.234 | | min | 1551.000 | | max | 7208.000 |
| | mean | 6.327 | | σ | 0.672 | | min | 5.911 | | max | 7.977 |
|
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.625 | | σ | 1978.234 | | min | 1551.000 | | max | 7208.000 |
| | mean | 5.921 | | σ | 0.579 | | min | 5.608 | | max | 7.335 |
|
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.625 | | σ | 1978.234 | | min | 1551.000 | | max | 7208.000 |
| | mean | 5.940 | | σ | 0.604 | | min | 5.662 | | max | 7.427 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.968 | | σ | 0.001 | | min | 25.967 | | max | 25.971 |
| | mean | 4284.625 | | σ | 1978.234 | | min | 1551.000 | | max | 7208.000 |
| | mean | 5.831 | | σ | 0.602 | | min | 5.486 | | max | 7.269 |
|