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.616-36.615=0.000 | | max | 36.619-36.619=0.000 |
| | mean | 4281.875-4287.750=-5.875 | | σ | 1977.280-1976.741=0.539 | | min | 1547.000-1552.000=-5.000 | | max | 7207.000-7216.000=-9.000 |
| | mean | 81.837-111.760=-29.923 | | σ | 194.853-279.006=-84.153 | | min | 12.717-12.756=-0.039 | | max | 564.074-802.265=-238.191 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617-36.617=-0.000 | | σ | 0.002-0.002=0.000 | | min | 36.616-36.616=-0.000 | | max | 36.620-36.620=-0.000 |
| | mean | 4281.875-4287.750=-5.875 | | σ | 1977.280-1976.741=0.539 | | min | 1547.000-1552.000=-5.000 | | max | 7207.000-7216.000=-9.000 |
| | mean | 14.414-13.854=0.560 | | σ | 4.755-3.028=1.727 | | min | 11.889-12.113=-0.224 | | max | 26.069-21.254=4.815 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930-41.930=-0.001 | | σ | 0.002-0.002=0.000 | | min | 41.928-41.928=-0.000 | | max | 41.932-41.932=-0.000 |
| | mean | 7207.000-7216.000=-9.000 | | σ | 0.000 | | min | 7207.000-7216.000=-9.000 | | max | 7207.000-7216.000=-9.000 |
| | mean | 15.285-15.062=0.223 | | σ | 0.903-0.939=-0.036 | | min | 13.440-13.085=0.355 | | max | 16.313-15.783=0.529 |
|
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 | 7207.000-7216.000=-9.000 | | σ | 0.000 | | min | 7207.000-7216.000=-9.000 | | max | 7207.000-7216.000=-9.000 |
| | mean | 13.561-13.449=0.111 | | σ | 1.429-0.805=0.623 | | min | 11.772-12.269=-0.497 | | max | 15.325-14.481=0.844 |
|
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.931-41.931=-0.000 |
| | mean | 4165.125-4170.625=-5.500 | | σ | 1900.024-1899.434=0.590 | | min | 1547.000-1552.000=-5.000 | | max | 7207.000-7216.000=-9.000 |
| | mean | 13.819-13.139=0.681 | | σ | 1.599-1.239=0.360 | | min | 11.196-11.520=-0.324 | | max | 15.526-14.634=0.892 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605-27.604=0.001 | | σ | 0.003-0.002=0.001 | | min | 27.603-27.603=0.000 | | max | 27.611-27.607=0.004 |
| | mean | 4165.125-4170.625=-5.500 | | σ | 1900.024-1899.434=0.590 | | min | 1547.000-1552.000=-5.000 | | max | 7207.000-7216.000=-9.000 |
| | mean | 8.902-9.132=-0.229 | | σ | 0.254-0.373=-0.119 | | min | 8.394-8.490=-0.096 | | max | 9.212-9.533=-0.321 |
|
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 | | max | 26.403-26.403=-0.000 |
| | mean | 4165.125-4170.625=-5.500 | | σ | 1900.024-1899.434=0.590 | | min | 1547.000-1552.000=-5.000 | | max | 7207.000-7216.000=-9.000 |
| | mean | 6.872-6.998=-0.126 | | σ | 0.271-0.527=-0.256 | | min | 6.252-6.067=0.185 | | max | 7.154-7.424=-0.270 |
|
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.668=0.000 |
| | mean | 4281.875-4287.750=-5.875 | | σ | 1977.280-1976.741=0.539 | | min | 1547.000-1552.000=-5.000 | | max | 7207.000-7216.000=-9.000 |
| | mean | 6.397-6.171=0.226 | | σ | 1.137-0.536=0.601 | | min | 5.779-5.772=0.007 | | max | 9.193-7.453=1.741 |
|
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-25.663=0.000 |
| | mean | 4281.875-4287.750=-5.875 | | σ | 1977.280-1976.741=0.539 | | min | 1547.000-1552.000=-5.000 | | max | 7207.000-7216.000=-9.000 |
| | mean | 5.935-5.950=-0.015 | | σ | 1.166-0.551=0.616 | | min | 5.279-5.606=-0.327 | | max | 8.804-7.270=1.535 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969-25.969=0.001 | | σ | 0.002-0.002=-0.000 | | min | 25.967-25.967=0.000 | | max | 25.971-25.972=-0.001 |
| | mean | 4281.875-4287.750=-5.875 | | σ | 1977.280-1976.741=0.539 | | min | 1547.000-1552.000=-5.000 | | max | 7207.000-7216.000=-9.000 |
| | mean | 5.971-6.063=-0.092 | | σ | 1.049-0.594=0.456 | | min | 5.246-5.494=-0.248 | | max | 8.532-7.354=1.178 |
|
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-25.967=-0.000 | | max | 25.971-25.971=0.000 |
| | mean | 4281.875-4287.750=-5.875 | | σ | 1977.280-1976.741=0.539 | | min | 1547.000-1552.000=-5.000 | | max | 7207.000-7216.000=-9.000 |
| | mean | 5.862-5.741=0.120 | | σ | 1.047-0.587=0.461 | | min | 5.180-5.209=-0.029 | | max | 8.426-7.141=1.285 |
|