e954bb3a1176ee5d51fc302bde28c19733bf25af

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.000
min	36.614
max	36.615

*mean*	8840.600
σ	8.222
min	8838.000
max	8864.000

*mean*	12.740
σ	0.458
min	12.248
max	13.649

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.614
σ	0.000
min	36.613
max	36.615

*mean*	8840.600
σ	8.222
min	8838.000
max	8864.000

*mean*	56.694
σ	139.334
min	11.600
max	453.241

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*	5240.300
σ	2595.012
min	1270.000
max	8671.000

*mean*	98.673
σ	20.343
min	61.854
max	117.645

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.664
σ	0.002
min	70.662
max	70.667

*mean*	8838.000
σ	0.000
min	8838.000
max	8838.000

*mean*	136.157
σ	6.286
min	122.745
max	141.064

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

*mean*	5240.300
σ	2595.012
min	1270.000
max	8671.000

*mean*	9680.514
σ	2256.421
min	6698.391
max	12405.146

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.733
σ	0.002
min	14060.731
max	14060.736

*mean*	8838.000
σ	0.000
min	8838.000
max	8838.000

*mean*	7636.973
σ	1915.509
min	5455.778
max	10411.982

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.001
min	8744.534
max	8744.538

*mean*	8840.600
σ	8.222
min	8838.000
max	8864.000

*mean*	5092.070
σ	1391.947
min	3510.067
max	7237.106

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.581
σ	0.002
min	2524.579
max	2524.584

*mean*	8838.000
σ	0.000
min	8838.000
max	8838.000

*mean*	1525.574
σ	837.185
min	1032.041
max	3388.838

iterations=10

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.667
σ	0.419
min	8744.534
max	8745.858

*mean*	4863.600
σ	2527.807
min	1043.000
max	8671.000

*mean*	4415.221
σ	1152.925
min	3504.276
max	7007.073

iterations=10

operation_display=load_product()with indexes

rows=200000

*mean*	8744.532
σ	0.002
min	8744.530
max	8744.535

*mean*	8687.700
σ	52.810
min	8671.000
max	8838.000

*mean*	4608.751
σ	1397.206
min	3466.517
max	7284.345

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

*mean*	14.280
σ	1.541
min	11.471
max	16.196

iterations=10

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.901
σ	0.002
min	41.900
max	41.904

*mean*	8838.000
σ	0.000
min	8838.000
max	8838.000

*mean*	13.153
σ	1.617
min	10.918
max	15.354

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	41.901
σ	0.002
min	41.899
max	41.903

*mean*	8687.700
σ	52.810
min	8671.000
max	8838.000

*mean*	13.747
σ	1.331
min	10.880
max	14.967

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.236
max	15088.242

*mean*	8687.700
σ	52.810
min	8671.000
max	8838.000

*mean*	9812.507
σ	1844.892
min	6518.979
max	11653.271

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*	5240.300
σ	2595.012
min	1270.000
max	8671.000

*mean*	6.601
σ	0.325
min	6.134
max	7.121

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*	8687.700
σ	52.810
min	8671.000
max	8838.000

*mean*	6.361
σ	0.333
min	5.666
max	6.647

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

*mean*	26.398
σ	0.000
min	26.398
max	26.398

*mean*	8840.600
σ	8.222
min	8838.000
max	8864.000

*mean*	7.756
σ	0.263
min	7.231
max	8.139

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

*mean*	8838.000
σ	0.000
min	8838.000
max	8838.000

*mean*	98.674
σ	14.053
min	68.931
max	106.633

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.944
σ	0.002
min	40.942
max	40.946

*mean*	8838.000
σ	0.000
min	8838.000
max	8838.000

*mean*	219.278
σ	384.038
min	68.036
max	1311.522

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

*mean*	98.570
σ	14.240
min	68.113
max	106.242

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.951

*mean*	8838.000
σ	0.000
min	8838.000
max	8838.000

*mean*	98.736
σ	14.177
min	68.754
max	106.593

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*	5240.300
σ	2595.012
min	1270.000
max	8671.000

*mean*	9.134
σ	0.828
min	8.103
max	10.423

iterations=10

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

rows=200000

*mean*	27.602
σ	0.002
min	27.602
max	27.605

*mean*	8687.700
σ	52.810
min	8671.000
max	8838.000

*mean*	8.915
σ	0.570
min	7.705
max	9.654

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*	8840.600
σ	8.222
min	8838.000
max	8864.000

*mean*	10140.674
σ	1906.106
min	6564.503
max	11648.624

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.634
σ	0.002
min	25.632
max	25.637

*mean*	8687.700
σ	52.810
min	8671.000
max	8838.000

*mean*	4.766
σ	0.134
min	4.569
max	5.013

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*	8687.700
σ	52.810
min	8671.000
max	8838.000

*mean*	4.611
σ	0.074
min	4.463
max	4.709

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.932
σ	0.002
min	25.930
max	25.935

*mean*	8687.700
σ	52.810
min	8671.000
max	8838.000

*mean*	4.579
σ	0.057
min	4.484
max	4.650

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*	8687.700
σ	52.810
min	8671.000
max	8838.000

*mean*	4.508
σ	0.080
min	4.439
max	4.701

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.673

*mean*	8838.000
σ	0.000
min	8838.000
max	8838.000

*mean*	149.103
σ	18.072
min	113.566
max	162.543

iterations=10

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

rows=200000

*mean*	66.670
σ	0.002
min	66.670
max	66.673

*mean*	8838.000
σ	0.000
min	8838.000
max	8838.000

*mean*	145.750
σ	22.844
min	104.812
max	163.780

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

*mean*	390.702
σ	19.016
min	356.675
max	407.144

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	562.000
σ	0.000
min	562.000
max	562.000

*mean*	750.328
σ	44.000
min	664.435
max	827.258