df13f4e6565af60c59f5382e19fa9ac699844ec3

CSV benchmark: ci/scenario

Factor

allocated MiB

peak allocated MiB

time_s

iterations=10

operation_display=load_product()

rows=200000

scenario_id=ci/scenario

step_id=load_product

*mean*	8703.709
σ	1.519
min	8703.228
max	8708.032

*mean*	554.825
σ	139.139
min	192.240
max	710.000

*mean*	4.246
σ	1.432
min	3.475
max	7.260

iterations=10

operation_display=table_records()

rows=200000

scenario_id=ci/scenario

step_id=table_records

*mean*	15014.488
σ	3.945
min	15013.239
max	15025.715

*mean*	784.288
σ	367.107
min	245.000
max	1343.000

*mean*	8.599
σ	1.961
min	6.507
max	11.807

iterations=10

operation_display=table_records(), repeat

rows=200000

scenario_id=ci/scenario

step_id=table_records.repeat

*mean*	44.821
σ	0.001
min	44.820
max	44.824

*mean*	0.102
σ	0.003
min	0.093
max	0.104

*mean*	0.015
σ	0.002
min	0.012
max	0.017

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=ci/scenario

step_id=vertical_lookup_list.indexed

*mean*	26.598
σ	0.003
min	26.597
max	26.606

*mean*	24.566
σ	0.001
min	24.566
max	24.568

*mean*	0.008
σ	0.000
min	0.007
max	0.008

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=ci/scenario

step_id=vertical_lookup_list.indexed.repeat

*mean*	26.573
σ	0.000
min	26.573
max	26.573

*mean*	0.242
σ	0.000
min	0.242
max	0.242

*mean*	0.007
σ	0.000
min	0.006
max	0.007

CSV benchmark: mixed_indexes/benchmark_one

Factor

allocated MiB

peak allocated MiB

time_s

iterations=10

operation_display=load_product()

rows=200000

scenario_id=mixed_indexes/benchmark_one

step_id=load_product

*mean*	8702.947
σ	0.355
min	8702.831
max	8703.958

*mean*	583.660
σ	368.280
min	116.792
max	1391.879

*mean*	4.377
σ	1.093
min	3.456
max	6.537

iterations=10

operation_display=table_records()

rows=200000

scenario_id=mixed_indexes/benchmark_one

step_id=table_records

*mean*	15013.241
σ	0.004
min	15013.239
max	15013.251

*mean*	1255.148
σ	1475.081
min	41.077
max	5296.909

*mean*	9.932
σ	1.976
min	6.473
max	11.916

iterations=10

operation_display=table_records(), repeat

rows=200000

scenario_id=mixed_indexes/benchmark_one

step_id=table_records.repeat

*mean*	44.820
σ	0.000
min	44.820
max	44.821

*mean*	0.102
σ	0.003
min	0.093
max	0.104

*mean*	0.016
σ	0.001
min	0.015
max	0.017

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=mixed_indexes/benchmark_one

step_id=vertical_lookup_list.indexed

*mean*	26.597
σ	0.000
min	26.597
max	26.597

*mean*	24.566
σ	0.000
min	24.566
max	24.566

*mean*	0.008
σ	0.000
min	0.007
max	0.008

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=mixed_indexes/benchmark_one

step_id=vertical_lookup_list.indexed.repeat

*mean*	26.573
σ	0.000
min	26.573
max	26.573

*mean*	0.242
σ	0.000
min	0.242
max	0.242

*mean*	0.007
σ	0.000
min	0.007
max	0.007

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

scenario_id=mixed_indexes/benchmark_one

step_id=vertical_lookup_row_list.two_indexed

*mean*	25.947
σ	0.001
min	25.947
max	25.949

*mean*	0.038
σ	0.000
min	0.038
max	0.039

*mean*	0.005
σ	0.000
min	0.005
max	0.005

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

scenario_id=mixed_indexes/benchmark_one

step_id=vertical_lookup_row_list.two_indexed.repeat

*mean*	25.545
σ	0.000
min	25.545
max	25.546

*mean*	0.039
σ	0.000
min	0.038
max	0.039

*mean*	0.005
σ	0.000
min	0.005
max	0.005

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

scenario_id=mixed_indexes/benchmark_one

step_id=vertical_lookup_row_list.three_one_unindexed

*mean*	25.739
σ	0.001
min	25.738
max	25.740

*mean*	0.042
σ	0.000
min	0.042
max	0.043

*mean*	0.005
σ	0.000
min	0.005
max	0.006

iterations=10

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

rows=200000

scenario_id=mixed_indexes/benchmark_one

step_id=vertical_lookup_row_list.three_one_unindexed.repeat

*mean*	25.736
σ	0.001
min	25.736
max	25.737

*mean*	0.046
σ	0.000
min	0.046
max	0.046

*mean*	0.005
σ	0.000
min	0.005
max	0.006

CSV benchmark: mixed_indexes/benchmark_three

Factor

allocated MiB

peak allocated MiB

time_s

iterations=10

operation_display=column_set() on indexed

rows=200000

scenario_id=mixed_indexes/benchmark_three

step_id=column_set.indexed

*mean*	29.709
σ	0.000
min	29.709
max	29.709

*mean*	0.297
σ	0.000
min	0.297
max	0.297

*mean*	0.009
σ	0.000
min	0.009
max	0.010

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

scenario_id=mixed_indexes/benchmark_three

step_id=column_set.indexed.repeat

*mean*	30.491
σ	0.001
min	30.491
max	30.494

*mean*	24.567
σ	0.001
min	24.567
max	24.568

*mean*	0.009
σ	0.000
min	0.008
max	0.009

iterations=10

operation_display=load_product()

rows=200000

scenario_id=mixed_indexes/benchmark_three

step_id=load_product

*mean*	8707.619
σ	0.340
min	8707.510
max	8708.587

*mean*	602.422
σ	257.636
min	92.953
max	1007.799

*mean*	4.702
σ	1.389
min	3.480
max	6.627

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=mixed_indexes/benchmark_three

step_id=vertical_lookup_list.indexed

*mean*	14994.377
σ	0.044
min	14994.252
max	14994.397

*mean*	1273.071
σ	1130.651
min	193.802
max	4316.242

*mean*	9.547
σ	2.357
min	6.474
max	12.190

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=mixed_indexes/benchmark_three

step_id=vertical_lookup_list.indexed.repeat

*mean*	29.470
σ	0.000
min	29.469
max	29.470

*mean*	25.837
σ	0.000
min	25.837
max	25.837

*mean*	0.010
σ	0.000
min	0.010
max	0.010

CSV benchmark: no_indexes/benchmark_two

Factor

allocated MiB

peak allocated MiB

time_s

iterations=10

operation_display=column_set() on unindexed

rows=200000

scenario_id=no_indexes/benchmark_two

step_id=column_set.unindexed

*mean*	13979.330
σ	0.048
min	13979.272
max	13979.394

*mean*	1045.114
σ	1600.973
min	2.557
max	5494.704

*mean*	7.655
σ	1.837
min	5.345
max	10.911

iterations=10

operation_display=column_set() on unindexed, repeat

rows=200000

scenario_id=no_indexes/benchmark_two

step_id=column_set.unindexed.repeat

*mean*	65.873
σ	0.050
min	65.805
max	65.933

*mean*	30.908
σ	0.016
min	30.893
max	30.923

*mean*	0.127
σ	0.009
min	0.113
max	0.143

iterations=10

operation_display=load_product()

rows=200000

scenario_id=no_indexes/benchmark_two

step_id=load_product

*mean*	2525.081
σ	0.109
min	2525.045
max	2525.393

*mean*	380.968
σ	315.499
min	241.332
max	1262.108

*mean*	1.434
σ	0.658
min	1.013
max	2.704

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

scenario_id=no_indexes/benchmark_two

step_id=vertical_lookup_list.unindexed.missing_int

*mean*	40.976
σ	0.001
min	40.975
max	40.978

*mean*	26.693
σ	0.000
min	26.693
max	26.694

*mean*	0.089
σ	0.015
min	0.066
max	0.107

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

scenario_id=no_indexes/benchmark_two

step_id=vertical_lookup_list.unindexed.missing_int.repeat

*mean*	40.976
σ	0.001
min	40.975
max	40.978

*mean*	26.693
σ	0.000
min	26.693
max	26.694

*mean*	0.089
σ	0.015
min	0.066
max	0.106

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

scenario_id=no_indexes/benchmark_two

step_id=vertical_lookup_list.unindexed.tail_unique_int

*mean*	40.910
σ	0.001
min	40.909
max	40.912

*mean*	29.083
σ	0.000
min	29.083
max	29.084

*mean*	0.089
σ	0.014
min	0.067
max	0.106

iterations=10

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

rows=200000

scenario_id=no_indexes/benchmark_two

step_id=vertical_lookup_list.unindexed.tail_unique_int.repeat

*mean*	40.982
σ	0.001
min	40.980
max	40.984

*mean*	26.693
σ	0.000
min	26.692
max	26.693

*mean*	0.089
σ	0.014
min	0.067
max	0.107

iterations=10

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

scenario_id=no_indexes/benchmark_two

step_id=vertical_lookup_row_list.unindexed.small_unique_int

*mean*	67.549
σ	0.001
min	67.548
max	67.549

*mean*	49.992
σ	0.002
min	49.986
max	49.994

*mean*	0.139
σ	0.021
min	0.107
max	0.166

iterations=10

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

rows=200000

scenario_id=no_indexes/benchmark_two

step_id=vertical_lookup_row_list.unindexed.small_unique_int.repeat

*mean*	66.704
σ	0.002
min	66.702
max	66.706

*mean*	49.318
σ	0.003
min	49.314
max	49.322

*mean*	0.143
σ	0.020
min	0.112
max	0.169

Internal benchmark: pointedIndexFromKvs

Factor

time_s

benchmark=pointed_index_from_kvs

iterations=10

rows=400000

*mean*	0.644
σ	0.235
min	0.304
max	0.831