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.614=0.000
σ	0.001-0.001=-0.000
min	36.614-36.614=0.000
max	36.618-36.618=-0.000

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	13.046-12.865=0.181
σ	0.298-0.554=-0.256
min	12.576-11.925=0.651
max	13.474-13.731=-0.257

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.614-36.614=0.000
σ	0.000-0.000=0.000
min	36.613-36.613=-0.000
max	36.614-36.614=0.000

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	95.312-12.865=82.447
σ	260.687-0.530=260.157
min	11.981-11.882=0.099
max	837.240-13.500=823.739

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.074=-0.000
σ	0.000-0.000=0.000
min	62.073
max	62.074-62.074=-0.000

*mean*	5041.400-5182.700=-141.300
σ	2529.900-2568.738=-38.838
min	1289.000-1313.000=-24.000
max	8543.000-9036.000=-493.000

*mean*	102.608-104.954=-2.347
σ	11.017-9.587=1.431
min	81.796-87.936=-6.140
max	115.144-113.291=1.853

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.664-70.664=0.000
σ	0.002-0.002=-0.000
min	70.662-70.662=-0.000
max	70.667-70.667=-0.000

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	136.772-136.484=0.287
σ	2.370-5.356=-2.987
min	131.978-121.326=10.652
max	139.111-139.271=-0.159

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.671-15109.672=-0.000
σ	3.988-3.988=-0.000
min	15108.410-15108.410=-0.000
max	15121.020-15121.021=-0.001

*mean*	5041.400-5182.700=-141.300
σ	2529.900-2568.738=-38.838
min	1289.000-1313.000=-24.000
max	8543.000-9036.000=-493.000

*mean*	10733.358-9598.335=1135.023
σ	1846.468-1909.094=-62.626
min	6604.157-6665.337=-61.180
max	12429.992-12512.680=-82.688

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.733-14060.732=0.000
σ	0.002-0.002=-0.000
min	14060.731-14060.730=0.001
max	14060.736-14060.736=0.000

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	7117.724-7048.745=68.979
σ	1402.395-1908.789=-506.394
min	5425.772-5455.031=-29.259
max	9086.346-9865.633=-779.287

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.535-8744.535=-0.000
σ	0.000-0.000=0.000
min	8744.534-8744.534=-0.000
max	8744.536-8744.535=0.001

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	4109.446-4681.627=-572.181
σ	947.293-1256.907=-309.614
min	3507.404-3516.970=-9.566
max	6263.552-6743.017=-479.465

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.581-2524.581=-0.000
σ	0.002-0.002=0.000
min	2524.579-2524.579=-0.000
max	2524.583-2524.584=-0.001

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	1217.253-1514.807=-297.555
σ	556.728-804.179=-247.451
min	1034.296-1031.339=2.957
max	2801.655-3077.884=-276.229

iterations=10

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.667-8744.667=-0.000
σ	0.418-0.418=0.000
min	8744.534-8744.534=-0.000
max	8745.858-8745.857=0.000

*mean*	4771.200-4862.400=-91.200
σ	2503.137-2620.515=-117.378
min	1050.000-1055.000=-5.000
max	8543.000-9036.000=-493.000

*mean*	5053.929-4706.365=347.564
σ	1456.251-1272.890=183.361
min	3469.960-3553.517=-83.557
max	7242.487-7185.364=57.123

iterations=10

operation_display=load_product()with indexes

rows=200000

*mean*	8744.533-8744.533=0.000
σ	0.002-0.002=-0.000
min	8744.531-8744.530=0.001
max	8744.536-8744.536=0.000

*mean*	8543.000-9036.000=-493.000
σ	0.000
min	8543.000-9036.000=-493.000
max	8543.000-9036.000=-493.000

*mean*	4224.102-4405.203=-181.101
σ	1173.574-1121.364=52.210
min	3482.747-3505.999=-23.252
max	6970.329-6551.112=419.218

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records(), no indexes

rows=200000

*mean*	41.901-41.901=0.000
σ	0.002-0.002=-0.000
min	41.900-41.899=0.000
max	41.904-41.904=-0.000

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	14.105-14.613=-0.508
σ	0.828-1.061=-0.233
min	12.597-11.945=0.652
max	15.017-15.498=-0.481

iterations=10

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.900-41.900=-0.000
σ	0.002-0.002=-0.000
min	41.900-41.899=0.000
max	41.903-41.904=-0.000

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	12.581-13.555=-0.974
σ	1.104-1.090=0.014
min	11.585-11.295=0.289
max	14.640-14.433=0.207

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	41.901-41.901=-0.000
σ	0.002-0.002=0.000
min	41.899
max	41.904

*mean*	8668.900-9093.900=-425.000
σ	398.131-183.096=215.035
min	8543.000-9036.000=-493.000
max	9802.000-9615.000=187.000

*mean*	13.063-13.667=-0.603
σ	2.065-1.929=0.136
min	10.685-11.249=-0.564
max	15.869-16.382=-0.513

CSV - table_records(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	15088.238-15088.238=0.000
σ	0.002-0.002=-0.000
min	15088.237-15088.236=0.000
max	15088.241

*mean*	8668.900-9093.900=-425.000
σ	398.131-183.096=215.035
min	8543.000-9036.000=-493.000
max	9802.000-9615.000=187.000

*mean*	9445.920-9485.969=-40.049
σ	2254.916-2358.823=-103.907
min	6525.324-6603.368=-78.044
max	12513.602-12182.547=331.055

CSV - vertical_lookup_list() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed, after column_set(), repeat

rows=200000

*mean*	26.397
σ	0.000
min	26.397
max	26.398

*mean*	5041.400
σ	2529.900
min	1289.000
max	8543.000

*mean*	7.001
σ	0.519
min	5.877
max	7.858

iterations=10

operation_display=vertical_lookup_list() on indexed, after table_records(), repeat

rows=200000

*mean*	26.398
σ	0.002
min	26.397
max	26.401

*mean*	8668.900
σ	398.131
min	8543.000
max	9802.000

*mean*	6.854
σ	1.126
min	6.068
max	9.767

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

*mean*	26.398-26.397=0.000
σ	0.000-0.000=-0.000
min	26.398-26.397=0.000
max	26.398-26.398=0.000

*mean*	9802.000-5182.700=4619.300
σ	0.000-2568.738=-2568.738
min	9802.000-1313.000=8489.000
max	9802.000-9036.000=766.000

*mean*	8.135-6.948=1.187
σ	0.221-0.444=-0.223
min	7.782-5.991=1.791
max	8.446-7.659=0.786

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.943-40.944=-0.000
σ	0.002-0.002=0.000
min	40.942-40.942=0.000
max	40.947-40.947=-0.000

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	99.798-103.127=-3.329
σ	8.130-10.212=-2.082
min	84.291-74.205=10.085
max	107.061-108.129=-1.069

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.943-40.944=-0.000
σ	0.002-0.002=0.000
min	40.942-40.942=-0.000
max	40.946-40.946=0.000

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	99.967-216.982=-117.016
σ	8.158-361.478=-353.319
min	84.556-74.433=10.123
max	107.059-1245.369=-1138.310

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.949-40.949=-0.000
σ	0.002-0.002=0.000
min	40.947-40.947=-0.000
max	40.952-40.952=-0.000

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	99.951-103.130=-3.179
σ	8.260-10.127=-1.866
min	83.619-74.451=9.168
max	106.650-108.476=-1.826

iterations=10

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

rows=200000

*mean*	40.948-40.948=0.000
σ	0.002-0.002=-0.000
min	40.947-40.947=0.000
max	40.950-40.951=-0.000

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	99.914-103.243=-3.329
σ	8.134-10.108=-1.974
min	84.310-74.589=9.721
max	106.574-107.914=-1.340

CSV - vertical_lookup_list(), mini warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed, after column_set()

rows=200000

*mean*	27.602-27.602=0.000
σ	0.002-0.002=-0.000
min	27.602
max	27.607

*mean*	5041.400-5182.700=-141.300
σ	2529.900-2568.738=-38.838
min	1289.000-1313.000=-24.000
max	8543.000-9036.000=-493.000

*mean*	9.765-9.895=-0.130
σ	0.590-0.573=0.016
min	8.849-8.723=0.126
max	10.327-10.667=-0.340

iterations=10

operation_display=vertical_lookup_list() on indexed, after table_records()

rows=200000

*mean*	27.603-27.602=0.000
σ	0.002-0.002=-0.000
min	27.602-27.602=0.000
max	27.605

*mean*	8668.900-9093.900=-425.000
σ	398.131-183.096=215.035
min	8543.000-9036.000=-493.000
max	9802.000-9615.000=187.000

*mean*	9.545-9.621=-0.076
σ	1.189-1.188=0.001
min	8.583-8.235=0.348
max	12.564-12.341=0.223

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-15073.940=0.000
σ	0.000-0.001=-0.000
min	15073.939
max	15073.940-15073.941=-0.001

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	9351.923-9678.600=-326.677
σ	2292.629-1924.382=368.247
min	6553.272-6602.001=-48.729
max	12534.160-11990.524=543.636

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.633=0.000
σ	0.002-0.002=-0.000
min	25.631
max	25.637

*mean*	8668.900-9093.900=-425.000
σ	398.131-183.096=215.035
min	8543.000-9036.000=-493.000
max	9802.000-9615.000=187.000

*mean*	5.368-5.447=-0.079
σ	0.956-0.976=-0.020
min	4.886-4.968=-0.082
max	8.012-8.203=-0.190

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.628-25.628=-0.000
σ	0.002-0.002=-0.000
min	25.626
max	25.630-25.630=-0.000

*mean*	8668.900-9093.900=-425.000
σ	398.131-183.096=215.035
min	8543.000-9036.000=-493.000
max	9802.000-9615.000=187.000

*mean*	5.205-5.331=-0.126
σ	1.032-0.928=0.104
min	4.736-4.952=-0.216
max	8.109-7.964=0.145

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.932-25.932=-0.000
σ	0.003-0.003=-0.000
min	25.930
max	25.939-25.938=0.000

*mean*	8668.900-9093.900=-425.000
σ	398.131-183.096=215.035
min	8543.000-9036.000=-493.000
max	9802.000-9615.000=187.000

*mean*	5.256-5.336=-0.080
σ	1.020-1.063=-0.044
min	4.822-4.941=-0.119
max	8.135-8.361=-0.225

iterations=10

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

rows=200000

*mean*	25.931-25.931=0.000
σ	0.002-0.002=-0.000
min	25.930
max	25.934

*mean*	8668.900-9093.900=-425.000
σ	398.131-183.096=215.035
min	8543.000-9036.000=-493.000
max	9802.000-9615.000=187.000

*mean*	5.239-5.287=-0.047
σ	0.977-0.996=-0.018
min	4.743-4.874=-0.131
max	7.985-8.115=-0.131

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.671=0.000
σ	0.002-0.002=0.000
min	66.670-66.670=-0.000
max	66.674-66.673=0.001

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	260.870-152.354=108.516
σ	344.148-17.780=326.368
min	131.857-118.239=13.618
max	1239.843-163.806=1076.036

iterations=10

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

rows=200000

*mean*	66.671-66.670=0.000
σ	0.002-0.002=-0.000
min	66.670
max	66.673

*mean*	9802.000-9615.000=187.000
σ	0.000
min	9802.000-9615.000=187.000
max	9802.000-9615.000=187.000

*mean*	189.328-151.334=37.994
σ	125.644-20.329=105.316
min	131.804-106.769=25.036
max	545.277-164.815=380.462

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*	473.900-478.000=-4.100
σ	0.316-0.000=0.316
min	473.000-478.000=-5.000
max	474.000-478.000=-4.000

*mean*	392.765-389.056=3.709
σ	22.743-20.106=2.637
min	330.337-359.107=-28.770
max	408.303-406.632=1.671

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	559.000-560.000=-1.000
σ	0.000
min	559.000-560.000=-1.000
max	559.000-560.000=-1.000

*mean*	747.785-752.658=-4.873
σ	66.359-53.214=13.145
min	636.680-657.599=-20.919
max	813.933-828.615=-14.681