Compare commits

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.196-228.201=-0.005
σ	0.016-0.006=0.010
min	228.178-228.191=-0.013
max	228.219-228.205=0.014

*mean*	41.516-41.646=-0.131
σ	0.196-0.422=-0.225
min	41.243-40.931=0.313
max	41.724-41.979=-0.256

*mean*	0.119-0.119=0.001
σ	0.001-0.001=0.001
min	0.118-0.117=0.001
max	0.122-0.120=0.002

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*	1.643-0.000=1.643
σ	2.250-0.000=2.250
min	0.000
max	4.109-0.000=4.109

*mean*	0.226-0.000=0.226
σ	0.310-0.000=0.310
min	0.000
max	0.575-0.000=0.575

*mean*	0.001-0.001=0.001
σ	0.001-0.000=0.001
min	0.001-0.001=0.000
max	0.002-0.001=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*	6.335-9.567=-3.233
σ	1.806-0.002=1.804
min	5.464-9.564=-4.100
max	9.563-9.569=-0.006

*mean*	1.069-1.467=-0.398
σ	0.042-0.192=-0.150
min	1.025-1.189=-0.164
max	1.116-1.645=-0.529

*mean*	0.008-0.009=-0.001
σ	0.001-0.000=0.000
min	0.007-0.008=-0.001
max	0.009-0.009=-0.000

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*	8.085-6.495=1.590
σ	1.777-2.174=-0.397
min	4.906-4.906=0.001
max	8.879-8.877=0.002

*mean*	0.293-0.759=-0.466
σ	0.443-0.310=0.133
min	0.085-0.405=-0.320
max	1.086-1.078=0.007

*mean*	0.008-0.007=0.000
σ	0.000-0.000=-0.000
min	0.007-0.007=0.001
max	0.008-0.008=0.000

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*	181.233-178.437=2.796
σ	2.956-0.521=2.435
min	177.688-177.725=-0.037
max	184.303-178.956=5.347

*mean*	23.820-21.910=1.911
σ	0.514-4.215=-3.702
min	23.241-14.371=8.871
max	24.327-23.925=0.402

*mean*	0.084-0.082=0.002
σ	0.001-0.000=0.001
min	0.082-0.082=0.001
max	0.086-0.083=0.003

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*	3.121-1.122=2.000
σ	2.860-2.509=0.351
min	0.000
max	5.601-5.610=-0.009

*mean*	0.212-0.015=0.198
σ	0.261-0.033=0.228
min	0.000
max	0.534-0.074=0.460

*mean*	0.001-0.001=0.000
σ	0.001-0.000=0.000
min	0.001-0.001=-0.000
max	0.002-0.002=0.000

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*	2.238-0.000=2.238
σ	3.065-0.000=3.065
min	0.000
max	5.597-0.000=5.597

*mean*	0.154-0.000=0.154
σ	0.281-0.000=0.281
min	0.000
max	0.648-0.000=0.648

*mean*	0.001-0.001=0.000
σ	0.001-0.000=0.001
min	0.000-0.000=-0.000
max	0.002-0.001=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*	4.617-2.457=2.160
σ	0.293-2.243=-1.950
min	4.101-0.000=4.101
max	4.788-4.096=0.692

*mean*	0.474-0.553=-0.079
σ	0.260-0.505=-0.245
min	0.286-0.000=0.286
max	0.932-0.932=0.000

*mean*	0.005-0.005=0.000
σ	0.000-0.001=-0.001
min	0.005-0.004=0.001
max	0.005-0.005=-0.000

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*	0.000-4.281=-4.281
σ	0.000-2.406=-2.406
min	0.000
max	0.000-5.516=-5.516

*mean*	0.000-0.482=-0.482
σ	0.000-0.380=-0.380
min	0.000
max	0.000-0.848=-0.848

*mean*	0.003-0.004=-0.001
σ	0.000-0.000=-0.000
min	0.003-0.003=-0.000
max	0.003-0.004=-0.001

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*	0.000-2.340=-2.340
σ	0.000-3.211=-3.211
min	0.000
max	0.000-6.144=-6.144

*mean*	0.000-0.111=-0.111
σ	0.000-0.188=-0.188
min	0.000
max	0.000-0.435=-0.435

*mean*	0.000-0.001=-0.000
σ	0.000-0.001=-0.001
min	0.000-0.000=0.000
max	0.001-0.002=-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*	0.000-3.769=-3.769
σ	0.000-3.445=-3.445
min	0.000
max	0.000-6.569=-6.569

*mean*	0.000-0.351=-0.351
σ	0.000-0.328=-0.328
min	0.000
max	0.000-0.663=-0.663

*mean*	0.000-0.001=-0.001
σ	0.000-0.001=-0.001
min	0.000-0.000=-0.000
max	0.000-0.002=-0.001

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.984-228.997=-0.013
σ	1.774-1.770=0.004
min	228.182-228.190=-0.007
max	232.157-232.162=-0.005

*mean*	26.654-22.790=3.864
σ	15.162-15.801=-0.639
min	6.618-6.612=0.006
max	42.000-43.000=-1.000

*mean*	0.271-0.256=0.016
σ	0.091-0.079=0.012
min	0.166-0.153=0.013
max	0.388-0.345=0.043

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*	5.702-8.092=-2.390
σ	1.780-1.778=0.002
min	4.893-4.911=-0.018
max	8.886-8.891=-0.005

*mean*	1.156-1.409=-0.253
σ	0.085-0.190=-0.105
min	1.068-1.196=-0.128
max	1.263-1.626=-0.363

*mean*	0.011-0.012=-0.001
σ	0.003-0.003=0.000
min	0.007-0.009=-0.002
max	0.014-0.016=-0.002

iterations=5

operation_display=load_product()

rows=15894

scenario_id=ci/scenario_aon

step_id=load_product

*mean*	178.979-178.221=0.758
σ	1.921-0.315=1.605
min	177.671-177.665=0.006
max	182.382-178.401=3.981

*mean*	26.794-23.212=3.582
σ	10.097-8.062=2.034
min	14.864-14.678=0.187
max	40.000-36.000=4.000

*mean*	0.172-0.152=0.020
σ	0.060-0.053=0.007
min	0.084-0.083=0.001
max	0.244-0.219=0.025

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*	2.457-0.819=1.637
σ	2.243-1.832=0.410
min	0.000
max	4.096-4.097=-0.001

*mean*	0.557-0.182=0.374
σ	0.508-0.407=0.101
min	0.000
max	0.938-0.911=0.027

*mean*	0.001-0.001=0.000
σ	0.001-0.001=-0.000
min	0.001-0.001=0.000
max	0.002-0.002=-0.000

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*	8715.932-8291.534=424.398
σ	0.918-0.208=0.710
min	8715.490-8291.165=424.325
max	8717.573-8291.654=425.919

*mean*	470.244-442.361=27.883
σ	85.152-59.883=25.270
min	383.000-386.000=-3.000
max	576.000-539.148=36.852

*mean*	5.395-4.335=1.060
σ	1.399-1.452=-0.053
min	3.623-3.309=0.314
max	6.984-6.827=0.157

iterations=5

operation_display=table_records()

rows=200000

scenario_id=ci/scenario_synthetic

step_id=table_records

*mean*	15164.966-14174.861=990.104
σ	5.013-5.039=-0.026
min	15162.695-14172.579=990.116
max	15173.934-14183.875=990.058

*mean*	424.800-427.200=-2.400
σ	248.925-154.527=94.398
min	94.000-188.000=-94.000
max	736.000-613.000=123.000

*mean*	11.331-9.654=1.677
σ	0.720-1.735=-1.015
min	10.680-7.655=3.026
max	12.397-11.159=1.237

iterations=5

operation_display=table_records(), repeat

rows=200000

scenario_id=ci/scenario_synthetic

step_id=table_records.repeat

*mean*	27.807-27.916=-0.109
σ	0.002-0.000=0.002
min	27.806-27.915=-0.110
max	27.810-27.916=-0.106

*mean*	0.102-0.102=-0.000
σ	0.000-0.000=-0.000
min	0.102
max	0.103-0.103=-0.000

*mean*	0.010-0.009=0.001
σ	0.002-0.001=0.001
min	0.008-0.008=0.000
max	0.013-0.010=0.003

iterations=5

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=ci/scenario_synthetic

step_id=vertical_lookup_list.indexed

*mean*	12.820-19.579=-6.760
σ	0.002-0.002=-0.000
min	12.817-19.577=-6.760
max	12.822-19.581=-6.760

*mean*	10.791-12.111=-1.321
σ	0.000-0.001=-0.000
min	10.790-12.110=-1.320
max	10.791-12.112=-1.321

*mean*	0.005-0.020=-0.014
σ	0.001-0.001=-0.000
min	0.005-0.019=-0.014
max	0.007-0.022=-0.014

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*	12.800-13.288=-0.489
σ	0.002-0.002=0.000
min	12.797-13.286=-0.489
max	12.802-13.290=-0.489

*mean*	0.242-9.265=-9.023
σ	0.000-0.001=-0.001
min	0.242-9.264=-9.022
max	0.242-9.265=-9.023

*mean*	0.005-0.009=-0.004
σ	0.001-0.001=0.000
min	0.004-0.007=-0.003
max	0.006-0.010=-0.003

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*	8715.329-8287.852=427.476
σ	0.454-0.068=0.385
min	8715.096-8287.795=427.301
max	8716.139-8287.964=428.175

*mean*	360.484-372.307=-11.824
σ	169.171-194.433=-25.262
min	213.598-106.411=107.187
max	543.643-548.315=-4.672

*mean*	4.577-4.606=-0.029
σ	1.444-1.398=0.046
min	3.434-3.267=0.167
max	6.704-6.556=0.148

iterations=5

operation_display=table_records()

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=table_records

*mean*	15162.731-14172.603=990.128
σ	0.032-0.032=-0.000
min	15162.696-14172.576=990.120
max	15162.755-14172.639=990.116

*mean*	483.582-796.225=-312.644
σ	799.077-892.051=-92.974
min	24.914-161.774=-136.859
max	1901.408-2263.084=-361.676

*mean*	9.825-9.691=0.134
σ	2.093-2.163=-0.071
min	6.700-6.424=0.276
max	12.182-11.519=0.664

iterations=5

operation_display=table_records(), repeat

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=table_records.repeat

*mean*	27.806-27.915=-0.110
σ	0.000-0.000=-0.000
min	27.806-27.915=-0.110
max	27.806-27.916=-0.110

*mean*	0.102-0.102=-0.000
σ	0.000-0.000=-0.000
min	0.102
max	0.102-0.102=-0.000

*mean*	0.009-0.010=-0.000
σ	0.002-0.002=0.000
min	0.008-0.008=0.000
max	0.013-0.012=0.001

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*	12.820-19.579=-6.760
σ	0.002-0.002=0.000
min	12.817-19.577=-6.760
max	12.821-19.581=-6.760

*mean*	10.790-12.111=-1.321
σ	0.000-0.001=-0.001
min	10.790-12.110=-1.320
max	10.790-12.112=-1.321

*mean*	0.005-0.021=-0.016
σ	0.000-0.002=-0.001
min	0.004-0.018=-0.014
max	0.005-0.022=-0.017

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*	12.799-13.288=-0.489
σ	0.002-0.002=-0.000
min	12.797-13.286=-0.489
max	12.801-13.290=-0.489

*mean*	0.242-9.264=-9.023
σ	0.000-0.001=-0.001
min	0.242-9.264=-9.022
max	0.242-9.265=-9.024

*mean*	0.004-0.009=-0.005
σ	0.000-0.001=-0.000
min	0.004-0.008=-0.004
max	0.004-0.009=-0.005

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*	12.170-14.216=-2.046
σ	0.003
min	12.167-14.213=-2.046
max	12.173-14.218=-2.046

*mean*	0.038-0.052=-0.013
σ	0.000
min	0.038-0.052=-0.013
max	0.039-0.052=-0.013

*mean*	0.003-0.004=-0.001
σ	0.000-0.000=-0.000
min	0.003-0.004=-0.001
max	0.003-0.004=-0.001

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*	11.773-10.447=1.326
σ	0.002-0.002=0.000
min	11.771-10.445=1.326
max	11.775-10.449=1.326

*mean*	0.039-0.120=-0.081
σ	0.000-0.001=-0.000
min	0.039-0.119=-0.080
max	0.039-0.120=-0.081

*mean*	0.003-0.003=-0.000
σ	0.000-0.000=0.000
min	0.003-0.003=-0.000
max	0.003-0.003=-0.000

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*	12.139-10.738=1.402
σ	0.008-0.008=-0.000
min	12.134-10.733=1.402
max	12.152-10.751=1.402

*mean*	0.047-0.047=0.000
σ	0.002-0.002=-0.000
min	0.046-0.046=0.000
max	0.050-0.050=-0.000

*mean*	0.003-0.004=-0.001
σ	0.000-0.000=-0.000
min	0.003-0.004=-0.001
max	0.003-0.004=-0.001

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*	12.138-10.776=1.361
σ	0.004-0.004=0.000
min	12.135-10.774=1.361
max	12.144-10.782=1.362

*mean*	0.041-0.041=-0.000
σ	0.002-0.002=-0.000
min	0.040
max	0.044-0.044=-0.000

*mean*	0.003-0.004=-0.001
σ	0.000-0.000=-0.000
min	0.003-0.003=-0.000
max	0.003-0.004=-0.001

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*	39.756-13.995=25.761
σ	0.002-0.002=-0.000
min	39.754-13.993=25.762
max	39.758-13.997=25.761

*mean*	46.723-0.050=46.673
σ	99.675-0.000=99.674
min	2.147-0.050=2.097
max	225.026-0.050=224.977

*mean*	0.046-0.004=0.042
σ	0.035-0.000=0.035
min	0.024-0.004=0.020
max	0.105-0.004=0.101

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*	42.759-11.065=31.694
σ	0.002-0.002=-0.000
min	42.757-11.063=31.694
max	42.761-11.067=31.693

*mean*	13.151-0.090=13.061
σ	0.001-0.001=0.000
min	13.150-0.089=13.061
max	13.152-0.091=13.062

*mean*	0.031-0.003=0.028
σ	0.013-0.000=0.013
min	0.024-0.003=0.021
max	0.055-0.003=0.051

iterations=5

operation_display=load_product()

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_three

step_id=load_product

*mean*	8718.261-8288.893=429.368
σ	0.600-0.469=0.131
min	8717.198-8288.626=428.572
max	8718.651-8289.729=428.921

*mean*	370.674-428.167=-57.493
σ	224.401-575.074=-350.673
min	31.059-140.173=-109.114
max	554.631-1455.125=-900.494

*mean*	5.106-5.743=-0.638
σ	1.497-1.006=0.491
min	3.458-4.066=-0.608
max	6.919-6.672=0.247

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*	15147.523-14169.695=977.827
σ	0.079-0.037=0.042
min	15147.397-14169.669=977.729
max	15147.590-14169.759=977.831

*mean*	428.980-412.479=16.501
σ	736.110-376.031=360.079
min	17.939-14.785=3.153
max	1739.593-1026.384=713.210

*mean*	11.359-10.772=0.588
σ	0.985-0.405=0.580
min	10.060-10.214=-0.154
max	12.221-11.341=0.881

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*	12.434-10.582=1.853
σ	0.001-0.000=0.001
min	12.434-10.582=1.852
max	12.437-10.582=1.855

*mean*	10.891-9.177=1.714
σ	0.000-0.000=0.000
min	10.891-9.177=1.714
max	10.891-9.177=1.714

*mean*	0.005-0.009=-0.004
σ	0.001-0.000=0.000
min	0.004-0.008=-0.004
max	0.006-0.009=-0.003

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*	14104.794-13232.162=872.632
σ	0.009-1.551=-1.542
min	14104.789-13229.387=875.401
max	14104.809-13232.856=871.953

*mean*	386.268-118.559=267.709
σ	281.357-95.979=185.379
min	53.575-16.973=36.602
max	798.312-264.322=533.991

*mean*	8.290-9.197=-0.907
σ	2.015-1.321=0.694
min	5.434-7.358=-1.924
max	10.399-10.476=-0.077

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*	73.245-45.830=27.415
σ	0.009-1.554=-1.545
min	73.230-45.135=28.095
max	73.249-48.610=24.639

*mean*	18.619-14.887=3.732
σ	0.000-0.003=-0.003
min	18.619-14.882=3.737
max	18.620-14.888=3.731

*mean*	0.142-0.105=0.036
σ	0.005-0.009=-0.004
min	0.134-0.096=0.038
max	0.148-0.117=0.031

iterations=5

operation_display=load_product()

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=load_product

*mean*	2470.066-2463.969=6.097
σ	0.136-0.218=-0.082
min	2470.002-2463.871=6.131
max	2470.311-2464.360=5.951

*mean*	707.242-633.302=73.940
σ	1009.536-1068.837=-59.301
min	199.993-21.668=178.325
max	2505.808-2540.211=-34.403

*mean*	1.742-1.322=0.420
σ	0.825-0.472=0.353
min	1.028-1.016=0.012
max	2.926-2.104=0.822

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*	27.345-25.814=1.532
σ	0.001-0.002=-0.001
min	27.345-25.812=1.533
max	27.347-25.816=1.530

*mean*	12.920-11.388=1.533
σ	0.000
min	12.920-11.387=1.533
max	12.921-11.388=1.533

*mean*	0.087-0.079=0.008
σ	0.010-0.018=-0.008
min	0.074-0.062=0.012
max	0.100-0.098=0.002

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*	27.343-25.809=1.534
σ	0.002-0.000=0.001
min	27.342-25.809=1.533
max	27.346-25.810=1.536

*mean*	12.921-11.388=1.533
σ	0.000
min	12.920-11.388=1.533
max	12.921-11.388=1.533

*mean*	0.087-0.079=0.009
σ	0.010-0.018=-0.008
min	0.074-0.062=0.012
max	0.100-0.098=0.002

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*	27.565-26.605=0.960
σ	0.001
min	27.565-26.605=0.960
max	27.567-26.606=0.960

*mean*	15.311-13.778=1.533
σ	0.000
min	15.311-13.778=1.533
max	15.311-13.779=1.533

*mean*	0.087-0.079=0.008
σ	0.010-0.018=-0.007
min	0.074-0.063=0.011
max	0.100-0.099=0.001

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*	27.349-25.817=1.533
σ	0.001
min	27.349-25.816=1.533
max	27.351-25.818=1.533

*mean*	12.921-11.388=1.533
σ	0.000
min	12.920-11.388=1.533
max	12.921-11.388=1.533

*mean*	0.087-0.079=0.008
σ	0.010-0.018=-0.008
min	0.074-0.062=0.012
max	0.100-0.098=0.002

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*	53.897-52.364=1.533
σ	0.000
min	53.896-52.364=1.533
max	53.897-52.364=1.533

*mean*	36.220-34.688=1.533
σ	0.000
min	36.220-34.687=1.533
max	36.221-34.688=1.533

*mean*	0.138-0.128=0.010
σ	0.014-0.023=-0.009
min	0.122-0.107=0.014
max	0.158-0.154=0.004

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*	53.054-51.521=1.533
σ	0.000-0.000=0.000
min	53.053-51.521=1.533
max	53.054-51.521=1.533

*mean*	110.295-34.019=76.277
σ	167.133-0.000=167.133
min	35.551-34.019=1.533
max	409.272-34.019=375.253

*mean*	0.232-0.132=0.100
σ	0.199-0.023=0.176
min	0.125-0.112=0.013
max	0.587-0.157=0.429

Internal benchmark: pointedIndexFromKvs

Factor

time_s

benchmark=pointed_index_from_kvs

iterations=5

rows=400000

*mean*	0.405-0.797=-0.392
σ	0.210-0.052=0.158
min	0.309-0.721=-0.412
max	0.780-0.860=-0.080