50835d55699462228d80caf4696920aa6586ccbd

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

*mean*	9798.000
σ	0.000
min	9798.000
max	9798.000

*mean*	13.166
σ	0.326
min	12.720
max	13.782

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.614
σ	0.001
min	36.614
max	36.617

*mean*	9798.000
σ	0.000
min	9798.000
max	9798.000

*mean*	107.406
σ	300.026
min	11.730
max	961.292

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.074
max	62.074

*mean*	5218.100
σ	2576.494
min	1268.000
max	8618.000

*mean*	105.673
σ	14.804
min	80.940
max	120.695

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.664
σ	0.002
min	70.662
max	70.667

*mean*	9798.000
σ	0.000
min	9798.000
max	9798.000

*mean*	137.127
σ	4.496
min	128.612
max	144.522

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

*mean*	5218.100
σ	2576.494
min	1268.000
max	8618.000

*mean*	9732.607
σ	2174.568
min	6670.918
max	12125.881

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.732
σ	0.001
min	14060.731
max	14060.735

*mean*	9798.000
σ	0.000
min	9798.000
max	9798.000

*mean*	6829.666
σ	1691.151
min	5450.345
max	9508.461

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

*mean*	4119.158
σ	1176.482
min	3521.167
max	7062.576

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.580
σ	0.002
min	2524.579
max	2524.583

*mean*	9798.000
σ	0.000
min	9798.000
max	9798.000

*mean*	1087.360
σ	142.831
min	1033.003
max	1493.621

iterations=10

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.667
σ	0.419
min	8744.534
max	8745.858

*mean*	4843.800
σ	2510.168
min	1046.000
max	8618.000

*mean*	4590.232
σ	1354.761
min	3538.389
max	7460.601

iterations=10

operation_display=load_product()with indexes

rows=200000

*mean*	8744.532
σ	0.002
min	8744.530
max	8744.535

*mean*	8618.000
σ	0.000
min	8618.000
max	8618.000

*mean*	4427.384
σ	1527.985
min	3515.349
max	7800.084

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

*mean*	14.498
σ	0.910
min	12.797
max	15.586

iterations=10

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.901
σ	0.002
min	41.900
max	41.903

*mean*	9798.000
σ	0.000
min	9798.000
max	9798.000

*mean*	13.811
σ	0.770
min	12.454
max	14.874

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	41.901
σ	0.002
min	41.899
max	41.903

*mean*	8736.000
σ	373.149
min	8618.000
max	9798.000

*mean*	12.764
σ	1.599
min	11.395
max	15.615

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*	8736.000
σ	373.149
min	8618.000
max	9798.000

*mean*	9359.534
σ	2257.817
min	6612.497
max	12439.613

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*	5218.100
σ	2576.494
min	1268.000
max	8618.000

*mean*	7.002
σ	0.725
min	5.818
max	8.365

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*	8736.000
σ	373.149
min	8618.000
max	9798.000

*mean*	6.927
σ	0.275
min	6.477
max	7.383

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

*mean*	26.398
σ	0.000
min	26.398
max	26.398

*mean*	9798.000
σ	0.000
min	9798.000
max	9798.000

*mean*	8.108
σ	0.244
min	7.799
max	8.522

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

*mean*	100.717
σ	8.535
min	84.045
max	108.199

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

*mean*	100.602
σ	8.444
min	84.091
max	108.163

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

*mean*	100.814
σ	8.640
min	83.838
max	108.598

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

*mean*	100.757
σ	8.504
min	84.119
max	108.477

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*	5218.100
σ	2576.494
min	1268.000
max	8618.000

*mean*	9.718
σ	0.597
min	8.838
max	10.235

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*	8736.000
σ	373.149
min	8618.000
max	9798.000

*mean*	9.045
σ	0.515
min	8.301
max	9.890

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

*mean*	9433.384
σ	1993.975
min	6562.324
max	12295.147

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*	8736.000
σ	373.149
min	8618.000
max	9798.000

*mean*	5.332
σ	0.175
min	5.122
max	5.704

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*	8736.000
σ	373.149
min	8618.000
max	9798.000

*mean*	5.233
σ	0.243
min	4.955
max	5.815

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*	8736.000
σ	373.149
min	8618.000
max	9798.000

*mean*	5.169
σ	0.207
min	4.907
max	5.617

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*	8736.000
σ	373.149
min	8618.000
max	9798.000

*mean*	5.120
σ	0.198
min	4.848
max	5.325

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

*mean*	282.577
σ	411.520
min	129.101
max	1453.287

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

*mean*	184.136
σ	102.383
min	130.226
max	473.428

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*	378.536
σ	24.825
min	343.174
max	414.525

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*	738.127
σ	52.515
min	635.720
max	784.652