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.201-228.206=-0.005
σ	0.006-0.007=-0.001
min	228.191-228.198=-0.007
max	228.205-228.215=-0.010

*mean*	41.646-41.634=0.013
σ	0.422-0.413=0.009
min	40.931-40.936=-0.005
max	41.979-41.976=0.003

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

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.001=0.000
σ	0.000-0.000=0.000
min	0.001-0.001=-0.000
max	0.001-0.001=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*	9.567-9.585=-0.018
σ	0.002-0.003=-0.001
min	9.564-9.581=-0.017
max	9.569-9.590=-0.020

*mean*	1.467-1.491=-0.024
σ	0.192-0.171=0.021
min	1.189-1.249=-0.060
max	1.645-1.644=0.001

*mean*	0.009-0.009=-0.000
σ	0.000-0.000=-0.000
min	0.008-0.008=-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*	6.495-6.500=-0.005
σ	2.174-2.175=-0.001
min	4.906-4.910=-0.005
max	8.877-8.884=-0.007

*mean*	0.759-0.703=0.056
σ	0.310-0.263=0.047
min	0.405-0.414=-0.009
max	1.078-1.072=0.006

*mean*	0.007-0.007=-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*	178.437-178.441=-0.004
σ	0.521-0.526=-0.005
min	177.725-177.725=-0.000
max	178.956-178.962=-0.006

*mean*	21.910-21.897=0.013
σ	4.215-4.210=0.006
min	14.371-14.368=0.003
max	23.925-23.901=0.024

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

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-0.000=1.122
σ	2.509-0.000=2.509
min	0.000
max	5.610-0.000=5.610

*mean*	0.015-0.000=0.015
σ	0.033-0.000=0.033
min	0.000
max	0.074-0.000=0.074

*mean*	0.001-0.001=0.000
σ	0.000-0.000=0.000
min	0.001-0.001=0.000
max	0.002-0.001=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.001-0.000=0.000
σ	0.000-0.000=0.000
min	0.000-0.000=0.000
max	0.001-0.001=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*	2.457-2.446=0.011
σ	2.243-2.233=0.010
min	0.000
max	4.096-4.103=-0.007

*mean*	0.553-0.555=-0.002
σ	0.505-0.507=-0.002
min	0.000
max	0.932-0.930=0.002

*mean*	0.005-0.004=0.000
σ	0.001-0.001=0.000
min	0.004-0.004=-0.000
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*	4.281-5.390=-1.108
σ	2.406-0.254=2.152
min	0.000-4.937=-4.937
max	5.516-5.536=-0.020

*mean*	0.482-0.655=-0.173
σ	0.380-0.298=0.082
min	0.000-0.149=-0.149
max	0.848-0.925=-0.077

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

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-2.356=-0.016
σ	3.211-3.232=-0.022
min	0.000
max	6.144-6.169=-0.025

*mean*	0.111-0.104=0.007
σ	0.188-0.175=0.013
min	0.000
max	0.435-0.404=0.031

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

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.711=0.058
σ	3.445-3.387=0.058
min	0.000
max	6.569-6.207=0.362

*mean*	0.351-0.354=-0.003
σ	0.328-0.334=-0.005
min	0.000
max	0.663-0.708=-0.045

*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

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-229.005=-0.008
σ	1.770-1.770=-0.001
min	228.190-228.204=-0.015
max	232.162-232.172=-0.010

*mean*	22.790-26.251=-3.461
σ	15.801-13.843=1.957
min	6.612-10.256=-3.644
max	43.000-44.000=-1.000

*mean*	0.256-0.257=-0.002
σ	0.079-0.086=-0.007
min	0.153-0.142=0.011
max	0.345-0.351=-0.006

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-8.099=-0.007
σ	1.778-1.778=0.000
min	4.911-4.919=-0.008
max	8.891-8.896=-0.005

*mean*	1.409-1.413=-0.004
σ	0.190-0.191=-0.001
min	1.196-1.197=-0.001
max	1.626-1.624=0.002

*mean*	0.012-0.012=0.000
σ	0.003-0.003=-0.001
min	0.009-0.009=0.000
max	0.016-0.016=0.000

iterations=5

operation_display=load_product()

rows=15894

scenario_id=ci/scenario_aon

step_id=load_product

*mean*	178.221-178.226=-0.005
σ	0.315-0.317=-0.002
min	177.665-177.666=-0.001
max	178.401-178.404=-0.003

*mean*	23.212-20.890=2.321
σ	8.062-10.948=-2.885
min	14.678-6.788=7.890
max	36.000

*mean*	0.152-0.159=-0.007
σ	0.053-0.053=-0.000
min	0.083-0.083=0.001
max	0.219-0.228=-0.008

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-0.821=-0.002
σ	1.832-1.836=-0.004
min	0.000
max	4.097-4.105=-0.009

*mean*	0.182-0.181=0.001
σ	0.407-0.405=0.002
min	0.000
max	0.911-0.906=0.004

*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*	8291.534-8291.539=-0.005
σ	0.208-0.181=0.027
min	8291.165-8291.218=-0.053
max	8291.654-8291.654=-0.000

*mean*	442.361-519.470=-77.109
σ	59.883-210.324=-150.442
min	386.000-388.000=-2.000
max	539.148-890.000=-350.852

*mean*	4.335-4.981=-0.646
σ	1.452-1.432=0.020
min	3.309-3.585=-0.276
max	6.827-7.065=-0.238

iterations=5

operation_display=table_records()

rows=200000

scenario_id=ci/scenario_synthetic

step_id=table_records

*mean*	14174.861-14174.878=-0.017
σ	5.039-5.035=0.004
min	14172.579-14172.588=-0.010
max	14183.875-14183.885=-0.010

*mean*	427.200-518.619=-91.419
σ	154.527-333.618=-179.090
min	188.000-107.291=80.709
max	613.000-1023.802=-410.802

*mean*	9.654-9.890=-0.236
σ	1.735-1.415=0.319
min	7.655-7.639=0.016
max	11.159-11.200=-0.041

iterations=5

operation_display=table_records(), repeat

rows=200000

scenario_id=ci/scenario_synthetic

step_id=table_records.repeat

*mean*	27.916-27.925=-0.010
σ	0.000-0.000=0.000
min	27.915-27.925=-0.010
max	27.916-27.926=-0.009

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

*mean*	0.009-0.009=-0.000
σ	0.001-0.001=-0.000
min	0.008-0.008=-0.000
max	0.010-0.011=-0.001

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-19.589=-0.010
σ	0.002-0.003=-0.000
min	19.577-19.586=-0.010
max	19.581-19.592=-0.010

*mean*	12.111-51.074=-38.963
σ	0.001-87.124=-87.124
min	12.110-12.110=0.000
max	12.112-206.927=-194.815

*mean*	0.020-0.034=-0.014
σ	0.001-0.032=-0.031
min	0.019-0.018=0.001
max	0.022-0.092=-0.070

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-13.299=-0.010
σ	0.002-0.003=-0.000
min	13.286-13.296=-0.010
max	13.290-13.302=-0.012

*mean*	9.265-9.264=0.001
σ	0.001-0.001=-0.000
min	9.264-9.263=0.001
max	9.265-9.265=0.000

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

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-8287.854=-0.001
σ	0.068-0.065=0.003
min	8287.795-8287.801=-0.006
max	8287.964-8287.962=0.002

*mean*	372.307-315.595=56.712
σ	194.433-211.781=-17.348
min	106.411-105.449=0.962
max	548.315-548.314=0.001

*mean*	4.606-4.533=0.072
σ	1.398-1.193=0.205
min	3.267-3.333=-0.067
max	6.556-5.955=0.601

iterations=5

operation_display=table_records()

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=table_records

*mean*	14172.603-14172.613=-0.010
σ	0.032-0.031=0.001
min	14172.576-14172.589=-0.013
max	14172.639-14172.648=-0.009

*mean*	796.225-528.707=267.518
σ	892.051-678.908=213.143
min	161.774-49.866=111.908
max	2263.084-1722.042=541.043

*mean*	9.691-9.578=0.113
σ	2.163-2.326=-0.163
min	6.424-6.369=0.055
max	11.519-11.535=-0.017

iterations=5

operation_display=table_records(), repeat

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=table_records.repeat

*mean*	27.915-27.925=-0.010
σ	0.000-0.000=0.000
min	27.915-27.925=-0.010
max	27.916-27.926=-0.010

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

*mean*	0.010-0.010=-0.000
σ	0.002-0.001=0.000
min	0.008-0.009=-0.000
max	0.012-0.012=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*	19.579-19.589=-0.010
σ	0.002-0.002=-0.000
min	19.577-19.587=-0.010
max	19.581-19.591=-0.010

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

*mean*	0.021-0.021=0.000
σ	0.002-0.002=-0.000
min	0.018-0.018=0.001
max	0.022-0.022=0.000

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-13.298=-0.010
σ	0.002-0.002=0.000
min	13.286-13.296=-0.010
max	13.290-13.300=-0.010

*mean*	9.264-9.264=-0.000
σ	0.001-0.001=0.000
min	9.264
max	9.265

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

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-14.226=-0.010
σ	0.003-0.003=-0.000
min	14.213-14.223=-0.010
max	14.218-14.228=-0.010

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

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

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-10.457=-0.010
σ	0.002-0.002=-0.000
min	10.445-10.456=-0.010
max	10.449-10.460=-0.010

*mean*	0.120-0.120=-0.000
σ	0.001-0.000=0.000
min	0.119-0.119=-0.000
max	0.120-0.120=-0.000

*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*	10.738-10.748=-0.010
σ	0.008-0.007=0.000
min	10.733-10.743=-0.010
max	10.751-10.761=-0.010

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

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

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-10.787=-0.010
σ	0.004-0.003=0.000
min	10.774-10.784=-0.010
max	10.782-10.792=-0.010

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

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

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-14.005=-0.010
σ	0.002-0.002=-0.000
min	13.993-14.002=-0.010
max	13.997-14.007=-0.010

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

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

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-11.075=-0.010
σ	0.002-0.002=0.000
min	11.063-11.073=-0.010
max	11.067-11.077=-0.010

*mean*	0.090-0.090=-0.000
σ	0.001-0.001=0.000
min	0.089
max	0.091-0.090=0.000

*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=load_product()

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_three

step_id=load_product

*mean*	8288.893-8288.894=-0.001
σ	0.469-0.468=0.000
min	8288.626-8288.627=-0.001
max	8289.729-8289.729=-0.000

*mean*	428.167-620.986=-192.819
σ	575.074-536.200=38.875
min	140.173-67.054=73.119
max	1455.125-1512.929=-57.804

*mean*	5.743-4.487=1.256
σ	1.006-1.101=-0.095
min	4.066-3.347=0.718
max	6.672-5.965=0.707

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-14169.705=-0.010
σ	0.037-0.035=0.001
min	14169.669-14169.678=-0.009
max	14169.759-14169.766=-0.007

*mean*	412.479-291.860=120.619
σ	376.031-421.535=-45.504
min	14.785-7.641=7.144
max	1026.384-1026.578=-0.194

*mean*	10.772-11.174=-0.403
σ	0.405-0.544=-0.139
min	10.214-10.543=-0.329
max	11.341-11.821=-0.480

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-10.593=-0.011
σ	0.000-0.002=-0.002
min	10.582-10.592=-0.010
max	10.582-10.596=-0.014

*mean*	9.177-9.177=0.000
σ	0.000-0.000=-0.000
min	9.177-9.176=0.001
max	9.177-9.177=-0.000

*mean*	0.009-0.010=-0.001
σ	0.000-0.001=-0.001
min	0.008-0.008=0.000
max	0.009-0.011=-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*	13232.162-13232.172=-0.011
σ	1.551-1.549=0.002
min	13229.387-13229.401=-0.013
max	13232.856-13232.866=-0.010

*mean*	118.559-531.809=-413.250
σ	95.979-940.134=-844.156
min	16.973-4.740=12.233
max	264.322-2204.184=-1939.862

*mean*	9.197-9.192=0.005
σ	1.321-1.072=0.248
min	7.358-7.396=-0.039
max	10.476-10.174=0.302

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-45.840=-0.010
σ	1.554-1.554=-0.000
min	45.135-45.145=-0.010
max	48.610-48.620=-0.010

*mean*	14.887-14.887=-0.000
σ	0.003-0.003=0.000
min	14.882-14.882=-0.000
max	14.888

*mean*	0.105-0.105=0.001
σ	0.009-0.010=-0.001
min	0.096-0.096=0.000
max	0.117-0.120=-0.003

iterations=5

operation_display=load_product()

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=load_product

*mean*	2463.969-2463.969=-0.000
σ	0.218-0.215=0.004
min	2463.871-2463.872=-0.002
max	2464.360-2464.353=0.007

*mean*	633.302-167.065=466.237
σ	1068.837-73.706=995.130
min	21.668-35.301=-13.633
max	2540.211-201.543=2338.668

*mean*	1.322-1.217=0.105
σ	0.472-0.402=0.070
min	1.016-1.025=-0.009
max	2.104-1.936=0.168

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-25.823=-0.009
σ	0.002-0.001=0.001
min	25.812-25.823=-0.010
max	25.816-25.824=-0.008

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

*mean*	0.079-0.077=0.001
σ	0.018-0.020=-0.002
min	0.062-0.059=0.003
max	0.098-0.103=-0.005

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-25.820=-0.011
σ	0.000-0.002=-0.001
min	25.809-25.819=-0.010
max	25.810-25.823=-0.014

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

*mean*	0.079-0.077=0.001
σ	0.018-0.020=-0.002
min	0.062-0.059=0.003
max	0.098-0.104=-0.005

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-26.615=-0.010
σ	0.001-0.001=-0.000
min	26.605-26.615=-0.010
max	26.606-26.617=-0.010

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

*mean*	0.079-0.078=0.001
σ	0.018-0.020=-0.002
min	0.063-0.059=0.003
max	0.099-0.104=-0.005

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-25.827=-0.010
σ	0.001-0.001=-0.000
min	25.816-25.826=-0.010
max	25.818-25.828=-0.010

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

*mean*	0.079-0.078=0.001
σ	0.018-0.020=-0.002
min	0.062-0.060=0.002
max	0.098-0.103=-0.005

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-52.374=-0.010
σ	0.000-0.000=-0.000
min	52.364-52.374=-0.010
max	52.364-52.375=-0.010

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

*mean*	0.128-0.126=0.003
σ	0.023-0.027=-0.004
min	0.107-0.100=0.007
max	0.154-0.161=-0.008

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-51.531=-0.010
σ	0.000-0.000=-0.000
min	51.521-51.531=-0.010
max	51.521-51.531=-0.010

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

*mean*	0.132-0.129=0.003
σ	0.023-0.026=-0.003
min	0.112-0.106=0.006
max	0.157-0.164=-0.007

Internal benchmark: pointedIndexFromKvs

Factor

time_s

benchmark=pointed_index_from_kvs

iterations=5

rows=400000

*mean*	0.797-0.303=0.493
σ	0.052-0.002=0.050
min	0.721-0.301=0.420
max	0.860-0.306=0.554