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 |
| | mean | 4276.375-4168.375=108.000 | | σ | 1964.980-1900.743=64.237 | | min | 1550.000-1547.000=3.000 | | max | 7167.000-7201.000=-34.000 |
| | mean | 12.756-12.768=-0.013 | | σ | 0.272-0.220=0.052 | | min | 12.354-12.487=-0.133 | | max | 13.224-13.159=0.065 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618-36.617=0.000 | | σ | 0.002-0.002=-0.000 | | min | 36.616-36.616=0.000 | | max | 36.620-36.621=-0.001 |
| | mean | 4276.375-4288.750=-12.375 | | σ | 1964.980-1980.768=-15.788 | | min | 1550.000-1547.000=3.000 | | max | 7167.000-7201.000=-34.000 |
| | mean | 13.239-97.152=-83.913 | | σ | 0.393-238.746=-238.352 | | min | 12.412-11.829=0.583 | | max | 13.600-688.014=-674.414 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930-41.930=0.000 | | σ | 0.002-0.002=0.000 | | min | 41.928-41.928=-0.000 | | max | 41.933-41.932=0.000 |
| | mean | 7167.000-7201.000=-34.000 | | σ | 0.000 | | min | 7167.000-7201.000=-34.000 | | max | 7167.000-7201.000=-34.000 |
| | mean | 14.927-14.826=0.102 | | σ | 0.676-1.171=-0.495 | | min | 13.402-12.193=1.209 | | max | 15.330-15.748=-0.418 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929-41.929=0.000 | | σ | 0.002-0.002=0.000 | | min | 41.928-41.928=0.000 | | max | 41.932-41.932=0.000 |
| | mean | 7167.000-7201.000=-34.000 | | σ | 0.000 | | min | 7167.000-7201.000=-34.000 | | max | 7167.000-7201.000=-34.000 |
| | mean | 14.123-13.765=0.358 | | σ | 0.823-1.393=-0.570 | | min | 12.775-11.817=0.958 | | max | 15.102-15.617=-0.515 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929-41.929=0.000 | | σ | 0.002-0.002=-0.000 | | min | 41.927-41.927=0.000 | | max | 41.932-41.931=0.000 |
| | mean | 4159.875-4168.375=-8.500 | | σ | 1887.434-1900.743=-13.309 | | min | 1550.000-1547.000=3.000 | | max | 7167.000-7201.000=-34.000 |
| | mean | 13.686-13.620=0.066 | | σ | 1.678-1.744=-0.066 | | min | 11.430-10.918=0.512 | | max | 15.654-15.551=0.103 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605-27.605=0.000 | | σ | 0.002-0.003=-0.001 | | min | 27.603-27.603=-0.000 | | max | 27.607-27.611=-0.004 |
| | mean | 4159.875-4168.375=-8.500 | | σ | 1887.434-1900.743=-13.309 | | min | 1550.000-1547.000=3.000 | | max | 7167.000-7201.000=-34.000 |
| | mean | 9.044-9.342=-0.298 | | σ | 0.376-0.288=0.089 | | min | 8.463-8.952=-0.489 | | max | 9.784-9.749=0.035 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400-26.400=-0.000 | | σ | 0.001-0.002=-0.000 | | min | 26.399-26.399=0.000 | | max | 26.403-26.403=0.000 |
| | mean | 4159.875-4168.375=-8.500 | | σ | 1887.434-1900.743=-13.309 | | min | 1550.000-1547.000=3.000 | | max | 7167.000-7201.000=-34.000 |
| | mean | 6.792-6.805=-0.014 | | σ | 0.207-0.262=-0.054 | | min | 6.432-6.411=0.021 | | max | 6.992-7.144=-0.151 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666-25.666=0.000 | | σ | 0.002-0.002=-0.000 | | min | 25.664-25.664=0.000 | | max | 25.669-25.669=-0.000 |
| | mean | 4276.375-4288.750=-12.375 | | σ | 1964.980-1980.768=-15.788 | | min | 1550.000-1547.000=3.000 | | max | 7167.000-7201.000=-34.000 |
| | mean | 5.993-6.357=-0.364 | | σ | 0.170-1.029=-0.859 | | min | 5.788-5.723=0.065 | | max | 6.168-8.860=-2.692 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed, repeat rows=200000 | | mean | 25.661-25.661=0.001 | | σ | 0.002-0.002=0.000 | | min | 25.659-25.659=0.000 | | max | 25.663-25.663=0.000 |
| | mean | 4276.375-4288.750=-12.375 | | σ | 1964.980-1980.768=-15.788 | | min | 1550.000-1547.000=3.000 | | max | 7167.000-7201.000=-34.000 |
| | mean | 5.502-5.916=-0.415 | | σ | 0.164-1.076=-0.913 | | min | 5.155-5.205=-0.050 | | max | 5.726-8.552=-2.826 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969-25.969=0.000 | | σ | 0.003-0.002=0.001 | | min | 25.967 | | max | 25.975-25.971=0.004 |
| | mean | 4276.375-4288.750=-12.375 | | σ | 1964.980-1980.768=-15.788 | | min | 1550.000-1547.000=3.000 | | max | 7167.000-7201.000=-34.000 |
| | mean | 5.603-5.937=-0.334 | | σ | 0.262-1.167=-0.905 | | min | 5.190-5.216=-0.026 | | max | 6.038-8.788=-2.750 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.968-25.968=-0.000 | | σ | 0.002-0.002=-0.000 | | min | 25.967 | | max | 25.971-25.971=-0.000 |
| | mean | 4276.375-4288.750=-12.375 | | σ | 1964.980-1980.768=-15.788 | | min | 1550.000-1547.000=3.000 | | max | 7167.000-7201.000=-34.000 |
| | mean | 5.522-5.771=-0.249 | | σ | 0.350-1.042=-0.693 | | min | 5.112-5.007=0.105 | | max | 6.224-8.275=-2.050 |
|