9eddbcb4692466f43b7ef2f65b7f9a2988acd04b

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

*mean*	12.865
σ	0.554
min	11.925
max	13.731

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.614
σ	0.000
min	36.613
max	36.614

*mean*	9615.000
σ	0.000
min	9615.000
max	9615.000

*mean*	12.865
σ	0.530
min	11.882
max	13.500

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*	5182.700
σ	2568.738
min	1313.000
max	9036.000

*mean*	104.954
σ	9.587
min	87.936
max	113.291

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.664
σ	0.002
min	70.662
max	70.667

*mean*	9615.000
σ	0.000
min	9615.000
max	9615.000

*mean*	136.484
σ	5.356
min	121.326
max	139.271

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*	5182.700
σ	2568.738
min	1313.000
max	9036.000

*mean*	9598.335
σ	1909.094
min	6665.337
max	12512.680

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.732
σ	0.002
min	14060.730
max	14060.736

*mean*	9615.000
σ	0.000
min	9615.000
max	9615.000

*mean*	7048.745
σ	1908.789
min	5455.031
max	9865.633

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

*mean*	9615.000
σ	0.000
min	9615.000
max	9615.000

*mean*	4681.627
σ	1256.907
min	3516.970
max	6743.017

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.581
σ	0.002
min	2524.579
max	2524.584

*mean*	9615.000
σ	0.000
min	9615.000
max	9615.000

*mean*	1514.807
σ	804.179
min	1031.339
max	3077.884

iterations=10

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.667
σ	0.418
min	8744.534
max	8745.857

*mean*	4862.400
σ	2620.515
min	1055.000
max	9036.000

*mean*	4706.365
σ	1272.890
min	3553.517
max	7185.364

iterations=10

operation_display=load_product()with indexes

rows=200000

*mean*	8744.533
σ	0.002
min	8744.530
max	8744.536

*mean*	9036.000
σ	0.000
min	9036.000
max	9036.000

*mean*	4405.203
σ	1121.364
min	3505.999
max	6551.112

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.899
max	41.904

*mean*	9615.000
σ	0.000
min	9615.000
max	9615.000

*mean*	14.613
σ	1.061
min	11.945
max	15.498

iterations=10

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.900
σ	0.002
min	41.899
max	41.904

*mean*	9615.000
σ	0.000
min	9615.000
max	9615.000

*mean*	13.555
σ	1.090
min	11.295
max	14.433

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	41.901
σ	0.002
min	41.899
max	41.904

*mean*	9093.900
σ	183.096
min	9036.000
max	9615.000

*mean*	13.667
σ	1.929
min	11.249
max	16.382

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

*mean*	9093.900
σ	183.096
min	9036.000
max	9615.000

*mean*	9485.969
σ	2358.823
min	6603.368
max	12182.547

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

*mean*	5182.700
σ	2568.738
min	1313.000
max	9036.000

*mean*	6.948
σ	0.444
min	5.991
max	7.659

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

*mean*	9615.000
σ	0.000
min	9615.000
max	9615.000

*mean*	103.127
σ	10.212
min	74.205
max	108.129

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

*mean*	216.982
σ	361.478
min	74.433
max	1245.369

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

*mean*	103.130
σ	10.127
min	74.451
max	108.476

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

*mean*	103.243
σ	10.108
min	74.589
max	107.914

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*	5182.700
σ	2568.738
min	1313.000
max	9036.000

*mean*	9.895
σ	0.573
min	8.723
max	10.667

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*	9093.900
σ	183.096
min	9036.000
max	9615.000

*mean*	9.621
σ	1.188
min	8.235
max	12.341

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.001
min	15073.939
max	15073.941

*mean*	9615.000
σ	0.000
min	9615.000
max	9615.000

*mean*	9678.600
σ	1924.382
min	6602.001
max	11990.524

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*	9093.900
σ	183.096
min	9036.000
max	9615.000

*mean*	5.447
σ	0.976
min	4.968
max	8.203

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*	9093.900
σ	183.096
min	9036.000
max	9615.000

*mean*	5.331
σ	0.928
min	4.952
max	7.964

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.932
σ	0.003
min	25.930
max	25.938

*mean*	9093.900
σ	183.096
min	9036.000
max	9615.000

*mean*	5.336
σ	1.063
min	4.941
max	8.361

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*	9093.900
σ	183.096
min	9036.000
max	9615.000

*mean*	5.287
σ	0.996
min	4.874
max	8.115

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

*mean*	152.354
σ	17.780
min	118.239
max	163.806

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

*mean*	151.334
σ	20.329
min	106.769
max	164.815

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

*mean*	389.056
σ	20.106
min	359.107
max	406.632

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	560.000
σ	0.000
min	560.000
max	560.000

*mean*	752.658
σ	53.214
min	657.599
max	828.615