Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.616-54.057=0.559
σ	0.351-0.367=-0.016
min	54.482-53.909=0.573
max	55.614-55.100=0.513

*mean*	415.000-419.000=-4.000
σ	0.000
min	415.000-419.000=-4.000
max	415.000-419.000=-4.000

*mean*	0.141-0.138=0.003
σ	0.004-0.006=-0.002
min	0.138-0.131=0.007
max	0.148-0.148=-0.000

cache=y

dps=1

iters=10

policies=100

*mean*	43.785-43.395=0.390
σ	0.007-0.006=0.001
min	43.778-43.388=0.390
max	43.803-43.406=0.397

*mean*	415.000-419.000=-4.000
σ	0.000
min	415.000-419.000=-4.000
max	415.000-419.000=-4.000

*mean*	0.123-0.122=0.000
σ	0.004-0.005=-0.001
min	0.119-0.116=0.002
max	0.129-0.131=-0.002

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on indexed

*mean*	36.618
σ	0.002
min	36.616
max	36.620

*mean*	4264.250
σ	1881.689
min	1980.000
max	7554.000

*mean*	12.418
σ	0.325
min	11.911
max	12.872

op=column_set() on indexed, repeat

*mean*	36.617
σ	0.002
min	36.615
max	36.619

*mean*	4264.250
σ	1881.689
min	1980.000
max	7554.000

*mean*	12.155
σ	0.712
min	11.200
max	13.137

op=table_records(), no indexes

*mean*	41.928
σ	0.000
min	41.928
max	41.929

*mean*	7554.000
σ	0.000
min	7554.000
max	7554.000

*mean*	13.786
σ	1.103
min	12.418
max	15.351

op=table_records(), repeat

*mean*	41.928
σ	0.002
min	41.927
max	41.931

*mean*	4264.250
σ	1881.689
min	1980.000
max	7554.000

*mean*	11.480
σ	1.425
min	9.999
max	13.584

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

*mean*	27.605
σ	0.002
min	27.603
max	27.607

*mean*	4264.250
σ	1881.689
min	1980.000
max	7554.000

*mean*	8.233
σ	0.380
min	7.672
max	8.723

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

*mean*	26.401
σ	0.002
min	26.399
max	26.403

*mean*	4264.250
σ	1881.689
min	1980.000
max	7554.000

*mean*	6.319
σ	0.287
min	5.724
max	6.626

op=vertical_lookup_row_list() on 2 indexed

*mean*	25.666
σ	0.002
min	25.665
max	25.670

*mean*	4264.250
σ	1881.689
min	1980.000
max	7554.000

*mean*	5.392
σ	0.140
min	5.131
max	5.574

op=vertical_lookup_row_list() on 3 (1 unindexed)

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4264.250
σ	1881.689
min	1980.000
max	7554.000

*mean*	5.235
σ	0.109
min	5.041
max	5.361

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

*mean*	2524.593
σ	0.000
min	2524.593
max	2524.594

*mean*	7554.000
σ	0.000
min	7554.000
max	7554.000

*mean*	1056.196
σ	7.960
min	1049.617
max	1074.040

op=load_product(), with indexes

*mean*	8744.558
σ	0.033
min	8744.545
max	8744.640

*mean*	3785.625
σ	1609.980
min	1980.000
max	5947.000

*mean*	4777.785
σ	1459.423
min	3525.532
max	7066.017

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4264.250
σ	1881.689
min	1980.000
max	7554.000

*mean*	81.000
σ	8.674
min	70.773
max	93.578

op=vertical_lookup_list() on unindexed missing Int

*mean*	40.944
σ	0.001
min	40.944
max	40.945

*mean*	7554.000
σ	0.000
min	7554.000
max	7554.000

*mean*	241.074
σ	400.122
min	88.826
max	1231.167

op=vertical_lookup_row_list() on unindexed small unique Int

*mean*	66.686
σ	0.000
min	66.685
max	66.687

*mean*	7554.000
σ	0.000
min	7554.000
max	7554.000

*mean*	153.695
σ	12.046
min	141.055
max	168.456

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.832
σ	4.317
min	11655.305
max	11667.517

*mean*	4264.250
σ	1881.689
min	1980.000
max	7554.000

*mean*	6566.865
σ	1368.204
min	4962.939
max	8266.577

op=vertical_lookup_list() on indexed

*mean*	11560.069
σ	0.002
min	11560.066
max	11560.072

*mean*	7554.000
σ	0.000
min	7554.000
max	7554.000

*mean*	4947.378
σ	753.097
min	4388.193
max	6264.194

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.581
σ	0.028
min	172.558
max	172.630

*mean*	1980.000
σ	0.000
min	1980.000
max	1980.000

*mean*	368.868
σ	26.276
min	345.919
max	412.541

op=pointedIndexFromKvs

rows=400000

*mean*	357.365
σ	0.042
min	357.321
max	357.409

*mean*	1980.000
σ	0.000
min	1980.000
max	1980.000

*mean*	782.041
σ	40.622
min	682.865
max	807.872

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.180-1006.926=1.255
σ	0.946-0.867=0.079
min	1007.719-1006.428=1.290
max	1012.128-1010.512=1.616

*mean*	1051.400-1055.200=-3.800
σ	312.621-314.625=-2.003
min	588.000-557.000=31.000
max	1513.000-1630.000=-117.000

*mean*	1.569-1.537=0.032
σ	0.141-0.072=0.069
min	1.462-1.455=0.007
max	2.070-1.724=0.346

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.884-0.883=0.000
σ	0.003-0.003=0.000
min	0.881-0.882=-0.000
max	0.887-0.887=0.001

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	0.424-0.414=0.010
σ	0.126-0.137=-0.011
min	0.358-0.326=0.032
max	0.648-0.654=-0.006

name=error_case.art

*mean*	2.333-2.339=-0.005
σ	0.003
min	2.332-2.337=-0.005
max	2.337-2.342=-0.005

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	0.878-0.871=0.007
σ	0.089-0.101=-0.012
min	0.797-0.813=-0.016
max	1.030-1.050=-0.020

name=heavy_item.art

*mean*	1.521-1.524=-0.002
σ	0.002
min	1.520-1.522=-0.002
max	1.524-1.526=-0.002

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	0.545-0.522=0.023
σ	0.047-0.051=-0.004
min	0.502-0.479=0.023
max	0.619-0.606=0.013

name=nested_use.art

*mean*	2.355-2.361=-0.006
σ	0.002-0.002=0.000
min	2.355-2.360=-0.005
max	2.358-2.364=-0.005

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	0.843-0.830=0.012
σ	0.041-0.037=0.005
min	0.822-0.793=0.028
max	0.917-0.881=0.035

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.548-964.839=-1.291
σ	0.035-0.034=0.001
min	963.523-964.811=-1.288
max	963.609-964.894=-1.285

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	0.821-0.846=-0.025
σ	0.061-0.018=0.042
min	0.722-0.816=-0.094
max	0.869-0.862=0.007

name=cdr_enhanced_4k_loc.art

*mean*	884.854-885.511=-0.658
σ	0.006-0.008=-0.002
min	884.847-885.504=-0.657
max	884.861-885.522=-0.662

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	0.707-0.733=-0.025
σ	0.080-0.017=0.063
min	0.564-0.704=-0.139
max	0.750-0.746=0.003

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.706-7.716=-0.010
σ	0.002-0.002=-0.000
min	7.705-7.715=-0.010
max	7.709-7.720=-0.011

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	4.231-4.207=0.025
σ	0.105-0.093=0.012
min	4.099-4.059=0.040
max	4.886-4.686=0.200

name=record_render_large_syntax_err.art

*mean*	7.655-7.665=-0.010
σ	0.002
min	7.654-7.664=-0.010
max	7.658-7.668=-0.010

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	4.221-4.179=0.042
σ	0.079-0.058=0.021
min	4.054-4.041=0.014
max	4.533-4.384=0.148

name=record_render_success.art

*mean*	2.288-2.291=-0.003
σ	0.002
min	2.287-2.290=-0.003
max	2.291-2.294=-0.003

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	0.741-0.743=-0.003
σ	0.017-0.021=-0.004
min	0.707-0.708=-0.001
max	0.855-0.870=-0.015

name=record_render_syntax_err.art

*mean*	2.163-2.166=-0.002
σ	0.002
min	2.163-2.165=-0.002
max	2.166-2.169=-0.002

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	0.699-0.700=-0.001
σ	0.013-0.014=-0.001
min	0.672-0.667=0.005
max	0.755-0.761=-0.006

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.326-295.344=1.982
σ	0.227-0.280=-0.053
min	297.199-295.006=2.193
max	297.945-296.050=1.894

*mean*	1980.000-1897.000=83.000
σ	0.000
min	1980.000-1897.000=83.000
max	1980.000-1897.000=83.000

*mean*	0.538-0.575=-0.036
σ	0.012-0.050=-0.038
min	0.514-0.504=0.010
max	0.554-0.683=-0.129

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.774-285.363=4.411
σ	0.040-0.037=0.003
min	289.718-285.315=4.402
max	289.818-285.401=4.416

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	0.401-0.391=0.010
σ	0.011-0.006=0.005
min	0.394-0.381=0.012
max	0.420-0.397=0.024

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.657-1295.742=3.914
σ	0.068-0.111=-0.044
min	1299.577-1295.626=3.951
max	1299.713-1295.882=3.831

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	2.100-1.921=0.178
σ	0.070-0.089=-0.019
min	2.010-1.826=0.183
max	2.164-2.024=0.141

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.603-1539.849=2.754
σ	4.028-6.825=-2.797
min	1540.581-1536.560=4.021
max	1549.799-1552.054=-2.255

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	2.230-2.296=-0.066
σ	0.140-0.263=-0.123
min	2.103-2.040=0.063
max	2.401-2.680=-0.280

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.625-1857.652=3.974
σ	0.072-0.062=0.010
min	1861.520-1857.573=3.947
max	1861.706-1857.730=3.976

*mean*	1774.600-1771.000=3.600
σ	211.590-126.892=84.698
min	1513.000-1630.000=-117.000
max	1980.000-1897.000=83.000

*mean*	3.250-3.091=0.159
σ	0.336-0.273=0.064
min	2.897-2.883=0.014
max	3.678-3.563=0.114

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.645-1.252=0.394
σ	0.254-0.287=-0.032
min	1.307-0.950=0.357
max	1.846-1.621=0.225

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.185-445.488=0.697
σ	577.140-580.640=-3.500
min	157.613-155.166=2.446
max	1311.896-1316.449=-4.553

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	0.545-0.526=0.019
σ	0.553-0.541=0.012
min	0.263-0.253=0.010
max	1.375-1.338=0.037

policies=20

*mean*	1576.415-1551.937=24.478
σ	0.334-0.337=-0.002
min	1576.186-1551.706=24.481
max	1576.912-1552.437=24.475

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	2.613-2.599=0.014
σ	0.008-0.008=-0.000
min	2.608-2.590=0.018
max	2.624-2.609=0.015

policies=200

*mean*	15772.314-15527.633=244.681
σ	0.138-0.123=0.015
min	15772.203-15527.500=244.702
max	15772.493-15527.798=244.695

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1513.000-1630.000=-117.000
σ	0.000
min	1513.000-1630.000=-117.000
max	1513.000-1630.000=-117.000

*mean*	26.545-26.141=0.404
σ	0.268-0.046=0.222
min	26.349-26.103=0.246
max	26.941-26.208=0.732