7e468e84807ce467db69d7f8bf3a413bee08ffca

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.206
σ	0.007
min	228.198
max	228.215

*mean*	41.634
σ	0.413
min	40.936
max	41.976

*mean*	0.119
σ	0.001
min	0.118
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.585
σ	0.003
min	9.581
max	9.590

*mean*	1.491
σ	0.171
min	1.249
max	1.644

*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.500
σ	2.175
min	4.910
max	8.884

*mean*	0.703
σ	0.263
min	0.414
max	1.072

*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.441
σ	0.526
min	177.725
max	178.962

*mean*	21.897
σ	4.210
min	14.368
max	23.901

*mean*	0.083
σ	0.000
min	0.083
max	0.084

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*	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=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.000
σ	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.446
σ	2.233
min	0.000
max	4.103

*mean*	0.555
σ	0.507
min	0.000
max	0.930

*mean*	0.004
σ	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*	5.390
σ	0.254
min	4.937
max	5.536

*mean*	0.655
σ	0.298
min	0.149
max	0.925

*mean*	0.004
σ	0.000
min	0.004
max	0.005

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.356
σ	3.232
min	0.000
max	6.169

*mean*	0.104
σ	0.175
min	0.000
max	0.404

*mean*	0.001
σ	0.001
min	0.000
max	0.001

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.711
σ	3.387
min	0.000
max	6.207

*mean*	0.354
σ	0.334
min	0.000
max	0.708

*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*	229.005
σ	1.770
min	228.204
max	232.172

*mean*	26.251
σ	13.843
min	10.256
max	44.000

*mean*	0.257
σ	0.086
min	0.142
max	0.351

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.099
σ	1.778
min	4.919
max	8.896

*mean*	1.413
σ	0.191
min	1.197
max	1.624

*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.226
σ	0.317
min	177.666
max	178.404

*mean*	20.890
σ	10.948
min	6.788
max	36.000

*mean*	0.159
σ	0.053
min	0.083
max	0.228

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.821
σ	1.836
min	0.000
max	4.105

*mean*	0.181
σ	0.405
min	0.000
max	0.906

*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.539
σ	0.181
min	8291.218
max	8291.654

*mean*	519.470
σ	210.324
min	388.000
max	890.000

*mean*	4.981
σ	1.432
min	3.585
max	7.065

iterations=5

operation_display=table_records()

rows=200000

scenario_id=ci/scenario_synthetic

step_id=table_records

*mean*	14174.878
σ	5.035
min	14172.588
max	14183.885

*mean*	518.619
σ	333.618
min	107.291
max	1023.802

*mean*	9.890
σ	1.415
min	7.639
max	11.200

iterations=5

operation_display=table_records(), repeat

rows=200000

scenario_id=ci/scenario_synthetic

step_id=table_records.repeat

*mean*	27.925
σ	0.000
min	27.925
max	27.926

*mean*	0.103
σ	0.000
min	0.102
max	0.103

*mean*	0.009
σ	0.001
min	0.008
max	0.011

iterations=5

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=ci/scenario_synthetic

step_id=vertical_lookup_list.indexed

*mean*	19.589
σ	0.003
min	19.586
max	19.592

*mean*	51.074
σ	87.124
min	12.110
max	206.927

*mean*	0.034
σ	0.032
min	0.018
max	0.092

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.299
σ	0.003
min	13.296
max	13.302

*mean*	9.264
σ	0.001
min	9.263
max	9.265

*mean*	0.009
σ	0.001
min	0.008
max	0.011

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.854
σ	0.065
min	8287.801
max	8287.962

*mean*	315.595
σ	211.781
min	105.449
max	548.314

*mean*	4.533
σ	1.193
min	3.333
max	5.955

iterations=5

operation_display=table_records()

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=table_records

*mean*	14172.613
σ	0.031
min	14172.589
max	14172.648

*mean*	528.707
σ	678.908
min	49.866
max	1722.042

*mean*	9.578
σ	2.326
min	6.369
max	11.535

iterations=5

operation_display=table_records(), repeat

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=table_records.repeat

*mean*	27.925
σ	0.000
min	27.925
max	27.926

*mean*	0.102
σ	0.000
min	0.101
max	0.103

*mean*	0.010
σ	0.001
min	0.009
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.589
σ	0.002
min	19.587
max	19.591

*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.298
σ	0.002
min	13.296
max	13.300

*mean*	9.264
σ	0.001
min	9.264
max	9.265

*mean*	0.009
σ	0.001
min	0.008
max	0.010

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.226
σ	0.003
min	14.223
max	14.228

*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.457
σ	0.002
min	10.456
max	10.460

*mean*	0.120
σ	0.000
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.748
σ	0.007
min	10.743
max	10.761

*mean*	0.046
σ	0.002
min	0.045
max	0.050

*mean*	0.004
σ	0.000
min	0.003
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.787
σ	0.003
min	10.784
max	10.792

*mean*	0.041
σ	0.002
min	0.040
max	0.044

*mean*	0.003
σ	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*	14.005
σ	0.002
min	14.002
max	14.007

*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.075
σ	0.002
min	11.073
max	11.077

*mean*	0.090
σ	0.001
min	0.089
max	0.090

*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.894
σ	0.468
min	8288.627
max	8289.729

*mean*	620.986
σ	536.200
min	67.054
max	1512.929

*mean*	4.487
σ	1.101
min	3.347
max	5.965

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.705
σ	0.035
min	14169.678
max	14169.766

*mean*	291.860
σ	421.535
min	7.641
max	1026.578

*mean*	11.174
σ	0.544
min	10.543
max	11.821

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.593
σ	0.002
min	10.592
max	10.596

*mean*	9.177
σ	0.000
min	9.176
max	9.177

*mean*	0.010
σ	0.001
min	0.008
max	0.011

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.172
σ	1.549
min	13229.401
max	13232.866

*mean*	531.809
σ	940.134
min	4.740
max	2204.184

*mean*	9.192
σ	1.072
min	7.396
max	10.174

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.840
σ	1.554
min	45.145
max	48.620

*mean*	14.887
σ	0.003
min	14.882
max	14.888

*mean*	0.105
σ	0.010
min	0.096
max	0.120

iterations=5

operation_display=load_product()

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=load_product

*mean*	2463.969
σ	0.215
min	2463.872
max	2464.353

*mean*	167.065
σ	73.706
min	35.301
max	201.543

*mean*	1.217
σ	0.402
min	1.025
max	1.936

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.823
σ	0.001
min	25.823
max	25.824

*mean*	11.388
σ	0.000
min	11.387
max	11.388

*mean*	0.077
σ	0.020
min	0.059
max	0.103

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.820
σ	0.002
min	25.819
max	25.823

*mean*	11.388
σ	0.000
min	11.388
max	11.388

*mean*	0.077
σ	0.020
min	0.059
max	0.104

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.615
σ	0.001
min	26.615
max	26.617

*mean*	13.778
σ	0.000
min	13.778
max	13.779

*mean*	0.078
σ	0.020
min	0.059
max	0.104

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.827
σ	0.001
min	25.826
max	25.828

*mean*	11.388
σ	0.000
min	11.388
max	11.388

*mean*	0.078
σ	0.020
min	0.060
max	0.103

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.374
σ	0.000
min	52.374
max	52.375

*mean*	34.688
σ	0.000
min	34.687
max	34.688

*mean*	0.126
σ	0.027
min	0.100
max	0.161

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.531
σ	0.000
min	51.531
max	51.531

*mean*	34.019
σ	0.000
min	34.019
max	34.019

*mean*	0.129
σ	0.026
min	0.106
max	0.164

Internal benchmark: pointedIndexFromKvs

Factor

time_s

benchmark=pointed_index_from_kvs

iterations=5

rows=400000

*mean*	0.303
σ	0.002
min	0.301
max	0.306