iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4286.125 | | σ | 1981.727 | | min | 1548.000 | | max | 7204.000 |
| | mean | 56.705 | | σ | 123.798 | | min | 12.645 | | max | 363.090 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4286.125 | | σ | 1981.727 | | min | 1548.000 | | max | 7204.000 |
| | mean | 12.564 | | σ | 0.752 | | min | 11.825 | | max | 13.628 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7204.000 | | σ | 0.000 | | min | 7204.000 | | max | 7204.000 |
| | mean | 15.061 | | σ | 1.400 | | min | 12.126 | | max | 16.398 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7204.000 | | σ | 0.000 | | min | 7204.000 | | max | 7204.000 |
| | mean | 13.545 | | σ | 1.198 | | min | 11.673 | | max | 14.902 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4169.750 | | σ | 1903.992 | | min | 1548.000 | | max | 7204.000 |
| | mean | 13.913 | | σ | 1.622 | | min | 11.518 | | max | 15.246 |
|
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 | 4169.750 | | σ | 1903.992 | | min | 1548.000 | | max | 7204.000 |
| | mean | 9.143 | | σ | 0.272 | | min | 8.724 | | max | 9.473 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.401 | | σ | 0.002 | | min | 26.399 | | max | 26.403 |
| | mean | 4169.750 | | σ | 1903.992 | | min | 1548.000 | | max | 7204.000 |
| | mean | 6.837 | | σ | 0.388 | | min | 6.240 | | max | 7.264 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.664 | | max | 25.670 |
| | mean | 4286.125 | | σ | 1981.727 | | min | 1548.000 | | max | 7204.000 |
| | mean | 6.022 | | σ | 0.241 | | min | 5.744 | | max | 6.554 |
|
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 | | σ | 1981.727 | | min | 1548.000 | | max | 7204.000 |
| | mean | 5.646 | | σ | 0.137 | | min | 5.430 | | max | 5.911 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.970 | | σ | 0.002 | | min | 25.967 | | max | 25.972 |
| | mean | 4286.125 | | σ | 1981.727 | | min | 1548.000 | | max | 7204.000 |
| | mean | 5.743 | | σ | 0.241 | | min | 5.279 | | max | 6.074 |
|
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 | | σ | 1981.727 | | min | 1548.000 | | max | 7204.000 |
| | mean | 5.541 | | σ | 0.170 | | min | 5.207 | | max | 5.766 |
|