iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.618-36.617=0.000 | | σ | 0.002-0.002=0.000 | | min | 36.615 | | max | 36.620-36.620=0.000 |
| | mean | 4167.000-4294.000=-127.000 | | σ | 1897.389-1983.448=-86.060 | | min | 1551.000-1553.000=-2.000 | | max | 7198.000-7217.000=-19.000 |
| | mean | 12.828-99.555=-86.727 | | σ | 0.366-245.198=-244.832 | | min | 12.412-12.608=-0.196 | | max | 13.521-706.388=-692.867 |
|
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 | 4286.750-4294.000=-7.250 | | σ | 1976.947-1983.448=-6.501 | | min | 1551.000-1553.000=-2.000 | | max | 7198.000-7217.000=-19.000 |
| | mean | 81.752-13.440=68.312 | | σ | 195.336-3.223=192.113 | | min | 11.882-11.948=-0.065 | | max | 565.181-21.316=543.865 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929-41.930=-0.001 | | σ | 0.001-0.002=-0.000 | | min | 41.928-41.928=0.000 | | max | 41.932-41.932=-0.001 |
| | mean | 7198.000-7217.000=-19.000 | | σ | 0.000 | | min | 7198.000-7217.000=-19.000 | | max | 7198.000-7217.000=-19.000 |
| | mean | 14.892-15.071=-0.179 | | σ | 1.267-0.831=0.437 | | min | 12.151-13.761=-1.611 | | max | 15.707-15.997=-0.291 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930-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 | 7198.000-7217.000=-19.000 | | σ | 0.000 | | min | 7198.000-7217.000=-19.000 | | max | 7198.000-7217.000=-19.000 |
| | mean | 13.960-14.102=-0.143 | | σ | 1.257-0.964=0.294 | | min | 11.290-12.320=-1.030 | | max | 15.350-15.263=0.088 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929-41.928=0.001 | | σ | 0.002-0.002=0.000 | | min | 41.927-41.927=0.000 | | max | 41.932-41.932=0.000 |
| | mean | 4167.000-4177.875=-10.875 | | σ | 1897.389-1905.953=-8.564 | | min | 1551.000-1553.000=-2.000 | | max | 7198.000-7217.000=-19.000 |
| | mean | 13.649-13.844=-0.194 | | σ | 1.485-1.380=0.104 | | min | 11.585-11.658=-0.072 | | max | 15.312-15.439=-0.127 |
|
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 | 4167.000-4177.875=-10.875 | | σ | 1897.389-1905.953=-8.564 | | min | 1551.000-1553.000=-2.000 | | max | 7198.000-7217.000=-19.000 |
| | mean | 9.083-9.178=-0.096 | | σ | 0.337-0.380=-0.043 | | min | 8.330-8.700=-0.370 | | max | 9.427-9.512=-0.085 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400-26.401=-0.001 | | σ | 0.001-0.002=-0.001 | | min | 26.399-26.399=0.000 | | max | 26.403-26.403=-0.000 |
| | mean | 4167.000-4177.875=-10.875 | | σ | 1897.389-1905.953=-8.564 | | min | 1551.000-1553.000=-2.000 | | max | 7198.000-7217.000=-19.000 |
| | mean | 6.505-7.038=-0.533 | | σ | 0.365-0.397=-0.031 | | min | 5.846-6.461=-0.614 | | max | 6.880-7.460=-0.580 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.667-25.666=0.001 | | σ | 0.002-0.002=0.000 | | min | 25.665-25.664=0.000 | | max | 25.670-25.668=0.001 |
| | mean | 4286.750-4294.000=-7.250 | | σ | 1976.947-1983.448=-6.501 | | min | 1551.000-1553.000=-2.000 | | max | 7198.000-7217.000=-19.000 |
| | mean | 6.054-6.149=-0.095 | | σ | 0.094-0.532=-0.437 | | min | 5.920-5.755=0.165 | | max | 6.186-7.406=-1.220 |
|
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 |
| | mean | 4286.750-4294.000=-7.250 | | σ | 1976.947-1983.448=-6.501 | | min | 1551.000-1553.000=-2.000 | | max | 7198.000-7217.000=-19.000 |
| | mean | 5.678-5.888=-0.210 | | σ | 0.226-0.538=-0.311 | | min | 5.200-5.618=-0.418 | | max | 5.964-7.208=-1.243 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969-25.968=0.000 | | σ | 0.002-0.002=0.000 | | min | 25.967 | | max | 25.971-25.971=0.000 |
| | mean | 4286.750-4294.000=-7.250 | | σ | 1976.947-1983.448=-6.501 | | min | 1551.000-1553.000=-2.000 | | max | 7198.000-7217.000=-19.000 |
| | mean | 5.705-6.072=-0.367 | | σ | 0.204-0.569=-0.365 | | min | 5.274-5.654=-0.380 | | max | 5.934-7.409=-1.475 |
|
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 | | max | 25.971-25.971=0.000 |
| | mean | 4286.750-4294.000=-7.250 | | σ | 1976.947-1983.448=-6.501 | | min | 1551.000-1553.000=-2.000 | | max | 7198.000-7217.000=-19.000 |
| | mean | 5.543-5.789=-0.245 | | σ | 0.233-0.578=-0.345 | | min | 5.035-5.289=-0.254 | | max | 5.839-7.163=-1.324 |
|