f67721b547d9fa602530911f6be5e9f8ebb08d52

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

*mean*	13.060
σ	0.284
min	12.702
max	13.390

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.614
σ	0.001
min	36.613
max	36.617

*mean*	9649.000
σ	0.000
min	9649.000
max	9649.000

*mean*	12.933
σ	0.647
min	11.882
max	13.577

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*	5177.400
σ	2668.596
min	1293.000
max	9649.000

*mean*	117.269
σ	56.971
min	79.905
max	276.390

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.664
σ	0.002
min	70.662
max	70.667

*mean*	9649.000
σ	0.000
min	9649.000
max	9649.000

*mean*	132.888
σ	8.069
min	119.502
max	144.804

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*	5174.600
σ	2671.910
min	1293.000
max	9649.000

*mean*	9792.627
σ	2448.559
min	6635.382
max	12598.286

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.732
σ	0.002
min	14060.730
max	14060.736

*mean*	9649.000
σ	0.000
min	9649.000
max	9649.000

*mean*	7084.699
σ	1937.103
min	5437.619
max	11155.922

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.667
σ	0.418
min	8744.535
max	8745.857

*mean*	4561.200
σ	2522.344
min	1047.000
max	8012.000

*mean*	4339.020
σ	1397.777
min	3491.743
max	7368.062

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.581
σ	0.002
min	2524.579
max	2524.583

*mean*	9649.000
σ	0.000
min	9649.000
max	9649.000

*mean*	1230.730
σ	417.443
min	1024.457
max	2177.783

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	41.901
σ	0.002
min	41.899
max	41.904

*mean*	9649.000
σ	0.000
min	9649.000
max	9649.000

*mean*	13.293
σ	1.800
min	10.993
max	15.366

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	41.901
σ	0.002
min	41.899
max	41.903

*mean*	9649.000
σ	0.000
min	9649.000
max	9649.000

*mean*	13.824
σ	1.738
min	11.340
max	16.351

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

*mean*	8816.440
σ	1972.257
min	6558.185
max	12331.498

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*	5177.400
σ	2668.596
min	1293.000
max	9649.000

*mean*	7.038
σ	0.365
min	6.391
max	7.629

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

*mean*	88.051
σ	18.260
min	62.280
max	106.758

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

*mean*	87.992
σ	18.502
min	62.257
max	107.263

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

*mean*	183.470
σ	295.738
min	62.090
max	1023.743

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

*mean*	88.769
σ	17.792
min	62.213
max	107.360

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*	5177.400
σ	2668.596
min	1293.000
max	9649.000

*mean*	9.361
σ	0.670
min	8.601
max	10.548

iterations=10

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

rows=200000

*mean*	27.602
σ	0.001
min	27.602
max	27.605

*mean*	9649.000
σ	0.000
min	9649.000
max	9649.000

*mean*	9.162
σ	0.506
min	8.013
max	9.762

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

*mean*	10207.455
σ	2090.348
min	6515.049
max	12344.034

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

*mean*	5.161
σ	0.308
min	4.954
max	6.006

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

*mean*	5.054
σ	0.125
min	4.893
max	5.261

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

*mean*	5.059
σ	0.194
min	4.815
max	5.464

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

*mean*	5.015
σ	0.075
min	4.900
max	5.147

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

*mean*	136.055
σ	24.148
min	101.499
max	161.504

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

*mean*	136.632
σ	24.905
min	101.852
max	163.061

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.800
σ	0.422
min	473.000
max	474.000

*mean*	380.709
σ	35.724
min	304.246
max	404.108

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	558.800
σ	0.632
min	557.000
max	559.000

*mean*	775.344
σ	30.215
min	701.419
max	809.426