Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.618-54.616=0.002
σ	0.352-0.350=0.002
min	54.480-54.481=-0.001
max	55.618-55.610=0.008

*mean*	417.000-415.000=2.000
σ	0.000
min	417.000-415.000=2.000
max	417.000-415.000=2.000

*mean*	0.138-0.139=-0.001
σ	0.004-0.004=-0.000
min	0.131-0.133=-0.001
max	0.145-0.147=-0.003

cache=y

dps=1

iters=10

policies=100

*mean*	43.785-43.785=-0.001
σ	0.007-0.006=0.001
min	43.773-43.779=-0.006
max	43.798-43.797=0.001

*mean*	417.000-415.000=2.000
σ	0.000
min	417.000-415.000=2.000
max	417.000-415.000=2.000

*mean*	0.122-0.121=0.001
σ	0.005-0.005=-0.000
min	0.117-0.114=0.003
max	0.130-0.129=0.000

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.616
max	36.619

*mean*	4282.250
σ	1976.034
min	1550.000
max	7207.000

*mean*	54.514
σ	117.522
min	12.466
max	345.364

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4282.250
σ	1976.034
min	1550.000
max	7207.000

*mean*	13.443
σ	1.416
min	11.936
max	16.657

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	14.956
σ	1.115
min	12.710
max	15.964

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	14.287
σ	1.135
min	12.221
max	15.693

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.931

*mean*	4166.500
σ	1899.394
min	1550.000
max	7207.000

*mean*	13.698
σ	1.654
min	10.803
max	15.514

iterations=8

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

rows=200000

*mean*	27.605
σ	0.003
min	27.603
max	27.611

*mean*	4166.500
σ	1899.394
min	1550.000
max	7207.000

*mean*	8.907
σ	0.299
min	8.480
max	9.225

iterations=8

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

rows=200000

*mean*	26.401
σ	0.002
min	26.399
max	26.403

*mean*	4166.500
σ	1899.394
min	1550.000
max	7207.000

*mean*	6.959
σ	0.110
min	6.742
max	7.106

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.666
σ	0.002
min	25.664
max	25.668

*mean*	4282.250
σ	1976.034
min	1550.000
max	7207.000

*mean*	5.986
σ	0.137
min	5.807
max	6.121

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*	4282.250
σ	1976.034
min	1550.000
max	7207.000

*mean*	5.592
σ	0.176
min	5.233
max	5.850

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969
σ	0.002
min	25.967
max	25.971

*mean*	4282.250
σ	1976.034
min	1550.000
max	7207.000

*mean*	5.643
σ	0.088
min	5.458
max	5.749

iterations=8

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

rows=200000

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4282.250
σ	1976.034
min	1550.000
max	7207.000

*mean*	5.502
σ	0.102
min	5.285
max	5.617

op=column_set() on indexed

*mean*	36.618
σ	0.002
min	36.615
max	36.620

*mean*	4290.625
σ	1877.362
min	2074.000
max	7587.000

*mean*	12.346
σ	0.222
min	12.082
max	12.721

op=column_set() on indexed, repeat

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4290.625
σ	1877.362
min	2074.000
max	7587.000

*mean*	12.662
σ	0.564
min	11.712
max	13.219

op=table_records(), no indexes

*mean*	41.928
σ	0.000
min	41.928
max	41.929

*mean*	7587.000
σ	0.000
min	7587.000
max	7587.000

*mean*	14.122
σ	1.197
min	12.508
max	15.346

op=table_records(), repeat

*mean*	41.928
σ	0.002
min	41.927
max	41.931

*mean*	4089.125
σ	1526.791
min	2074.000
max	5975.000

*mean*	12.709
σ	1.854
min	10.897
max	14.927

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

*mean*	27.605
σ	0.002
min	27.603
max	27.607

*mean*	4089.125
σ	1526.791
min	2074.000
max	5975.000

*mean*	8.716
σ	0.538
min	8.127
max	9.503

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

*mean*	26.400
σ	0.002
min	26.399
max	26.403

*mean*	4089.125
σ	1526.791
min	2074.000
max	5975.000

*mean*	6.219
σ	0.313
min	5.667
max	6.628

op=vertical_lookup_row_list() on 2 indexed

*mean*	25.666
σ	0.002
min	25.664
max	25.670

*mean*	4290.625
σ	1877.362
min	2074.000
max	7587.000

*mean*	5.609
σ	0.129
min	5.442
max	5.855

op=vertical_lookup_row_list() on 3 (1 unindexed)

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4290.625
σ	1877.362
min	2074.000
max	7587.000

*mean*	5.329
σ	0.181
min	5.012
max	5.551

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.597

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	1348.434
σ	468.156
min	1045.848
max	2244.367

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.041
min	8744.545
max	8744.663

*mean*	3587.875
σ	1813.045
min	1070.000
max	5810.000

*mean*	4775.461
σ	1463.856
min	3544.040
max	6963.380

op=load_product(), no indexes

*mean*	2524.594
σ	0.001
min	2524.593
max	2524.597

*mean*	7587.000
σ	0.000
min	7587.000
max	7587.000

*mean*	1110.994
σ	164.173
min	1045.799
max	1517.060

op=load_product(), with indexes

*mean*	8744.559
σ	0.033
min	8744.545
max	8744.640

*mean*	3820.500
σ	1591.957
min	2074.000
max	5975.000

*mean*	4540.059
σ	1348.664
min	3542.116
max	6691.875

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=column_set() on unindexed, dense

rows=200000

*mean*	62.078
σ	0.002
min	62.076
max	62.080

*mean*	4166.500
σ	1899.394
min	1550.000
max	7207.000

*mean*	78.286
σ	5.871
min	71.193
max	87.621

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4166.500
σ	1899.394
min	1550.000
max	7207.000

*mean*	78.821
σ	6.108
min	71.558
max	88.807

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.945
σ	0.002
min	40.944
max	40.949

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	102.613
σ	7.513
min	87.116
max	107.197

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.946
σ	0.002
min	40.944
max	40.947

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	102.572
σ	7.765
min	86.601
max	107.681

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*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	104.395
σ	6.923
min	90.151
max	110.283

iterations=8

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

rows=200000

*mean*	40.951
σ	0.002
min	40.949
max	40.953

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	102.764
σ	7.553
min	86.965
max	107.298

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*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	248.377
σ	251.565
min	137.930
max	870.389

iterations=8

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

rows=200000

*mean*	66.686
σ	0.001
min	66.685
max	66.689

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	156.548
σ	15.493
min	130.389
max	170.820

op=column_set() on unindexed, dense

*mean*	62.079
σ	0.002
min	62.076
max	62.080

*mean*	4290.625
σ	1877.362
min	2074.000
max	7587.000

*mean*	135.648
σ	151.212
min	72.146
max	508.799

op=vertical_lookup_list() on unindexed missing Int

*mean*	40.944
σ	0.001
min	40.944
max	40.945

*mean*	7587.000
σ	0.000
min	7587.000
max	7587.000

*mean*	101.037
σ	8.776
min	88.570
max	109.016

op=vertical_lookup_row_list() on unindexed small unique Int

*mean*	66.686
σ	0.000
min	66.685
max	66.687

*mean*	7587.000
σ	0.000
min	7587.000
max	7587.000

*mean*	311.908
σ	448.678
min	137.063
max	1421.888

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.519

*mean*	4166.500
σ	1899.394
min	1550.000
max	7207.000

*mean*	6258.000
σ	1113.636
min	4935.506
max	7948.905

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.065
σ	0.001
min	11560.064
max	11560.068

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	5521.772
σ	1291.019
min	4399.597
max	7775.774

op=table_records()

*mean*	11656.833
σ	4.318
min	11655.305
max	11667.521

*mean*	4089.125
σ	1526.791
min	2074.000
max	5975.000

*mean*	6427.067
σ	1307.636
min	4914.429
max	8172.389

op=vertical_lookup_list() on indexed

*mean*	11560.068
σ	0.001
min	11560.066
max	11560.069

*mean*	7587.000
σ	0.000
min	7587.000
max	7587.000

*mean*	5280.325
σ	1169.728
min	4366.582
max	7201.752

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.660
σ	0.015
min	172.633
max	172.678

*mean*	487.125
σ	0.354
min	487.000
max	488.000

*mean*	379.517
σ	27.737
min	331.122
max	411.521

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.456
σ	0.144
min	357.321
max	357.611

*mean*	572.000
σ	0.000
min	572.000
max	572.000

*mean*	792.189
σ	26.662
min	754.087
max	838.323

op=pointedIndexFromKvs

rows=200000

*mean*	172.582
σ	0.021
min	172.558
max	172.613

*mean*	2074.000
σ	0.000
min	2074.000
max	2074.000

*mean*	352.317
σ	60.729
min	263.430
max	447.250

op=pointedIndexFromKvs

rows=400000

*mean*	357.366
σ	0.045
min	357.321
max	357.420

*mean*	2074.000
σ	0.000
min	2074.000
max	2074.000

*mean*	783.911
σ	15.354
min	769.858
max	813.767

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.187-1008.079=0.108
σ	0.875-0.761=0.114
min	1007.687-1007.609=0.078
max	1011.805-1011.227=0.578

*mean*	1049.350-7207.000=-6157.650
σ	301.377-0.000=301.377
min	547.000-7207.000=-6660.000
max	1452.000-7207.000=-5755.000

*mean*	1.545-1.558=-0.012
σ	0.076-0.167=-0.091
min	1.479-1.398=0.081
max	1.759-1.992=-0.233

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.883-0.883=-0.000
σ	0.002-0.002=-0.000
min	0.881
max	0.886

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	0.397-0.315=0.082
σ	0.111-0.141=-0.030
min	0.326-0.240=0.086
max	0.593-0.566=0.027

name=error_case.art

*mean*	2.333
σ	0.004-0.003=0.002
min	2.332
max	2.341-2.337=0.004

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	0.880-0.664=0.216
σ	0.083-0.109=-0.026
min	0.823-0.601=0.222
max	1.025-0.858=0.167

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	0.546-0.394=0.152
σ	0.049-0.025=0.024
min	0.501-0.368=0.134
max	0.628-0.427=0.201

name=nested_use.art

*mean*	2.355
σ	0.002-0.002=0.000
min	2.355
max	2.359-2.358=0.000

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	0.850-0.847=0.003
σ	0.032-0.036=-0.004
min	0.824-0.814=0.010
max	0.902-0.904=-0.002

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.544-963.551=-0.008
σ	0.025-0.030=-0.005
min	963.523
max	963.585-963.601=-0.017

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	0.800-0.808=-0.008
σ	0.077-0.057=0.019
min	0.671-0.722=-0.051
max	0.860-0.856=0.004

name=cdr_enhanced_4k_loc.art

*mean*	884.853-884.856=-0.002
σ	0.007-0.005=0.001
min	884.847
max	884.863-884.861=0.002

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	0.730-0.726=0.004
σ	0.028-0.022=0.006
min	0.681-0.688=-0.007
max	0.747-0.741=0.006

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.711-7.709=0.001

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	3.495-4.265=-0.771
σ	0.083-0.088=-0.004
min	3.374-4.134=-0.761
max	3.973-4.600=-0.628

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.658

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	4.059-4.249=-0.190
σ	0.330-0.087=0.243
min	3.406-4.105=-0.699
max	4.442-4.595=-0.153

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	0.745-0.750=-0.005
σ	0.017-0.019=-0.002
min	0.704-0.716=-0.012
max	0.849-0.863=-0.014

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	0.710-0.549=0.162
σ	0.015-0.078=-0.062
min	0.677-0.491=0.186
max	0.783-0.785=-0.003

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.471-297.438=0.033
σ	0.226-0.197=0.030
min	297.219-297.255=-0.036
max	298.018-297.972=0.046

*mean*	2074.000-7207.000=-5133.000
σ	0.000
min	2074.000-7207.000=-5133.000
max	2074.000-7207.000=-5133.000

*mean*	0.555-0.551=0.004
σ	0.034-0.032=0.002
min	0.512-0.508=0.004
max	0.590-0.585=0.006

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.772-289.723=0.049
σ	0.038-0.035=0.002
min	289.730-289.675=0.054
max	289.813-289.772=0.041

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	0.400-0.388=0.012
σ	0.009-0.001=0.008
min	0.394-0.386=0.008
max	0.415-0.388=0.027

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.683-1299.644=0.039
σ	0.095-0.105=-0.009
min	1299.568-1299.513=0.055
max	1299.822-1299.763=0.060

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	2.074-1.924=0.150
σ	0.105-0.067=0.038
min	1.977-1.817=0.160
max	2.219-1.996=0.223

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.628-1542.648=-0.020
σ	4.043-3.983=0.060
min	1540.617-1540.613=0.004
max	1549.854-1549.766=0.089

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	2.313-2.333=-0.020
σ	0.162-0.300=-0.138
min	2.099-2.099=0.000
max	2.517-2.687=-0.170

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.635-1861.595=0.039
σ	0.062-0.059=0.003
min	1861.550-1861.512=0.038
max	1861.694-1861.645=0.048

*mean*	1733.200-7207.000=-5473.800
σ	243.584-0.000=243.584
min	1452.000-7207.000=-5755.000
max	2074.000-7207.000=-5133.000

*mean*	3.090-2.959=0.131
σ	0.324-0.144=0.180
min	2.831-2.849=-0.018
max	3.640-3.192=0.448

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.727-1.386=0.341
σ	0.114-0.291=-0.177
min	1.593-1.195=0.398
max	1.892-1.903=-0.011

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.184-446.147=0.037
σ	577.140-577.063=0.077
min	157.611-157.615=-0.004
max	1311.894-1311.741=0.153

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	0.526-0.542=-0.016
σ	0.531-0.534=-0.003
min	0.260-0.270=-0.010
max	1.322-1.343=-0.021

policies=20

*mean*	1576.417-1576.419=-0.002
σ	0.357-0.356=0.001
min	1576.179-1576.177=0.002
max	1576.949-1576.947=0.002

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	2.629-2.647=-0.018
σ	0.041-0.024=0.017
min	2.595-2.613=-0.018
max	2.687-2.667=0.019

policies=200

*mean*	15772.214-15772.210=0.004
σ	0.087-0.059=0.028
min	15772.136-15772.132=0.004
max	15772.338-15772.268=0.070

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1452.000-7207.000=-5755.000
σ	0.000
min	1452.000-7207.000=-5755.000
max	1452.000-7207.000=-5755.000

*mean*	26.529-26.622=-0.093
σ	0.070-0.101=-0.031
min	26.446-26.542=-0.096
max	26.608-26.759=-0.151