Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.615-53.703=0.912
σ	0.348-0.370=-0.022
min	54.485-53.557=0.928
max	55.605-54.755=0.851

*mean*	414.700-416.000=-1.300
σ	0.483-0.000=0.483
min	414.000-416.000=-2.000
max	415.000-416.000=-1.000

*mean*	0.137-0.136=0.001
σ	0.004-0.003=0.001
min	0.131-0.131=-0.000
max	0.142-0.142=0.000

cache=y

dps=1

iters=10

policies=100

*mean*	43.785-43.059=0.727
σ	0.007-0.006=0.002
min	43.774-43.051=0.722
max	43.798-43.068=0.731

*mean*	415.000-416.000=-1.000
σ	0.000
min	415.000-416.000=-1.000
max	415.000-416.000=-1.000

*mean*	0.122-0.122=-0.000
σ	0.004-0.004=0.001
min	0.116-0.119=-0.003
max	0.129-0.128=0.001

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=column_set() on indexed

rows=200000

*mean*	36.617
σ	0.002
min	36.615
max	36.620

*mean*	4169.375
σ	1898.642
min	1551.000
max	7200.000

*mean*	12.663
σ	0.346
min	12.361
max	13.229

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4289.750
σ	1978.683
min	1551.000
max	7200.000

*mean*	98.041
σ	242.618
min	11.984
max	698.491

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	14.879
σ	1.432
min	11.786
max	16.083

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	14.374
σ	1.445
min	11.161
max	15.600

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.932

*mean*	4169.375
σ	1898.642
min	1551.000
max	7200.000

*mean*	13.677
σ	1.541
min	11.008
max	15.273

iterations=8

operation_display=vertical_lookup_list() on indexed, after table_records()

rows=200000

*mean*	27.605
σ	0.002
min	27.603
max	27.607

*mean*	4169.375
σ	1898.642
min	1551.000
max	7200.000

*mean*	9.222
σ	0.350
min	8.719
max	9.667

iterations=8

operation_display=vertical_lookup_list() on indexed, after table_records(), repeat

rows=200000

*mean*	26.400
σ	0.002
min	26.399
max	26.403

*mean*	4169.375
σ	1898.642
min	1551.000
max	7200.000

*mean*	6.673
σ	0.324
min	6.329
max	7.213

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.666
σ	0.002
min	25.664
max	25.670

*mean*	4289.750
σ	1978.683
min	1551.000
max	7200.000

*mean*	6.150
σ	0.627
min	5.682
max	7.654

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.661
σ	0.002
min	25.659
max	25.663

*mean*	4289.750
σ	1978.683
min	1551.000
max	7200.000

*mean*	5.732
σ	0.497
min	5.110
max	6.859

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969
σ	0.002
min	25.967
max	25.972

*mean*	4289.750
σ	1978.683
min	1551.000
max	7200.000

*mean*	5.802
σ	0.542
min	5.169
max	7.033

iterations=8

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

rows=200000

*mean*	25.969
σ	0.002
min	25.967
max	25.971

*mean*	4289.750
σ	1978.683
min	1551.000
max	7200.000

*mean*	5.757
σ	0.403
min	5.399
max	6.705

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.596
σ	0.002
min	2524.594
max	2524.598

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	1181.375
σ	387.549
min	1030.191
max	2140.087

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.560
σ	0.041
min	8744.545
max	8744.662

*mean*	3597.250
σ	1819.206
min	1075.000
max	5839.000

*mean*	4813.500
σ	1691.174
min	3512.674
max	7715.764

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=column_set() on unindexed, dense

rows=200000

*mean*	62.076
σ	0.001
min	62.075
max	62.080

*mean*	4169.375
σ	1898.642
min	1551.000
max	7200.000

*mean*	80.914
σ	9.171
min	72.582
max	98.794

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4169.375
σ	1898.642
min	1551.000
max	7200.000

*mean*	81.963
σ	9.404
min	72.071
max	100.190

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.945
σ	0.002
min	40.944
max	40.947

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	102.186
σ	9.796
min	82.733
max	108.849

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.945
σ	0.002
min	40.943
max	40.948

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	102.437
σ	9.755
min	82.884
max	109.065

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.951
σ	0.002
min	40.949
max	40.953

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	105.603
σ	7.592
min	89.821
max	112.221

iterations=8

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

rows=200000

*mean*	40.950
σ	0.002
min	40.948
max	40.954

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	102.460
σ	9.673
min	83.128
max	108.945

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.687
σ	0.002
min	66.685
max	66.690

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	218.280
σ	173.822
min	131.146
max	647.197

iterations=8

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

rows=200000

*mean*	66.687
σ	0.002
min	66.685
max	66.689

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	152.180
σ	20.397
min	113.894
max	167.768

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=table_records()

rows=200000

*mean*	11656.833
σ	4.318
min	11655.305
max	11667.520

*mean*	4169.375
σ	1898.642
min	1551.000
max	7200.000

*mean*	6672.861
σ	1311.529
min	4887.908
max	8182.041

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.065
σ	0.001
min	11560.064
max	11560.068

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	6035.933
σ	1558.222
min	4365.120
max	8441.402

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.668
σ	0.011
min	172.650
max	172.681

*mean*	488.125
σ	0.354
min	488.000
max	489.000

*mean*	392.708
σ	25.736
min	345.211
max	423.847

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.462
σ	0.164
min	357.321
max	357.677

*mean*	573.000
σ	0.000
min	573.000
max	573.000

*mean*	785.961
σ	65.878
min	627.648
max	832.099

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.085-1005.108=2.977
σ	0.761-0.881=-0.120
min	1007.611-1004.638=2.973
max	1011.230-1008.755=2.475

*mean*	7200.000-1049.850=6150.150
σ	0.000-315.078=-315.078
min	7200.000-594.000=6606.000
max	7200.000-1653.000=5547.000

*mean*	1.492-1.622=-0.130
σ	0.105-0.078=0.027
min	1.390-1.510=-0.120
max	1.778-1.868=-0.089

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.883
σ	0.002
min	0.881
max	0.886

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	0.319-0.415=-0.096
σ	0.122-0.139=-0.016
min	0.246-0.333=-0.087
max	0.536-0.662=-0.126

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	0.884-0.869=0.016
σ	0.085-0.090=-0.005
min	0.814-0.788=0.027
max	1.023-1.021=0.002

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	0.528-0.536=-0.008
σ	0.050-0.047=0.002
min	0.490-0.491=-0.001
max	0.613-0.611=0.002

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	0.835-0.834=0.001
σ	0.036-0.051=-0.015
min	0.800-0.782=0.018
max	0.895-0.919=-0.023

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.550-963.553=-0.003
σ	0.022-0.025=-0.003
min	963.528-963.523=0.005
max	963.575-963.583=-0.008

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	0.815-0.834=-0.020
σ	0.054-0.039=0.015
min	0.729-0.774=-0.044
max	0.856-0.867=-0.011

name=cdr_enhanced_4k_loc.art

*mean*	884.854-884.856=-0.003
σ	0.007-0.006=0.001
min	884.847
max	884.861-884.861=0.000

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	0.677-0.699=-0.022
σ	0.046-0.046=0.000
min	0.642-0.634=0.007
max	0.737-0.745=-0.008

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.706-7.706=-0.000
σ	0.002-0.002=-0.000
min	7.705
max	7.709-7.711=-0.002

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	3.524-3.536=-0.012
σ	0.063-0.192=-0.129
min	3.406-3.363=0.043
max	3.767-4.307=-0.540

name=record_render_large_syntax_err.art

*mean*	7.655-7.655=0.000
σ	0.002-0.002=0.000
min	7.654
max	7.660-7.659=0.001

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	3.504-4.206=-0.702
σ	0.096-0.063=0.033
min	3.230-4.106=-0.876
max	3.825-4.437=-0.612

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	0.539-0.735=-0.196
σ	0.021-0.017=0.004
min	0.510-0.702=-0.192
max	0.650-0.842=-0.192

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	0.508-0.696=-0.188
σ	0.015-0.014=0.001
min	0.478-0.671=-0.192
max	0.589-0.760=-0.171

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.602-294.165=3.437
σ	0.215-0.236=-0.021
min	297.484-293.984=3.499
max	298.195-294.814=3.381

*mean*	7200.000-1901.000=5299.000
σ	0.000
min	7200.000-1901.000=5299.000
max	7200.000-1901.000=5299.000

*mean*	0.542-0.580=-0.038
σ	0.027-0.042=-0.015
min	0.511-0.524=-0.013
max	0.591-0.651=-0.060

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.725-281.492=8.233
σ	0.036-0.037=-0.001
min	289.679-281.439=8.241
max	289.777-281.528=8.249

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	0.389-0.394=-0.005
σ	0.002-0.011=-0.010
min	0.387-0.385=0.002
max	0.391-0.411=-0.020

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.648-1291.477=8.171
σ	0.111-0.104=0.008
min	1299.506-1291.352=8.154
max	1299.766-1291.591=8.175

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	1.831-1.877=-0.046
σ	0.054-0.060=-0.007
min	1.783-1.816=-0.033
max	1.911-1.940=-0.029

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.634-1534.359=8.275
σ	4.057-4.030=0.027
min	1540.552-1532.363=8.190
max	1549.880-1541.559=8.321

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	2.351-2.399=-0.048
σ	0.208-0.219=-0.011
min	2.087-2.146=-0.059
max	2.614-2.622=-0.008

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.613-1853.357=8.255
σ	0.083-0.053=0.030
min	1861.496-1853.302=8.194
max	1861.716-1853.436=8.281

*mean*	7200.000-1784.000=5416.000
σ	0.000-120.058=-120.058
min	7200.000-1653.000=5547.000
max	7200.000-1901.000=5299.000

*mean*	2.892-3.067=-0.175
σ	0.056-0.241=-0.185
min	2.826-2.830=-0.004
max	2.969-3.451=-0.482

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.566-1.372=0.194
σ	0.252-0.227=0.025
min	1.308-1.114=0.195
max	1.910-1.690=0.220

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.149-442.429=3.720
σ	577.064-577.065=-0.001
min	157.616-153.894=3.722
max	1311.745-1308.026=3.719

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	0.541-0.529=0.012
σ	0.553-0.540=0.013
min	0.261-0.257=0.005
max	1.371-1.339=0.032

policies=20

*mean*	1576.420-1539.222=37.198
σ	0.356-0.316=0.041
min	1576.175-1539.004=37.171
max	1576.947-1539.690=37.257

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	2.634-2.581=0.053
σ	0.019-0.016=0.002
min	2.621-2.561=0.060
max	2.660-2.599=0.061

policies=200

*mean*	15772.207-15400.469=371.738
σ	0.056-0.099=-0.043
min	15772.142-15400.408=371.734
max	15772.274-15400.617=371.657

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7200.000-1653.000=5547.000
σ	0.000
min	7200.000-1653.000=5547.000
max	7200.000-1653.000=5547.000

*mean*	26.671-26.172=0.499
σ	0.301-0.227=0.074
min	26.391-25.954=0.437
max	26.947-26.409=0.537