1ac86c718ca099bdc11c7da26069efc6ead140b8

CSV benchmark: catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

Factor

allocated MiB

peak allocated MiB

time_s

iterations=5

operation_display=column_set() on area_code (indexed)

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=column_set.area_code

*mean*	228.201
σ	0.006
min	228.191
max	228.205

*mean*	41.646
σ	0.422
min	40.931
max	41.979

*mean*	0.119
σ	0.001
min	0.117
max	0.120

iterations=5

operation_display=column_set() on area_code (indexed), repeat

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=column_set.area_code.repeat

*mean*	0.000
σ	0.000
min	0.000
max	0.000

*mean*	0.000
σ	0.000
min	0.000
max	0.000

*mean*	0.001
σ	0.000
min	0.001
max	0.001

iterations=5

operation_display=column_set() on dpx_subarea_name (no index)

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=column_set.dpx_subarea_name

*mean*	9.567
σ	0.002
min	9.564
max	9.569

*mean*	1.467
σ	0.192
min	1.189
max	1.645

*mean*	0.009
σ	0.000
min	0.008
max	0.009

iterations=5

operation_display=column_set() on dpx_subarea_name (no index), repeat

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=column_set.dpx_subarea_name.repeat

*mean*	6.495
σ	2.174
min	4.906
max	8.877

*mean*	0.759
σ	0.310
min	0.405
max	1.078

*mean*	0.007
σ	0.000
min	0.007
max	0.008

iterations=5

operation_display=load_product()

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=load_product

*mean*	178.437
σ	0.521
min	177.725
max	178.956

*mean*	21.910
σ	4.215
min	14.371
max	23.925

*mean*	0.082
σ	0.000
min	0.082
max	0.083

iterations=5

operation_display=vertical_lookup_list() on area_code (indexed)

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=vertical_lookup_list.area_code

*mean*	1.122
σ	2.509
min	0.000
max	5.610

*mean*	0.015
σ	0.033
min	0.000
max	0.074

*mean*	0.001
σ	0.000
min	0.001
max	0.002

iterations=5

operation_display=vertical_lookup_list() on area_code (indexed), repeat

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=vertical_lookup_list.area_code.repeat

*mean*	0.000
σ	0.000
min	0.000
max	0.000

*mean*	0.000
σ	0.000
min	0.000
max	0.000

*mean*	0.001
σ	0.000
min	0.000
max	0.001

iterations=5

operation_display=vertical_lookup_list() on dpx_subarea_code (no index)

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=vertical_lookup_list.dpx_subarea_code

*mean*	2.457
σ	2.243
min	0.000
max	4.096

*mean*	0.553
σ	0.505
min	0.000
max	0.932

*mean*	0.005
σ	0.001
min	0.004
max	0.005

iterations=5

operation_display=vertical_lookup_list() on dpx_subarea_code (no index), repeat

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=vertical_lookup_list.dpx_subarea_code.repeat

*mean*	4.281
σ	2.406
min	0.000
max	5.516

*mean*	0.482
σ	0.380
min	0.000
max	0.848

*mean*	0.004
σ	0.000
min	0.003
max	0.004

iterations=5

operation_display=vertical_lookup_row_list() on area + subarea code (both indexed)

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=vertical_lookup_row_list.area.subarea

*mean*	2.340
σ	3.211
min	0.000
max	6.144

*mean*	0.111
σ	0.188
min	0.000
max	0.435

*mean*	0.001
σ	0.001
min	0.000
max	0.002

iterations=5

operation_display=vertical_lookup_row_list() on area + subarea code (both indexed), repeat

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=vertical_lookup_row_list.area.subarea.repeat

*mean*	3.769
σ	3.445
min	0.000
max	6.569

*mean*	0.351
σ	0.328
min	0.000
max	0.663

*mean*	0.001
σ	0.001
min	0.000
max	0.002

CSV benchmark: ci/scenario_aon

Factor

allocated MiB

peak allocated MiB

time_s

iterations=5

operation_display=column_set() on area_code (indexed)

rows=15894

scenario_id=ci/scenario_aon

step_id=column_set.area_code

*mean*	228.997
σ	1.770
min	228.190
max	232.162

*mean*	22.790
σ	15.801
min	6.612
max	43.000

*mean*	0.256
σ	0.079
min	0.153
max	0.345

iterations=5

operation_display=column_set() on dpx_subarea_name (no index)

rows=15894

scenario_id=ci/scenario_aon

step_id=column_set.dpx_subarea_name

*mean*	8.092
σ	1.778
min	4.911
max	8.891

*mean*	1.409
σ	0.190
min	1.196
max	1.626

*mean*	0.012
σ	0.003
min	0.009
max	0.016

iterations=5

operation_display=load_product()

rows=15894

scenario_id=ci/scenario_aon

step_id=load_product

*mean*	178.221
σ	0.315
min	177.665
max	178.401

*mean*	23.212
σ	8.062
min	14.678
max	36.000

*mean*	0.152
σ	0.053
min	0.083
max	0.219

iterations=5

operation_display=vertical_lookup_row_list() on area + subarea code (both indexed)

rows=15894

scenario_id=ci/scenario_aon

step_id=vertical_lookup_row_list.area.subarea

*mean*	0.819
σ	1.832
min	0.000
max	4.097

*mean*	0.182
σ	0.407
min	0.000
max	0.911

*mean*	0.001
σ	0.001
min	0.001
max	0.002

CSV benchmark: ci/scenario_synthetic

Factor

allocated MiB

peak allocated MiB

time_s

iterations=5

operation_display=load_product()

rows=200000

scenario_id=ci/scenario_synthetic

step_id=load_product

*mean*	8291.534
σ	0.208
min	8291.165
max	8291.654

*mean*	442.361
σ	59.883
min	386.000
max	539.148

*mean*	4.335
σ	1.452
min	3.309
max	6.827

iterations=5

operation_display=table_records()

rows=200000

scenario_id=ci/scenario_synthetic

step_id=table_records

*mean*	14174.861
σ	5.039
min	14172.579
max	14183.875

*mean*	427.200
σ	154.527
min	188.000
max	613.000

*mean*	9.654
σ	1.735
min	7.655
max	11.159

iterations=5

operation_display=table_records(), repeat

rows=200000

scenario_id=ci/scenario_synthetic

step_id=table_records.repeat

*mean*	27.916
σ	0.000
min	27.915
max	27.916

*mean*	0.102
σ	0.000
min	0.102
max	0.103

*mean*	0.009
σ	0.001
min	0.008
max	0.010

iterations=5

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=ci/scenario_synthetic

step_id=vertical_lookup_list.indexed

*mean*	19.579
σ	0.002
min	19.577
max	19.581

*mean*	12.111
σ	0.001
min	12.110
max	12.112

*mean*	0.020
σ	0.001
min	0.019
max	0.022

iterations=5

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=ci/scenario_synthetic

step_id=vertical_lookup_list.indexed.repeat

*mean*	13.288
σ	0.002
min	13.286
max	13.290

*mean*	9.265
σ	0.001
min	9.264
max	9.265

*mean*	0.009
σ	0.001
min	0.007
max	0.010

CSV benchmark: synthetic/mixed_indexes/benchmark_one

Factor

allocated MiB

peak allocated MiB

time_s

iterations=5

operation_display=load_product()

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=load_product

*mean*	8287.852
σ	0.068
min	8287.795
max	8287.964

*mean*	372.307
σ	194.433
min	106.411
max	548.315

*mean*	4.606
σ	1.398
min	3.267
max	6.556

iterations=5

operation_display=table_records()

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=table_records

*mean*	14172.603
σ	0.032
min	14172.576
max	14172.639

*mean*	796.225
σ	892.051
min	161.774
max	2263.084

*mean*	9.691
σ	2.163
min	6.424
max	11.519

iterations=5

operation_display=table_records(), repeat

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=table_records.repeat

*mean*	27.915
σ	0.000
min	27.915
max	27.916

*mean*	0.102
σ	0.000
min	0.102
max	0.102

*mean*	0.010
σ	0.002
min	0.008
max	0.012

iterations=5

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=vertical_lookup_list.indexed

*mean*	19.579
σ	0.002
min	19.577
max	19.581

*mean*	12.111
σ	0.001
min	12.110
max	12.112

*mean*	0.021
σ	0.002
min	0.018
max	0.022

iterations=5

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=vertical_lookup_list.indexed.repeat

*mean*	13.288
σ	0.002
min	13.286
max	13.290

*mean*	9.264
σ	0.001
min	9.264
max	9.265

*mean*	0.009
σ	0.001
min	0.008
max	0.009

iterations=5

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=vertical_lookup_row_list.two_indexed

*mean*	14.216
σ	0.003
min	14.213
max	14.218

*mean*	0.052
σ	0.000
min	0.052
max	0.052

*mean*	0.004
σ	0.000
min	0.004
max	0.004

iterations=5

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=vertical_lookup_row_list.two_indexed.repeat

*mean*	10.447
σ	0.002
min	10.445
max	10.449

*mean*	0.120
σ	0.001
min	0.119
max	0.120

*mean*	0.003
σ	0.000
min	0.003
max	0.003

iterations=5

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=vertical_lookup_row_list.three_one_unindexed

*mean*	10.738
σ	0.008
min	10.733
max	10.751

*mean*	0.047
σ	0.002
min	0.046
max	0.050

*mean*	0.004
σ	0.000
min	0.004
max	0.004

iterations=5

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

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=vertical_lookup_row_list.three_one_unindexed.repeat

*mean*	10.776
σ	0.004
min	10.774
max	10.782

*mean*	0.041
σ	0.002
min	0.040
max	0.044

*mean*	0.004
σ	0.000
min	0.003
max	0.004

CSV benchmark: synthetic/mixed_indexes/benchmark_three

Factor

allocated MiB

peak allocated MiB

time_s

iterations=5

operation_display=column_set() on indexed

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_three

step_id=column_set.indexed

*mean*	13.995
σ	0.002
min	13.993
max	13.997

*mean*	0.050
σ	0.000
min	0.050
max	0.050

*mean*	0.004
σ	0.000
min	0.004
max	0.004

iterations=5

operation_display=column_set() on indexed, repeat

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_three

step_id=column_set.indexed.repeat

*mean*	11.065
σ	0.002
min	11.063
max	11.067

*mean*	0.090
σ	0.001
min	0.089
max	0.091

*mean*	0.003
σ	0.000
min	0.003
max	0.003

iterations=5

operation_display=load_product()

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_three

step_id=load_product

*mean*	8288.893
σ	0.469
min	8288.626
max	8289.729

*mean*	428.167
σ	575.074
min	140.173
max	1455.125

*mean*	5.743
σ	1.006
min	4.066
max	6.672

iterations=5

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_three

step_id=vertical_lookup_list.indexed

*mean*	14169.695
σ	0.037
min	14169.669
max	14169.759

*mean*	412.479
σ	376.031
min	14.785
max	1026.384

*mean*	10.772
σ	0.405
min	10.214
max	11.341

iterations=5

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_three

step_id=vertical_lookup_list.indexed.repeat

*mean*	10.582
σ	0.000
min	10.582
max	10.582

*mean*	9.177
σ	0.000
min	9.177
max	9.177

*mean*	0.009
σ	0.000
min	0.008
max	0.009

CSV benchmark: synthetic/no_indexes/benchmark_two

Factor

allocated MiB

peak allocated MiB

time_s

iterations=5

operation_display=column_set() on unindexed

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=column_set.unindexed

*mean*	13232.162
σ	1.551
min	13229.387
max	13232.856

*mean*	118.559
σ	95.979
min	16.973
max	264.322

*mean*	9.197
σ	1.321
min	7.358
max	10.476

iterations=5

operation_display=column_set() on unindexed, repeat

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=column_set.unindexed.repeat

*mean*	45.830
σ	1.554
min	45.135
max	48.610

*mean*	14.887
σ	0.003
min	14.882
max	14.888

*mean*	0.105
σ	0.009
min	0.096
max	0.117

iterations=5

operation_display=load_product()

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=load_product

*mean*	2463.969
σ	0.218
min	2463.871
max	2464.360

*mean*	633.302
σ	1068.837
min	21.668
max	2540.211

*mean*	1.322
σ	0.472
min	1.016
max	2.104

iterations=5

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=vertical_lookup_list.unindexed.missing_int

*mean*	25.814
σ	0.002
min	25.812
max	25.816

*mean*	11.388
σ	0.000
min	11.387
max	11.388

*mean*	0.079
σ	0.018
min	0.062
max	0.098

iterations=5

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

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=vertical_lookup_list.unindexed.missing_int.repeat

*mean*	25.809
σ	0.000
min	25.809
max	25.810

*mean*	11.388
σ	0.000
min	11.388
max	11.388

*mean*	0.079
σ	0.018
min	0.062
max	0.098

iterations=5

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=vertical_lookup_list.unindexed.tail_unique_int

*mean*	26.605
σ	0.001
min	26.605
max	26.606

*mean*	13.778
σ	0.000
min	13.778
max	13.779

*mean*	0.079
σ	0.018
min	0.063
max	0.099

iterations=5

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

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=vertical_lookup_list.unindexed.tail_unique_int.repeat

*mean*	25.817
σ	0.001
min	25.816
max	25.818

*mean*	11.388
σ	0.000
min	11.388
max	11.388

*mean*	0.079
σ	0.018
min	0.062
max	0.098

iterations=5

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=vertical_lookup_row_list.unindexed.small_unique_int

*mean*	52.364
σ	0.000
min	52.364
max	52.364

*mean*	34.688
σ	0.000
min	34.687
max	34.688

*mean*	0.128
σ	0.023
min	0.107
max	0.154

iterations=5

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

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=vertical_lookup_row_list.unindexed.small_unique_int.repeat

*mean*	51.521
σ	0.000
min	51.521
max	51.521

*mean*	34.019
σ	0.000
min	34.019
max	34.019

*mean*	0.132
σ	0.023
min	0.112
max	0.157

Internal benchmark: pointedIndexFromKvs

Factor

time_s

benchmark=pointed_index_from_kvs

iterations=5

rows=400000

*mean*	0.797
σ	0.052
min	0.721
max	0.860