68b3038d96fe15ecbcccc25ed793fec35fa62ae4

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
σ	0.001
min	36.614
max	36.618

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	13.046
σ	0.298
min	12.576
max	13.474

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.614
σ	0.000
min	36.613
max	36.614

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	95.312
σ	260.687
min	11.981
max	837.240

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

*mean*	5041.400
σ	2529.900
min	1289.000
max	8543.000

*mean*	102.608
σ	11.017
min	81.796
max	115.144

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.664
σ	0.002
min	70.662
max	70.667

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	136.772
σ	2.370
min	131.978
max	139.111

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
σ	3.988
min	15108.410
max	15121.020

*mean*	5041.400
σ	2529.900
min	1289.000
max	8543.000

*mean*	10733.358
σ	1846.468
min	6604.157
max	12429.992

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.733
σ	0.002
min	14060.731
max	14060.736

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	7117.724
σ	1402.395
min	5425.772
max	9086.346

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
σ	0.000
min	8744.534
max	8744.536

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	4109.446
σ	947.293
min	3507.404
max	6263.552

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.581
σ	0.002
min	2524.579
max	2524.583

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	1217.253
σ	556.728
min	1034.296
max	2801.655

iterations=10

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.667
σ	0.418
min	8744.534
max	8745.858

*mean*	4771.200
σ	2503.137
min	1050.000
max	8543.000

*mean*	5053.929
σ	1456.251
min	3469.960
max	7242.487

iterations=10

operation_display=load_product()with indexes

rows=200000

*mean*	8744.533
σ	0.002
min	8744.531
max	8744.536

*mean*	8543.000
σ	0.000
min	8543.000
max	8543.000

*mean*	4224.102
σ	1173.574
min	3482.747
max	6970.329

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records(), no indexes

rows=200000

*mean*	41.901
σ	0.002
min	41.900
max	41.904

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	14.105
σ	0.828
min	12.597
max	15.017

iterations=10

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.900
σ	0.002
min	41.900
max	41.903

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	12.581
σ	1.104
min	11.585
max	14.640

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	41.901
σ	0.002
min	41.899
max	41.904

*mean*	8668.900
σ	398.131
min	8543.000
max	9802.000

*mean*	13.063
σ	2.065
min	10.685
max	15.869

CSV - table_records(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	15088.238
σ	0.002
min	15088.237
max	15088.241

*mean*	8668.900
σ	398.131
min	8543.000
max	9802.000

*mean*	9445.920
σ	2254.916
min	6525.324
max	12513.602

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
σ	0.000
min	26.398
max	26.398

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	8.135
σ	0.221
min	7.782
max	8.446

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
σ	0.002
min	40.942
max	40.947

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	99.798
σ	8.130
min	84.291
max	107.061

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.943
σ	0.002
min	40.942
max	40.946

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	99.967
σ	8.158
min	84.556
max	107.059

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.949
σ	0.002
min	40.947
max	40.952

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	99.951
σ	8.260
min	83.619
max	106.650

iterations=10

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

rows=200000

*mean*	40.948
σ	0.002
min	40.947
max	40.950

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	99.914
σ	8.134
min	84.310
max	106.574

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
σ	0.002
min	27.602
max	27.607

*mean*	5041.400
σ	2529.900
min	1289.000
max	8543.000

*mean*	9.765
σ	0.590
min	8.849
max	10.327

iterations=10

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

rows=200000

*mean*	27.603
σ	0.002
min	27.602
max	27.605

*mean*	8668.900
σ	398.131
min	8543.000
max	9802.000

*mean*	9.545
σ	1.189
min	8.583
max	12.564

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

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	9351.923
σ	2292.629
min	6553.272
max	12534.160

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
σ	0.002
min	25.631
max	25.637

*mean*	8668.900
σ	398.131
min	8543.000
max	9802.000

*mean*	5.368
σ	0.956
min	4.886
max	8.012

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.628
σ	0.002
min	25.626
max	25.630

*mean*	8668.900
σ	398.131
min	8543.000
max	9802.000

*mean*	5.205
σ	1.032
min	4.736
max	8.109

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.932
σ	0.003
min	25.930
max	25.939

*mean*	8668.900
σ	398.131
min	8543.000
max	9802.000

*mean*	5.256
σ	1.020
min	4.822
max	8.135

iterations=10

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

rows=200000

*mean*	25.931
σ	0.002
min	25.930
max	25.934

*mean*	8668.900
σ	398.131
min	8543.000
max	9802.000

*mean*	5.239
σ	0.977
min	4.743
max	7.985

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
σ	0.002
min	66.670
max	66.674

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	260.870
σ	344.148
min	131.857
max	1239.843

iterations=10

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

rows=200000

*mean*	66.671
σ	0.002
min	66.670
max	66.673

*mean*	9802.000
σ	0.000
min	9802.000
max	9802.000

*mean*	189.328
σ	125.644
min	131.804
max	545.277

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
σ	0.316
min	473.000
max	474.000

*mean*	392.765
σ	22.743
min	330.337
max	408.303

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	559.000
σ	0.000
min	559.000
max	559.000

*mean*	747.785
σ	66.359
min	636.680
max	813.933