iterations=10 operation_display=column_set() on indexed rows=200000 | | mean | 70.650 | | σ | 0.002 | | min | 70.647 | | max | 70.652 |
| | mean | 8706.000 | | σ | 0.000 | | min | 8706.000 | | max | 8706.000 |
| | mean | 150.130 | | σ | 9.439 | | min | 126.369 | | max | 158.266 |
|
iterations=10 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 70.649 | | σ | 0.002 | | min | 70.647 | | max | 70.651 |
| | mean | 8706.000 | | σ | 0.000 | | min | 8706.000 | | max | 8706.000 |
| | mean | 148.823 | | σ | 10.128 | | min | 122.855 | | max | 156.796 |
|
iterations=10 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929 | | σ | 0.000 | | min | 41.928 | | max | 41.929 |
| | mean | 8706.000 | | σ | 0.000 | | min | 8706.000 | | max | 8706.000 |
| | mean | 14.005 | | σ | 1.984 | | min | 11.093 | | max | 15.606 |
|
iterations=10 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.931 | | σ | 0.003 | | min | 41.928 | | max | 41.936 |
| | mean | 8706.000 | | σ | 0.000 | | min | 8706.000 | | max | 8706.000 |
| | mean | 12.743 | | σ | 1.585 | | min | 10.480 | | max | 14.760 |
|
iterations=10 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 5028.000 | | σ | 2354.218 | | min | 1339.000 | | max | 8706.000 |
| | mean | 14.261 | | σ | 1.681 | | min | 11.200 | | max | 15.822 |
|
iterations=10 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.606 | | σ | 0.002 | | min | 27.604 | | max | 27.608 |
| | mean | 5028.000 | | σ | 2354.218 | | min | 1339.000 | | max | 8706.000 |
| | mean | 9.543 | | σ | 0.582 | | min | 8.303 | | max | 10.355 |
|
iterations=10 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.401 | | σ | 0.002 | | min | 26.400 | | max | 26.404 |
| | mean | 5028.000 | | σ | 2354.218 | | min | 1339.000 | | max | 8706.000 |
| | mean | 6.997 | | σ | 0.424 | | min | 6.348 | | max | 7.483 |
|
iterations=10 operation_display=vertical_lookup_list() on indexed, repeat rows=200000 | | mean | 41.729 | | σ | 0.002 | | min | 41.727 | | max | 41.731 |
| | mean | 8706.000 | | σ | 0.000 | | min | 8706.000 | | max | 8706.000 |
| | mean | 65.519 | | σ | 2.267 | | min | 60.694 | | max | 68.798 |
|
iterations=10 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.665 | | σ | 0.002 | | min | 25.664 | | max | 25.669 |
| | mean | 5028.000 | | σ | 2354.218 | | min | 1339.000 | | max | 8706.000 |
| | mean | 6.144 | | σ | 0.068 | | min | 6.005 | | max | 6.223 |
|
iterations=10 operation_display=vertical_lookup_row_list() on 2 indexed, repeat rows=200000 | | mean | 25.660 | | σ | 0.002 | | min | 25.659 | | max | 25.663 |
| | mean | 5028.000 | | σ | 2354.218 | | min | 1339.000 | | max | 8706.000 |
| | mean | 5.521 | | σ | 0.299 | | min | 4.985 | | max | 5.864 |
|
iterations=10 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.968 | | σ | 0.003 | | min | 25.966 | | max | 25.974 |
| | mean | 5028.000 | | σ | 2354.218 | | min | 1339.000 | | max | 8706.000 |
| | mean | 5.388 | | σ | 0.254 | | min | 5.076 | | max | 5.706 |
|
iterations=10 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.967 | | σ | 0.002 | | min | 25.966 | | max | 25.970 |
| | mean | 5028.000 | | σ | 2354.218 | | min | 1339.000 | | max | 8706.000 |
| | mean | 5.373 | | σ | 0.226 | | min | 5.035 | | max | 5.645 |
|