Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617-54.054=0.563
σ	0.353-0.369=-0.016
min	54.483-53.901=0.582
max	55.621-55.103=0.517

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

*mean*	0.140-0.136=0.003
σ	0.004-0.008=-0.004
min	0.135-0.121=0.015
max	0.146-0.149=-0.002

cache=y

dps=1

iters=10

policies=100

*mean*	43.786-43.393=0.393
σ	0.007-0.006=0.001
min	43.778-43.385=0.393
max	43.801-43.405=0.397

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

*mean*	0.123-0.119=0.004
σ	0.004-0.004=-0.000
min	0.120-0.114=0.006
max	0.130-0.127=0.003

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on indexed

*mean*	36.618
σ	0.003
min	36.615
max	36.623

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	12.965
σ	1.845
min	11.906
max	17.485

op=column_set() on indexed, repeat

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	13.339
σ	1.704
min	12.435
max	17.532

op=table_records(), no indexes

*mean*	41.928
σ	0.000
min	41.928
max	41.928

*mean*	7535.000
σ	0.000
min	7535.000
max	7535.000

*mean*	13.764
σ	1.089
min	12.704
max	15.774

op=table_records(), repeat

*mean*	41.928
σ	0.002
min	41.927
max	41.932

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	12.288
σ	2.170
min	10.164
max	14.880

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

*mean*	27.605
σ	0.002
min	27.603
max	27.607

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	8.575
σ	1.366
min	7.635
max	11.847

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

*mean*	26.401
σ	0.002
min	26.399
max	26.403

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	6.741
σ	1.140
min	6.057
max	9.520

op=vertical_lookup_row_list() on 2 indexed

*mean*	25.666
σ	0.002
min	25.664
max	25.670

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	5.533
σ	0.566
min	5.134
max	6.903

op=vertical_lookup_row_list() on 3 (1 unindexed)

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	5.394
σ	0.483
min	5.055
max	6.567

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

*mean*	1103.878
σ	161.657
min	1038.142
max	1503.619

op=load_product(), with indexes

*mean*	8744.558
σ	0.033
min	8744.544
max	8744.640

*mean*	3793.875
σ	1596.206
min	2018.000
max	5941.000

*mean*	4426.395
σ	1217.723
min	3532.249
max	6260.544

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

*mean*	62.077
σ	0.002
min	62.075
max	62.080

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	80.679
σ	9.784
min	71.686
max	101.646

op=vertical_lookup_list() on unindexed missing Int

*mean*	40.944
σ	0.001
min	40.943
max	40.945

*mean*	7535.000
σ	0.000
min	7535.000
max	7535.000

*mean*	101.022
σ	6.468
min	90.263
max	107.541

op=vertical_lookup_row_list() on unindexed small unique Int

*mean*	66.686
σ	0.000
min	66.685
max	66.687

*mean*	7535.000
σ	0.000
min	7535.000
max	7535.000

*mean*	151.047
σ	15.168
min	125.072
max	167.824

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.833
σ	4.317
min	11655.305
max	11667.517

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	6150.674
σ	1027.600
min	4966.317
max	8041.591

op=vertical_lookup_list() on indexed

*mean*	11560.068
σ	0.002
min	11560.066
max	11560.072

*mean*	7535.000
σ	0.000
min	7535.000
max	7535.000

*mean*	5466.772
σ	1386.395
min	4349.196
max	7396.168

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.588
σ	0.024
min	172.558
max	172.627

*mean*	2018.000
σ	0.000
min	2018.000
max	2018.000

*mean*	377.907
σ	39.261
min	341.882
max	457.952

op=pointedIndexFromKvs

rows=400000

*mean*	357.370
σ	0.045
min	357.321
max	357.428

*mean*	2018.000
σ	0.000
min	2018.000
max	2018.000

*mean*	762.389
σ	52.510
min	641.448
max	805.434

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.185-1007.005=1.181
σ	0.886-1.191=-0.305
min	1007.687-1006.434=1.253
max	1011.862-1011.997=-0.135

*mean*	1043.000-1050.350=-7.350
σ	307.729-307.622=0.106
min	547.000-575.000=-28.000
max	1475.000-1642.000=-167.000

*mean*	1.544-1.534=0.010
σ	0.082-0.074=0.007
min	1.460-1.463=-0.002
max	1.778-1.761=0.016

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.003=-0.000
min	0.881-0.882=-0.000
max	0.886-0.887=-0.001

*mean*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	0.402-0.417=-0.015
σ	0.109-0.137=-0.028
min	0.329-0.337=-0.008
max	0.596-0.660=-0.065

name=error_case.art

*mean*	2.334-2.339=-0.005
σ	0.002-0.003=-0.000
min	2.332-2.337=-0.005
max	2.337-2.342=-0.005

*mean*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	0.885-0.883=0.001
σ	0.085-0.088=-0.003
min	0.834-0.833=0.001
max	1.035-1.037=-0.002

name=heavy_item.art

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

*mean*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	0.537-0.542=-0.005
σ	0.051-0.052=-0.001
min	0.494-0.498=-0.004
max	0.623-0.631=-0.008

name=nested_use.art

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

*mean*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	0.848-0.848=0.000
σ	0.048-0.054=-0.006
min	0.814-0.802=0.012
max	0.930-0.930=0.000

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.543-964.838=-1.295
σ	0.024-0.035=-0.011
min	963.523-964.811=-1.288
max	963.583-964.896=-1.313

*mean*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	0.761-0.828=-0.067
σ	0.060-0.029=0.032
min	0.679-0.790=-0.111
max	0.839-0.852=-0.013

name=cdr_enhanced_4k_loc.art

*mean*	884.854-885.513=-0.659
σ	0.007-0.008=-0.000
min	884.847-885.505=-0.659
max	884.864-885.524=-0.660

*mean*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	0.712-0.681=0.031
σ	0.045-0.032=0.014
min	0.662-0.655=0.007
max	0.754-0.736=0.017

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.719=-0.010

*mean*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	4.282-4.214=0.068
σ	0.101-0.074=0.026
min	4.117-4.097=0.020
max	4.593-4.459=0.134

name=record_render_large_syntax_err.art

*mean*	7.655-7.665=-0.010
σ	0.002-0.002=0.000
min	7.654-7.664=-0.010
max	7.659-7.668=-0.009

*mean*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	4.256-4.210=0.047
σ	0.095-0.088=0.007
min	4.126-4.084=0.043
max	4.546-4.479=0.067

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*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	0.747-0.754=-0.008
σ	0.016-0.015=0.000
min	0.716-0.723=-0.007
max	0.858-0.846=0.012

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*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	0.708-0.712=-0.004
σ	0.016-0.015=0.001
min	0.682-0.684=-0.002
max	0.760-0.790=-0.029

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.605-296.900=0.705
σ	0.249-0.216=0.033
min	297.395-296.761=0.633
max	298.282-297.498=0.784

*mean*	2018.000-1936.000=82.000
σ	0.000
min	2018.000-1936.000=82.000
max	2018.000-1936.000=82.000

*mean*	0.561-0.578=-0.017
σ	0.035-0.052=-0.018
min	0.504-0.501=0.003
max	0.604-0.692=-0.088

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.775-286.815=2.960
σ	0.037-0.036=0.001
min	289.723-286.769=2.954
max	289.815-286.856=2.959

*mean*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	0.403-0.393=0.010
σ	0.011-0.005=0.006
min	0.396-0.389=0.007
max	0.422-0.402=0.021

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.618-1297.265=2.353
σ	0.091-0.040=0.052
min	1299.506-1297.211=2.296
max	1299.727-1297.304=2.422

*mean*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	1.856-2.199=-0.343
σ	0.067-0.148=-0.081
min	1.767-2.041=-0.274
max	1.922-2.436=-0.514

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.618-1541.315=1.303
σ	4.026-6.837=-2.811
min	1540.591-1538.080=2.511
max	1549.812-1553.541=-3.729

*mean*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	2.294-2.230=0.065
σ	0.168-0.152=0.017
min	2.065-2.102=-0.037
max	2.532-2.395=0.137

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.650-1859.113=2.538
σ	0.081-0.080=0.001
min	1861.549-1858.998=2.550
max	1861.733-1859.192=2.541

*mean*	1718.000-1785.400=-67.400
σ	204.666-147.003=57.663
min	1538.000-1642.000=-104.000
max	2018.000-1936.000=82.000

*mean*	3.017-3.029=-0.012
σ	0.320-0.169=0.151
min	2.822-2.846=-0.025
max	3.580-3.298=0.283

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.703-1.267=0.435
σ	0.127-0.318=-0.191
min	1.582-0.929=0.653
max	1.841-1.738=0.103

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.186-448.817=-2.631
σ	577.140-581.374=-4.234
min	157.614-158.128=-0.514
max	1311.895-1320.878=-8.983

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	0.553-0.526=0.027
σ	0.577-0.516=0.061
min	0.261-0.264=-0.003
max	1.418-1.300=0.119

policies=20

*mean*	1576.418-1581.607=-5.189
σ	0.342-0.368=-0.027
min	1576.189-1581.357=-5.168
max	1576.926-1582.154=-5.228

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	2.616-2.640=-0.024
σ	0.008-0.014=-0.006
min	2.608-2.623=-0.016
max	2.626-2.656=-0.030

policies=200

*mean*	15772.316-15824.190=-51.874
σ	0.119-0.167=-0.048
min	15772.229-15824.018=-51.789
max	15772.490-15824.414=-51.924

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1475.000-1642.000=-167.000
σ	0.000
min	1475.000-1642.000=-167.000
max	1475.000-1642.000=-167.000

*mean*	26.360-26.600=-0.239
σ	0.219-0.087=0.132
min	26.034-26.472=-0.437
max	26.497-26.661=-0.164