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.193-228.196=-0.003
σ	0.020-0.016=0.004
min	228.170-228.178=-0.008
max	228.210-228.219=-0.009

*mean*	41.495-41.516=-0.021
σ	0.236-0.196=0.039
min	41.200-41.243=-0.043
max	41.715-41.724=-0.009

*mean*	0.119-0.119=-0.000
σ	0.001-0.001=-0.001
min	0.118-0.118=0.000
max	0.120-0.122=-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*	0.822-1.643=-0.821
σ	1.839-2.250=-0.411
min	0.000
max	4.112-4.109=0.003

*mean*	0.114-0.226=-0.112
σ	0.255-0.310=-0.055
min	0.000
max	0.569-0.575=-0.005

*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

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*	7.951-6.335=1.616
σ	2.213-1.806=0.408
min	5.465-5.464=0.000
max	9.569-9.563=0.006

*mean*	1.292-1.069=0.224
σ	0.315-0.042=0.273
min	1.024-1.025=-0.000
max	1.651-1.116=0.534

*mean*	0.008-0.008=0.001
σ	0.001-0.001=0.000
min	0.007-0.007=0.000
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.084-8.085=-0.000
σ	1.777-1.777=-0.000
min	4.906-4.906=-0.000
max	8.879-8.879=-0.000

*mean*	0.369-0.293=0.076
σ	0.433-0.443=-0.010
min	0.090-0.085=0.005
max	1.086-1.086=0.000

*mean*	0.008-0.008=-0.000
σ	0.000-0.000=0.000
min	0.007-0.007=-0.000
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*	180.033-181.233=-1.201
σ	2.515-2.956=-0.441
min	177.689-177.688=0.001
max	184.308-184.303=0.005

*mean*	23.721-23.820=-0.099
σ	0.421-0.514=-0.092
min	23.276-23.241=0.035
max	24.309-24.327=-0.017

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

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.118-3.121=-2.003
σ	2.501-2.860=-0.359
min	0.000
max	5.592-5.601=-0.008

*mean*	0.019-0.212=-0.193
σ	0.042-0.261=-0.219
min	0.000
max	0.095-0.534=-0.439

*mean*	0.001-0.001=-0.000
σ	0.000-0.001=-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.219-2.238=-0.019
σ	3.039-3.065=-0.026
min	0.000
max	5.589-5.597=-0.008

*mean*	0.126-0.154=-0.028
σ	0.223-0.281=-0.058
min	0.000
max	0.515-0.648=-0.133

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

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*	1.774-4.617=-2.843
σ	2.441-0.293=2.148
min	0.000-4.101=-4.101
max	4.777-4.788=-0.011

*mean*	0.240-0.474=-0.233
σ	0.406-0.260=0.146
min	0.000-0.286=-0.286
max	0.938-0.932=0.006

*mean*	0.004-0.005=-0.001
σ	0.001-0.000=0.001
min	0.004-0.005=-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*	3.051-0.000=3.051
σ	2.796-0.000=2.796
min	0.000
max	5.492-0.000=5.492

*mean*	0.234-0.000=0.234
σ	0.304-0.000=0.304
min	0.000
max	0.707-0.000=0.707

*mean*	0.004-0.003=0.001
σ	0.001-0.000=0.000
min	0.003-0.003=0.000
max	0.004-0.003=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*	2.339-0.000=2.339
σ	3.209-0.000=3.209
min	0.000
max	6.143-0.000=6.143

*mean*	0.115-0.000=0.115
σ	0.190-0.000=0.190
min	0.000
max	0.438-0.000=0.438

*mean*	0.001-0.000=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_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
σ	0.000
min	0.000
max	0.000

*mean*	0.000
σ	0.000
min	0.000
max	0.000

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

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.988-228.984=0.004
σ	1.767-1.774=-0.007
min	228.192-228.182=0.010
max	232.149-232.157=-0.008

*mean*	25.164-26.654=-1.490
σ	16.610-15.162=1.448
min	0.820-6.618=-5.799
max	44.000-42.000=2.000

*mean*	0.301-0.271=0.030
σ	0.063-0.091=-0.027
min	0.211-0.166=0.045
max	0.381-0.388=-0.007

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-5.702=2.391
σ	1.778-1.780=-0.002
min	4.911-4.893=0.018
max	8.893-8.886=0.006

*mean*	1.388-1.156=0.232
σ	0.194-0.085=0.109
min	1.182-1.068=0.114
max	1.631-1.263=0.368

*mean*	0.014-0.011=0.003
σ	0.001-0.003=-0.002
min	0.013-0.007=0.006
max	0.016-0.014=0.002

iterations=5

operation_display=load_product()

rows=15894

scenario_id=ci/scenario_aon

step_id=load_product

*mean*	178.222-178.979=-0.757
σ	0.318-1.921=-1.602
min	177.659-177.671=-0.012
max	178.403-182.382=-3.978

*mean*	20.705-26.794=-6.089
σ	2.878-10.097=-7.218
min	17.581-14.864=2.717
max	23.696-40.000=-16.304

*mean*	0.177-0.172=0.005
σ	0.043-0.060=-0.018
min	0.122-0.084=0.038
max	0.230-0.244=-0.014

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-2.457=-1.638
σ	1.832-2.243=-0.411
min	0.000
max	4.096-4.096=0.000

*mean*	0.181-0.557=-0.376
σ	0.405-0.508=-0.104
min	0.000
max	0.905-0.938=-0.033

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

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*	8716.135-8715.932=0.203
σ	1.370-0.918=0.452
min	8715.490-8715.490=0.000
max	8718.584-8717.573=1.011

*mean*	505.912-470.244=35.668
σ	185.114-85.152=99.962
min	391.000-383.000=8.000
max	832.000-576.000=256.000

*mean*	5.745-5.395=0.349
σ	1.005-1.399=-0.393
min	4.445-3.623=0.822
max	6.673-6.984=-0.312

iterations=5

operation_display=table_records()

rows=200000

scenario_id=ci/scenario_synthetic

step_id=table_records

*mean*	15164.953-15164.966=-0.013
σ	5.013-5.013=0.000
min	15162.682-15162.695=-0.013
max	15173.921-15173.934=-0.013

*mean*	534.689-424.800=109.889
σ	316.583-248.925=67.657
min	206.000-94.000=112.000
max	1045.443-736.000=309.443

*mean*	11.262-11.331=-0.068
σ	1.650-0.720=0.930
min	8.344-10.680=-2.336
max	12.400-12.397=0.003

iterations=5

operation_display=table_records(), repeat

rows=200000

scenario_id=ci/scenario_synthetic

step_id=table_records.repeat

*mean*	27.806-27.807=-0.000
σ	0.001-0.002=-0.001
min	27.806
max	27.807-27.810=-0.003

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

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

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-12.820=-0.000
σ	0.002-0.002=0.000
min	12.817-12.817=-0.000
max	12.822-12.822=0.000

*mean*	10.790-10.791=-0.000
σ	0.000-0.000=0.000
min	10.790-10.790=-0.000
max	10.791

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

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-12.800=0.000
σ	0.002-0.002=-0.000
min	12.797
max	12.802-12.802=-0.000

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

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

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.331-8715.329=0.002
σ	0.456-0.454=0.003
min	8715.096-8715.096=0.000
max	8716.145-8716.139=0.007

*mean*	378.176-360.484=17.693
σ	230.733-169.171=61.561
min	38.463-213.598=-175.135
max	607.392-543.643=63.749

*mean*	5.210-4.577=0.634
σ	1.406-1.444=-0.038
min	3.492-3.434=0.059
max	7.255-6.704=0.551

iterations=5

operation_display=table_records()

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=table_records

*mean*	15162.718-15162.731=-0.013
σ	0.033-0.032=0.001
min	15162.679-15162.696=-0.017
max	15162.742-15162.755=-0.013

*mean*	637.624-483.582=154.042
σ	831.013-799.077=31.936
min	4.366-24.914=-20.548
max	1913.258-1901.408=11.850

*mean*	10.541-9.825=0.716
σ	1.900-2.093=-0.193
min	7.266-6.700=0.567
max	12.043-12.182=-0.140

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.806=0.000
σ	0.000-0.000=0.000
min	27.806
max	27.807-27.806=0.001

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

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

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.819-12.820=-0.000
σ	0.002-0.002=0.000
min	12.817-12.817=-0.000
max	12.821

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

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

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-12.799=0.000
σ	0.002-0.002=0.000
min	12.797
max	12.802-12.801=0.000

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

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

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
σ	0.003
min	12.167
max	12.173

*mean*	0.038
σ	0.000
min	0.038
max	0.039

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

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-11.773=-0.000
σ	0.002-0.002=-0.000
min	11.771
max	11.775

*mean*	0.039
σ	0.000
min	0.039
max	0.039

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

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*	11.963-12.139=-0.176
σ	0.002-0.008=-0.005
min	11.959-12.134=-0.175
max	11.965-12.152=-0.187

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

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

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*	11.963-12.138=-0.175
σ	0.002-0.004=-0.002
min	11.961-12.135=-0.174
max	11.965-12.144=-0.179

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

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

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-39.756=0.000
σ	0.002-0.002=0.000
min	39.754
max	39.758-39.758=0.001

*mean*	2.148-46.723=-44.575
σ	0.001-99.675=-99.674
min	2.147-2.147=0.000
max	2.149-225.026=-222.878

*mean*	0.025-0.046=-0.021
σ	0.001-0.035=-0.034
min	0.024-0.024=0.000
max	0.026-0.105=-0.079

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-42.759=-0.000
σ	0.002-0.002=-0.000
min	42.757
max	42.761-42.761=-0.000

*mean*	13.150-13.151=-0.002
σ	0.005-0.001=0.004
min	13.141-13.150=-0.009
max	13.152-13.152=0.000

*mean*	0.025-0.031=-0.006
σ	0.001-0.013=-0.013
min	0.024-0.024=-0.000
max	0.025-0.055=-0.029

iterations=5

operation_display=load_product()

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_three

step_id=load_product

*mean*	8718.260-8718.261=-0.001
σ	0.603-0.600=0.003
min	8717.190-8717.198=-0.007
max	8718.651-8718.651=0.000

*mean*	294.860-370.674=-75.813
σ	183.195-224.401=-41.206
min	150.192-31.059=119.133
max	551.343-554.631=-3.287

*mean*	5.083-5.106=-0.023
σ	1.228-1.497=-0.269
min	3.503-3.458=0.045
max	6.787-6.919=-0.131

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.510-15147.523=-0.013
σ	0.077-0.079=-0.002
min	15147.387-15147.397=-0.010
max	15147.576-15147.590=-0.014

*mean*	714.227-428.980=285.246
σ	617.053-736.110=-119.057
min	148.725-17.939=130.786
max	1635.883-1739.593=-103.710

*mean*	10.624-11.359=-0.735
σ	2.075-0.985=1.089
min	7.052-10.060=-3.009
max	12.116-12.221=-0.105

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-12.434=-0.001
σ	0.000-0.001=-0.001
min	12.434
max	12.434-12.437=-0.003

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

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

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.755-14104.794=-0.039
σ	0.058-0.009=0.049
min	14104.652-14104.789=-0.137
max	14104.796-14104.809=-0.014

*mean*	472.991-386.268=86.723
σ	323.591-281.357=42.234
min	54.255-53.575=0.680
max	798.304-798.312=-0.009

*mean*	8.027-8.290=-0.263
σ	2.079-2.015=0.064
min	5.435-5.434=0.002
max	9.782-10.399=-0.616

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.270-73.245=0.025
σ	0.058-0.009=0.050
min	73.230
max	73.373-73.249=0.124

*mean*	18.619
σ	0.000
min	18.619
max	18.620

*mean*	0.140-0.142=-0.002
σ	0.010-0.005=0.005
min	0.125-0.134=-0.009
max	0.149-0.148=0.001

iterations=5

operation_display=load_product()

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=load_product

*mean*	2470.069-2470.066=0.002
σ	0.139-0.136=0.003
min	2470.002-2470.002=0.001
max	2470.318-2470.311=0.008

*mean*	680.395-707.242=-26.847
σ	1009.813-1009.536=0.277
min	200.004-199.993=0.010
max	2485.137-2505.808=-20.672

*mean*	1.667-1.742=-0.075
σ	0.690-0.825=-0.135
min	1.016-1.028=-0.012
max	2.553-2.926=-0.373

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.203-27.345=-0.143
σ	0.001
min	27.202-27.345=-0.143
max	27.204-27.347=-0.143

*mean*	12.917-12.920=-0.003
σ	0.000
min	12.917-12.920=-0.003
max	12.917-12.921=-0.003

*mean*	0.086-0.087=-0.001
σ	0.017-0.010=0.006
min	0.063-0.074=-0.012
max	0.103-0.100=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.200-27.343=-0.143
σ	0.002
min	27.199-27.342=-0.143
max	27.203-27.346=-0.143

*mean*	12.917-12.921=-0.003
σ	0.000
min	12.917-12.920=-0.003
max	12.918-12.921=-0.003

*mean*	0.086-0.087=-0.001
σ	0.016-0.010=0.006
min	0.063-0.074=-0.011
max	0.103-0.100=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.420-27.565=-0.145
σ	0.001
min	27.420-27.565=-0.145
max	27.422-27.567=-0.145

*mean*	15.308-15.311=-0.003
σ	0.000
min	15.307-15.311=-0.003
max	15.308-15.311=-0.003

*mean*	0.086-0.087=-0.001
σ	0.017-0.010=0.006
min	0.063-0.074=-0.011
max	0.103-0.100=0.003

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.205-27.349=-0.145
σ	0.001
min	27.204-27.349=-0.145
max	27.206-27.351=-0.145

*mean*	12.917-12.921=-0.003
σ	0.000
min	12.917-12.920=-0.003
max	12.917-12.921=-0.003

*mean*	0.086-0.087=-0.001
σ	0.017-0.010=0.006
min	0.062-0.074=-0.012
max	0.103-0.100=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.774-53.897=-0.123
σ	0.000-0.000=0.000
min	53.773-53.896=-0.123
max	53.774-53.897=-0.123

*mean*	188.159-36.220=151.939
σ	339.755-0.000=339.755
min	36.216-36.220=-0.005
max	795.931-36.221=759.710

*mean*	0.251-0.138=0.112
σ	0.268-0.014=0.253
min	0.105-0.122=-0.017
max	0.728-0.158=0.570

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*	52.931-53.054=-0.123
σ	0.002-0.000=0.001
min	52.930-53.053=-0.123
max	52.934-53.054=-0.120

*mean*	35.545-110.295=-74.750
σ	0.004-167.133=-167.129
min	35.538-35.551=-0.013
max	35.547-409.272=-373.725

*mean*	0.132-0.232=-0.099
σ	0.020-0.199=-0.179
min	0.110-0.125=-0.015
max	0.162-0.587=-0.425

Internal benchmark: pointedIndexFromKvs

Factor

time_s

benchmark=pointed_index_from_kvs

iterations=5

rows=400000

*mean*	0.747-0.405=0.342
σ	0.082-0.210=-0.128
min	0.627-0.309=0.317
max	0.832-0.780=0.051