Compare commits

CSV - column_set() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on indexed

rows=200000

*mean*	36.614-36.783=-0.169
σ	0.000-0.003=-0.003
min	36.614-36.780=-0.167
max	36.615-36.788=-0.174

*mean*	9807.000-8991.900=815.100
σ	0.000-28.144=-28.144
min	9807.000-8983.000=824.000
max	9807.000-9072.000=735.000

*mean*	12.661-108.393=-95.732
σ	0.363-301.863=-301.500
min	11.993-12.515=-0.522
max	13.285-967.509=-954.224

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.614-36.782=-0.169
σ	0.000-0.002=-0.002
min	36.613-36.780=-0.167
max	36.614-36.784=-0.170

*mean*	9807.000-8991.900=815.100
σ	0.000-28.144=-28.144
min	9807.000-8983.000=824.000
max	9807.000-9072.000=735.000

*mean*	12.743-13.420=-0.677
σ	0.581-1.329=-0.748
min	12.008-12.024=-0.016
max	13.728-16.325=-2.597

CSV - column_set() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.074-62.243=-0.169
σ	0.000-0.002=-0.002
min	62.074-62.241=-0.167
max	62.074-62.245=-0.170

*mean*	5218.000-5240.600=-22.600
σ	2576.846-2594.861=-18.015
min	1266.000-1270.000=-4.000
max	8618.000-8670.000=-52.000

*mean*	104.593-98.607=5.987
σ	11.780-19.064=-7.284
min	84.835-61.182=23.652
max	116.346-113.487=2.859

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.664-70.832=-0.168
σ	0.002-0.002=-0.000
min	70.662-70.830=-0.167
max	70.667-70.834=-0.167

*mean*	9807.000-8983.000=824.000
σ	0.000
min	9807.000-8983.000=824.000
max	9807.000-8983.000=824.000

*mean*	137.496-131.451=6.045
σ	5.460-11.696=-6.236
min	125.971-114.994=10.978
max	143.595-145.732=-2.138

CSV - column_set(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on unindexed, dense

rows=200000

*mean*	15109.672-15109.843=-0.171
σ	3.988-3.992=-0.004
min	15108.410-15108.577=-0.166
max	15121.021-15121.204=-0.183

*mean*	5218.000-5240.600=-22.600
σ	2576.846-2594.861=-18.015
min	1266.000-1270.000=-4.000
max	8618.000-8670.000=-52.000

*mean*	9660.113-9478.975=181.138
σ	2164.029-1681.659=482.370
min	6756.809-6712.255=44.554
max	12585.732-12417.818=167.914

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.732-14060.903=-0.170
σ	0.001-0.004=-0.003
min	14060.731-14060.897=-0.166
max	14060.735-14060.908=-0.173

*mean*	9807.000-8983.000=824.000
σ	0.000
min	9807.000-8983.000=824.000
max	9807.000-8983.000=824.000

*mean*	7588.130-7083.731=504.399
σ	1719.962-2038.791=-318.829
min	5505.124-5454.342=50.782
max	9424.793-11108.659=-1683.866

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=load_product() with indexes

rows=200000

*mean*	8744.667-8744.667=0.001
σ	0.418-0.419=-0.000
min	8744.534-8744.531=0.003
max	8745.858-8745.858=-0.000

*mean*	4843.900-4863.800=-19.900
σ	2511.079-2527.720=-16.641
min	1044.000
max	8618.000-8670.000=-52.000

*mean*	4498.070-4225.010=273.060
σ	1243.308-1070.523=172.785
min	3516.577-3495.639=20.938
max	7292.244-6922.236=370.008

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.581-2524.582=-0.001
σ	0.002-0.004=-0.002
min	2524.579-2524.579=-0.000
max	2524.583-2524.592=-0.009

*mean*	9807.000-8983.000=824.000
σ	0.000
min	9807.000-8983.000=824.000
max	9807.000-8983.000=824.000

*mean*	1270.322-1377.176=-106.853
σ	485.121-910.142=-425.021
min	1039.422-1034.016=5.407
max	2437.312-3936.024=-1498.711

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	41.901-42.069=-0.167
σ	0.002-0.002=0.000
min	41.899-42.066=-0.167
max	41.904-42.071=-0.167

*mean*	9807.000-8983.000=824.000
σ	0.000
min	9807.000-8983.000=824.000
max	9807.000-8983.000=824.000

*mean*	14.368-13.795=0.573
σ	1.354-1.713=-0.359
min	11.057-11.407=-0.350
max	15.594-15.480=0.114

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	41.901-42.067=-0.166
σ	0.002-0.002=0.000
min	41.899-42.065=-0.166
max	41.904-42.070=-0.167

*mean*	8736.900-8701.300=35.600
σ	375.995-98.979=277.016
min	8618.000-8670.000=-52.000
max	9807.000-8983.000=824.000

*mean*	12.839-14.630=-1.790
σ	1.804-1.577=0.226
min	10.913-11.285=-0.372
max	16.035-16.200=-0.165

CSV - table_records(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	15088.238-15088.406=-0.168
σ	0.002-0.003=-0.001
min	15088.237-15088.403=-0.166
max	15088.241-15088.411=-0.170

*mean*	8736.900-8701.300=35.600
σ	375.995-98.979=277.016
min	8618.000-8670.000=-52.000
max	9807.000-8983.000=824.000

*mean*	9379.752-9783.298=-403.546
σ	2135.065-1825.428=309.637
min	6660.524-6582.803=77.721
max	12497.695-12216.358=281.337

CSV - vertical_lookup_list() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

*mean*	26.397-26.566=-0.168
σ	0.000-0.002=-0.002
min	26.397-26.564=-0.166
max	26.398-26.568=-0.170

*mean*	5218.000-5240.600=-22.600
σ	2576.846-2594.861=-18.015
min	1266.000-1270.000=-4.000
max	8618.000-8670.000=-52.000

*mean*	7.311-7.044=0.267
σ	0.321-0.594=-0.273
min	6.882-6.088=0.794
max	7.871-7.861=0.010

CSV - vertical_lookup_list() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.944-41.110=-0.167
σ	0.002-0.002=-0.000
min	40.942-41.109=-0.167
max	40.947-41.114=-0.168

*mean*	9807.000-8983.000=824.000
σ	0.000
min	9807.000-8983.000=824.000
max	9807.000-8983.000=824.000

*mean*	203.890-91.042=112.848
σ	329.196-18.768=310.428
min	84.207-63.737=20.470
max	1140.603-108.183=1032.420

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.943-41.111=-0.167
σ	0.002-0.002=-0.000
min	40.942-41.109=-0.167
max	40.946-41.113=-0.167

*mean*	9807.000-8983.000=824.000
σ	0.000
min	9807.000-8983.000=824.000
max	9807.000-8983.000=824.000

*mean*	97.414-91.095=6.319
σ	9.911-18.705=-8.794
min	76.758-64.116=12.642
max	105.489-108.117=-2.628

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat

rows=200000

*mean*	40.948-41.116=-0.168
σ	0.002-0.002=-0.000
min	40.947-41.114=-0.167
max	40.951-41.118=-0.167

*mean*	9807.000-8983.000=824.000
σ	0.000
min	9807.000-8983.000=824.000
max	9807.000-8983.000=824.000

*mean*	100.670-91.298=9.372
σ	7.239-18.790=-11.551
min	84.472-64.188=20.284
max	108.020-108.988=-0.968

CSV - vertical_lookup_list(), mini warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	27.602-27.770=-0.168
σ	0.002-0.002=-0.001
min	27.602-27.768=-0.166
max	27.607-27.773=-0.166

*mean*	5218.000-5240.600=-22.600
σ	2576.846-2594.861=-18.015
min	1266.000-1270.000=-4.000
max	8618.000-8670.000=-52.000

*mean*	9.602-9.834=-0.232
σ	0.670-0.576=0.093
min	8.710-8.767=-0.057
max	10.251-10.332=-0.080

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.949-41.116=-0.167
σ	0.002-0.002=-0.000
min	40.947-41.114=-0.167
max	40.952-41.119=-0.167

*mean*	9807.000-8983.000=824.000
σ	0.000
min	9807.000-8983.000=824.000
max	9807.000-8983.000=824.000

*mean*	100.818-91.310=9.508
σ	7.394-18.821=-11.427
min	84.103-64.605=19.499
max	107.951-108.496=-0.546

CSV - vertical_lookup_list(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	15073.940-15074.122=-0.182
σ	0.000-0.041=-0.041
min	15073.939-15074.105=-0.166
max	15073.940-15074.239=-0.299

*mean*	9807.000-8991.900=815.100
σ	0.000-28.144=-28.144
min	9807.000-8983.000=824.000
max	9807.000-9072.000=735.000

*mean*	9618.040-9779.729=-161.689
σ	2127.473-1827.546=299.926
min	6595.672-6578.892=16.779
max	12503.876-12514.146=-10.270

CSV - vertical_lookup_row_list() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.633-25.800=-0.166
σ	0.002-0.002=0.000
min	25.631-25.798=-0.166
max	25.637-25.802=-0.165

*mean*	8736.900-8701.300=35.600
σ	375.995-98.979=277.016
min	8618.000-8670.000=-52.000
max	9807.000-8983.000=824.000

*mean*	5.781-5.242=0.539
σ	0.829-0.177=0.653
min	5.381-5.034=0.347
max	8.125-5.513=2.612

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.628-25.795=-0.167
σ	0.002-0.002=0.000
min	25.626-25.793=-0.166
max	25.631-25.797=-0.166

*mean*	8736.900-8701.300=35.600
σ	375.995-98.979=277.016
min	8618.000-8670.000=-52.000
max	9807.000-8983.000=824.000

*mean*	5.541-5.193=0.348
σ	0.378-0.167=0.211
min	5.275-4.964=0.311
max	6.567-5.413=1.154

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.932-26.100=-0.167
σ	0.002-0.003=-0.000
min	25.930-26.096=-0.166
max	25.935-26.104=-0.169

*mean*	8736.900-8701.300=35.600
σ	375.995-98.979=277.016
min	8618.000-8670.000=-52.000
max	9807.000-8983.000=824.000

*mean*	5.560-5.209=0.351
σ	0.410-0.181=0.229
min	5.294-5.045=0.249
max	6.654-5.602=1.052

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat

rows=200000

*mean*	25.931-26.099=-0.168
σ	0.002-0.002=-0.000
min	25.930-26.096=-0.166
max	25.934-26.101=-0.167

*mean*	8736.900-8701.300=35.600
σ	375.995-98.979=277.016
min	8618.000-8670.000=-52.000
max	9807.000-8983.000=824.000

*mean*	5.516-5.187=0.329
σ	0.377-0.171=0.206
min	5.309-4.991=0.318
max	6.576-5.521=1.055

CSV - vertical_lookup_row_list() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.671-66.839=-0.168
σ	0.001-0.002=-0.001
min	66.670-66.836=-0.167
max	66.673-66.841=-0.168

*mean*	9807.000-8983.000=824.000
σ	0.000
min	9807.000-8983.000=824.000
max	9807.000-8983.000=824.000

*mean*	150.013-141.433=8.580
σ	17.158-25.483=-8.325
min	109.815-104.549=5.267
max	164.003-164.930=-0.927

iterations=10

operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat

rows=200000

*mean*	66.670-66.838=-0.167
σ	0.002-0.003=-0.001
min	66.670-66.836=-0.167
max	66.673-66.845=-0.172

*mean*	9807.000-8983.000=824.000
σ	0.000
min	9807.000-8983.000=824.000
max	9807.000-8983.000=824.000

*mean*	151.012-209.159=-58.148
σ	17.178-220.047=-202.869
min	110.861-106.206=4.655
max	165.391-831.472=-666.081

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.559
σ	0.002
min	172.558
max	172.562

*mean*	477.000-475.700=1.300
σ	0.000-0.483=-0.483
min	477.000-475.000=2.000
max	477.000-476.000=1.000

*mean*	389.841-380.813=9.028
σ	19.486-32.406=-12.920
min	359.578-304.766=54.812
max	405.835-404.073=1.763

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	560.100-561.000=-0.900
σ	0.316-0.000=0.316
min	560.000-561.000=-1.000
max	561.000

*mean*	758.484-738.910=19.575
σ	40.642-62.416=-21.775
min	682.059-636.010=46.049
max	826.925-790.352=36.574