iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617-36.617=0.000 | | σ | 0.002-0.002=0.000 | | min | 36.615 | | max | 36.620-36.619=0.000 |
| | mean | 4164.000-4166.500=-2.500 | | σ | 1895.945-1898.389=-2.444 | | min | 1548.000-1550.000=-2.000 | | max | 7196.000-7200.000=-4.000 |
| | mean | 12.673-12.635=0.038 | | σ | 0.308-0.322=-0.014 | | min | 12.175-12.253=-0.079 | | max | 13.224-13.133=0.091 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617-36.618=-0.000 | | σ | 0.002-0.002=-0.000 | | min | 36.616-36.616=0.000 | | max | 36.620-36.620=-0.000 |
| | mean | 4283.875-4287.000=-3.125 | | σ | 1975.396-1978.404=-3.008 | | min | 1548.000-1550.000=-2.000 | | max | 7196.000-7200.000=-4.000 |
| | mean | 86.304-101.189=-14.885 | | σ | 206.870-250.322=-43.452 | | min | 12.623-11.696=0.928 | | max | 598.280-720.702=-122.422 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929-41.930=-0.001 | | σ | 0.002-0.002=-0.000 | | min | 41.928-41.928=0.000 | | max | 41.932-41.933=-0.001 |
| | mean | 7196.000-7200.000=-4.000 | | σ | 0.000 | | min | 7196.000-7200.000=-4.000 | | max | 7196.000-7200.000=-4.000 |
| | mean | 14.863-14.932=-0.069 | | σ | 1.219-1.314=-0.096 | | min | 12.255-12.071=0.184 | | max | 16.241-15.949=0.291 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930-41.930=0.000 | | σ | 0.002-0.002=-0.000 | | min | 41.928-41.928=0.000 | | max | 41.932-41.932=-0.000 |
| | mean | 7196.000-7200.000=-4.000 | | σ | 0.000 | | min | 7196.000-7200.000=-4.000 | | max | 7196.000-7200.000=-4.000 |
| | mean | 13.607-13.452=0.155 | | σ | 1.162-1.210=-0.048 | | min | 11.791-11.401=0.390 | | max | 15.170-14.712=0.458 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929-41.928=0.000 | | σ | 0.002-0.002=0.000 | | min | 41.927-41.927=-0.000 | | max | 41.931-41.931=-0.000 |
| | mean | 4164.000-4166.500=-2.500 | | σ | 1895.945-1898.389=-2.444 | | min | 1548.000-1550.000=-2.000 | | max | 7196.000-7200.000=-4.000 |
| | mean | 13.616-13.832=-0.216 | | σ | 1.613-1.522=0.091 | | min | 11.002-11.610=-0.608 | | max | 15.664-15.257=0.407 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.604-27.604=0.000 | | σ | 0.002-0.002=0.000 | | min | 27.603-27.603=0.000 | | max | 27.607-27.607=0.000 |
| | mean | 4164.000-4166.500=-2.500 | | σ | 1895.945-1898.389=-2.444 | | min | 1548.000-1550.000=-2.000 | | max | 7196.000-7200.000=-4.000 |
| | mean | 9.199-9.109=0.090 | | σ | 0.404-0.512=-0.109 | | min | 8.558-8.344=0.214 | | max | 9.728-9.647=0.081 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400-26.400=-0.000 | | σ | 0.002-0.002=-0.000 | | min | 26.399-26.399=-0.000 | | max | 26.403-26.403=-0.000 |
| | mean | 4164.000-4166.500=-2.500 | | σ | 1895.945-1898.389=-2.444 | | min | 1548.000-1550.000=-2.000 | | max | 7196.000-7200.000=-4.000 |
| | mean | 6.766-6.611=0.155 | | σ | 0.333-0.399=-0.066 | | min | 6.235-6.055=0.180 | | max | 7.231-7.191=0.040 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.667-25.666=0.000 | | σ | 0.002-0.002=0.000 | | min | 25.665-25.664=0.000 | | max | 25.670-25.668=0.001 |
| | mean | 4283.875-4287.000=-3.125 | | σ | 1975.396-1978.404=-3.008 | | min | 1548.000-1550.000=-2.000 | | max | 7196.000-7200.000=-4.000 |
| | mean | 6.326-6.241=0.086 | | σ | 0.836-0.640=0.196 | | min | 5.848-5.829=0.019 | | max | 8.375-7.797=0.578 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed, repeat rows=200000 | | mean | 25.661-25.661=-0.000 | | σ | 0.002-0.002=0.000 | | min | 25.659 | | max | 25.663 |
| | mean | 4283.875-4287.000=-3.125 | | σ | 1975.396-1978.404=-3.008 | | min | 1548.000-1550.000=-2.000 | | max | 7196.000-7200.000=-4.000 |
| | mean | 5.787-5.924=-0.137 | | σ | 0.575-0.713=-0.138 | | min | 5.358-5.138=0.220 | | max | 7.184-7.491=-0.307 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969-25.969=-0.000 | | σ | 0.002-0.003=-0.001 | | min | 25.967 | | max | 25.971-25.975=-0.004 |
| | mean | 4283.875-4287.000=-3.125 | | σ | 1975.396-1978.404=-3.008 | | min | 1548.000-1550.000=-2.000 | | max | 7196.000-7200.000=-4.000 |
| | mean | 5.879-5.900=-0.021 | | σ | 0.538-0.653=-0.116 | | min | 5.474-5.144=0.330 | | max | 7.186-7.410=-0.225 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.968-25.968=0.000 | | σ | 0.001-0.001=-0.000 | | min | 25.967-25.967=-0.000 | | max | 25.971 |
| | mean | 4283.875-4287.000=-3.125 | | σ | 1975.396-1978.404=-3.008 | | min | 1548.000-1550.000=-2.000 | | max | 7196.000-7200.000=-4.000 |
| | mean | 5.737-5.863=-0.125 | | σ | 0.550-0.681=-0.131 | | min | 5.368-5.119=0.249 | | max | 7.082-7.390=-0.308 |
|