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-36.615=-0.000 | | max | 36.620-36.620=-0.001 |
| | mean | 4168.375-4285.000=-116.625 | | σ | 1900.743-1982.059=-81.316 | | min | 1547.000-1549.000=-2.000 | | max | 7201.000-7208.000=-7.000 |
| | mean | 12.768-103.650=-90.881 | | σ | 0.220-257.057=-256.837 | | min | 12.487-12.532=-0.045 | | max | 13.159-739.832=-726.673 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617-36.617=0.001 | | σ | 0.002-0.002=0.001 | | min | 36.616-36.616=-0.000 | | max | 36.621-36.619=0.001 |
| | mean | 4288.750-4285.000=3.750 | | σ | 1980.768-1982.059=-1.290 | | min | 1547.000-1549.000=-2.000 | | max | 7201.000-7208.000=-7.000 |
| | mean | 97.152-14.207=82.945 | | σ | 238.746-3.049=235.696 | | min | 11.829-12.158=-0.328 | | max | 688.014-21.680=666.334 |
|
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.932-41.932=0.001 |
| | mean | 7201.000-7208.000=-7.000 | | σ | 0.000 | | min | 7201.000-7208.000=-7.000 | | max | 7201.000-7208.000=-7.000 |
| | mean | 14.826-14.874=-0.048 | | σ | 1.171-0.929=0.242 | | min | 12.193-13.022=-0.829 | | max | 15.748-15.467=0.281 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929-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 | 7201.000-7208.000=-7.000 | | σ | 0.000 | | min | 7201.000-7208.000=-7.000 | | max | 7201.000-7208.000=-7.000 |
| | mean | 13.765-13.557=0.208 | | σ | 1.393-1.475=-0.082 | | min | 11.817-12.117=-0.300 | | max | 15.617-15.626=-0.009 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929-41.929=-0.001 | | σ | 0.002-0.002=-0.000 | | min | 41.927 | | max | 41.931-41.932=-0.000 |
| | mean | 4168.375-4168.750=-0.375 | | σ | 1900.743-1904.522=-3.779 | | min | 1547.000-1549.000=-2.000 | | max | 7201.000-7208.000=-7.000 |
| | mean | 13.620-13.607=0.013 | | σ | 1.744-1.687=0.057 | | min | 10.918-11.094=-0.176 | | max | 15.551-15.172=0.379 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605-27.605=0.000 | | σ | 0.003-0.002=0.001 | | min | 27.603-27.603=0.000 | | max | 27.611-27.607=0.004 |
| | mean | 4168.375-4168.750=-0.375 | | σ | 1900.743-1904.522=-3.779 | | min | 1547.000-1549.000=-2.000 | | max | 7201.000-7208.000=-7.000 |
| | mean | 9.342-9.207=0.136 | | σ | 0.288-0.434=-0.146 | | min | 8.952-8.772=0.180 | | max | 9.749-9.739=0.009 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400-26.401=-0.001 | | σ | 0.002-0.002=-0.000 | | min | 26.399-26.399=-0.000 | | max | 26.403-26.403=-0.000 |
| | mean | 4168.375-4168.750=-0.375 | | σ | 1900.743-1904.522=-3.779 | | min | 1547.000-1549.000=-2.000 | | max | 7201.000-7208.000=-7.000 |
| | mean | 6.805-6.590=0.215 | | σ | 0.262-0.330=-0.068 | | min | 6.411-5.933=0.478 | | max | 7.144-6.927=0.217 |
|
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.670=-0.001 |
| | mean | 4288.750-4285.000=3.750 | | σ | 1980.768-1982.059=-1.290 | | min | 1547.000-1549.000=-2.000 | | max | 7201.000-7208.000=-7.000 |
| | mean | 6.357-6.268=0.089 | | σ | 1.029-0.657=0.371 | | min | 5.723-5.793=-0.070 | | max | 8.860-7.862=0.999 |
|
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-25.659=0.000 | | max | 25.663-25.663=-0.000 |
| | mean | 4288.750-4285.000=3.750 | | σ | 1980.768-1982.059=-1.290 | | min | 1547.000-1549.000=-2.000 | | max | 7201.000-7208.000=-7.000 |
| | mean | 5.916-5.740=0.176 | | σ | 1.076-0.696=0.380 | | min | 5.205-5.097=0.108 | | max | 8.552-7.333=1.219 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969-25.970=-0.001 | | σ | 0.002-0.002=-0.000 | | min | 25.967 | | max | 25.971-25.972=-0.001 |
| | mean | 4288.750-4285.000=3.750 | | σ | 1980.768-1982.059=-1.290 | | min | 1547.000-1549.000=-2.000 | | max | 7201.000-7208.000=-7.000 |
| | mean | 5.937-5.796=0.141 | | σ | 1.167-0.702=0.465 | | min | 5.216-5.319=-0.102 | | max | 8.788-7.488=1.300 |
|
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 | 4288.750-4285.000=3.750 | | σ | 1980.768-1982.059=-1.290 | | min | 1547.000-1549.000=-2.000 | | max | 7201.000-7208.000=-7.000 |
| | mean | 5.771-5.681=0.090 | | σ | 1.042-0.694=0.349 | | min | 5.007-5.122=-0.115 | | max | 8.275-7.323=0.951 |
|