Compare commits

Home / Compare 285c8ca9 .. e80d2701

grey: no significant change wrt stddev
red: change exceeding max stddev
purple: some change, not seemingly significant

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.618-54.054=0.564
σ0.350-0.371=-0.020
min54.487-53.908=0.579
max55.614-55.108=0.506
mean415.000-414.000=1.000
σ0.000
min415.000-414.000=1.000
max415.000-414.000=1.000
mean0.143-0.139=0.004
σ0.004-0.006=-0.002
min0.140-0.130=0.010
max0.150-0.147=0.003
cache=y
dps=1
iters=10
policies=100
mean43.786-43.393=0.393
σ0.006-0.006=0.000
min43.779-43.386=0.393
max43.801-43.401=0.400
mean415.000-414.000=1.000
σ0.000
min415.000-414.000=1.000
max415.000-414.000=1.000
mean0.123-0.123=-0.000
σ0.006-0.004=0.002
min0.117-0.119=-0.002
max0.134-0.128=0.005

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.616
max36.620
mean4255.000
σ1890.468
min1906.000
max7543.000
mean12.055
σ0.137
min11.813
max12.219
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.615
max36.620
mean4255.000
σ1890.468
min1906.000
max7543.000
mean12.095
σ0.721
min11.175
max13.229
op=table_records(), no indexes
mean41.932
σ0.000
min41.932
max41.933
mean7543.000
σ0.000
min7543.000
max7543.000
mean13.984
σ1.172
min12.364
max15.866
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4255.000
σ1890.468
min1906.000
max7543.000
mean11.726
σ2.076
min10.131
max15.127
op=vertical_lookup_list() on indexed, after table_records()
mean27.605
σ0.002
min27.603
max27.609
mean4255.000
σ1890.468
min1906.000
max7543.000
mean8.135
σ0.405
min7.523
max8.552
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4255.000
σ1890.468
min1906.000
max7543.000
mean6.036
σ0.292
min5.683
max6.511
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.670
mean4255.000
σ1890.468
min1906.000
max7543.000
mean5.272
σ0.134
min5.037
max5.407
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.971
mean4255.000
σ1890.468
min1906.000
max7543.000
mean5.169
σ0.171
min4.987
max5.541

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.597
σ0.000
min2524.597
max2524.597
mean7543.000
σ0.000
min7543.000
max7543.000
mean1045.233
σ5.036
min1037.939
max1053.934
op=load_product(), with indexes
mean8744.559
σ0.033
min8744.544
max8744.640
mean3767.125
σ1632.038
min1906.000
max5942.000
mean4700.212
σ1653.118
min3518.721
max7611.528

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.077
σ0.002
min62.076
max62.080
mean4255.000
σ1890.468
min1906.000
max7543.000
mean81.012
σ10.420
min70.323
max100.593
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean7543.000
σ0.000
min7543.000
max7543.000
mean236.079
σ383.081
min86.399
max1183.934
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean7543.000
σ0.000
min7543.000
max7543.000
mean153.043
σ13.022
min135.858
max167.964

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.317
min11655.305
max11667.517
mean4255.000
σ1890.468
min1906.000
max7543.000
mean6270.979
σ1013.191
min4944.491
max7500.995
op=vertical_lookup_list() on indexed
mean11560.065
σ0.001
min11560.064
max11560.069
mean7543.000
σ0.000
min7543.000
max7543.000
mean5357.525
σ1341.719
min4352.236
max7443.930

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.584
σ0.026
min172.558
max172.626
mean1906.000
σ0.000
min1906.000
max1906.000
mean363.098
σ44.801
min265.273
max407.409
op=pointedIndexFromKvs
rows=400000
mean357.358
σ0.035
min357.321
max357.393
mean1906.000
σ0.000
min1906.000
max1906.000
mean743.354
σ67.078
min637.480
max799.626

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.185-1007.006=1.179
σ0.918-1.189=-0.271
min1007.713-1006.434=1.279
max1012.008-1011.987=0.021
mean1039.000-1055.100=-16.100
σ293.507-314.791=-21.284
min543.000-585.000=-42.000
max1436.000-1618.000=-182.000
mean1.527-1.530=-0.003
σ0.113-0.053=0.061
min1.327-1.459=-0.133
max1.872-1.631=0.241

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883-0.883=-0.000
σ0.002-0.003=-0.000
min0.881-0.882=-0.000
max0.886-0.887=-0.001
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean0.442-0.447=-0.005
σ0.169-0.147=0.022
min0.337-0.362=-0.025
max0.742-0.705=0.037
name=error_case.art
mean2.333-2.339=-0.005
σ0.003
min2.332-2.337=-0.005
max2.337-2.342=-0.005
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean0.935-0.940=-0.005
σ0.172-0.214=-0.043
min0.837-0.827=0.010
max1.240-1.322=-0.082
name=heavy_item.art
mean1.521-1.524=-0.002
σ0.002
min1.520-1.522=-0.002
max1.524-1.526=-0.002
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean0.562-0.554=0.008
σ0.043-0.057=-0.013
min0.531-0.487=0.043
max0.635-0.615=0.019
name=nested_use.art
mean2.355-2.361=-0.005
σ0.002
min2.355-2.360=-0.005
max2.358-2.364=-0.005
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean0.852-0.868=-0.016
σ0.044-0.039=0.006
min0.817-0.843=-0.026
max0.925-0.936=-0.012

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.543-964.840=-1.297
σ0.026-0.035=-0.009
min963.523-964.810=-1.287
max963.586-964.898=-1.312
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean0.781-0.810=-0.028
σ0.053-0.060=-0.007
min0.694-0.727=-0.034
max0.824-0.861=-0.036
name=cdr_enhanced_4k_loc.art
mean884.854-885.513=-0.659
σ0.006-0.008=-0.002
min884.847-885.506=-0.659
max884.862-885.525=-0.663
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean0.732-0.696=0.035
σ0.022-0.039=-0.016
min0.692-0.648=0.045
max0.745-0.751=-0.006

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706-7.716=-0.010
σ0.002-0.002=-0.000
min7.705-7.715=-0.010
max7.711-7.720=-0.010
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean4.227-4.281=-0.054
σ0.082-0.080=0.003
min4.065-4.132=-0.067
max4.521-4.671=-0.150
name=record_render_large_syntax_err.art
mean7.655-7.665=-0.010
σ0.002
min7.654-7.664=-0.010
max7.658-7.668=-0.010
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean4.207-4.262=-0.055
σ0.061-0.117=-0.056
min4.099-4.096=0.003
max4.399-5.012=-0.612
name=record_render_success.art
mean2.288-2.291=-0.003
σ0.002
min2.287-2.290=-0.003
max2.291-2.294=-0.003
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean0.764-0.750=0.014
σ0.016-0.017=-0.001
min0.737-0.711=0.025
max0.856-0.863=-0.007
name=record_render_syntax_err.art
mean2.163-2.166=-0.002
σ0.002
min2.163-2.165=-0.002
max2.166-2.169=-0.002
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean0.721-0.703=0.018
σ0.018-0.015=0.003
min0.691-0.674=0.017
max0.805-0.780=0.025

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.521-296.935=0.586
σ0.148-0.246=-0.098
min297.255-296.719=0.535
max297.844-297.559=0.285
mean1906.000-2032.000=-126.000
σ0.000
min1906.000-2032.000=-126.000
max1906.000-2032.000=-126.000
mean0.563-0.577=-0.014
σ0.050-0.020=0.029
min0.507-0.537=-0.031
max0.627-0.595=0.031

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.774-286.818=2.956
σ0.037-0.039=-0.002
min289.725-286.767=2.958
max289.813-286.858=2.955
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean0.405-0.396=0.010
σ0.014-0.005=0.008
min0.394-0.388=0.005
max0.426-0.400=0.026
iters=5
new-facts=1
prior-facts=6402
mean1299.600-1297.211=2.389
σ0.086-0.121=-0.035
min1299.492-1297.088=2.404
max1299.711-1297.363=2.347
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean1.875-1.879=-0.004
σ0.070-0.094=-0.024
min1.803-1.804=-0.001
max1.958-2.017=-0.058
iters=5
new-facts=6402
prior-facts=1
mean1542.601-1541.335=1.265
σ4.042-6.843=-2.800
min1540.582-1538.054=2.528
max1549.825-1553.573=-3.748
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean2.244-2.230=0.013
σ0.168-0.156=0.012
min2.124-2.119=0.005
max2.537-2.489=0.048
iters=5
new-facts=6402
prior-facts=6402
mean1861.632-1859.123=2.509
σ0.055-0.065=-0.010
min1861.580-1859.032=2.548
max1861.714-1859.199=2.515
mean1741.200-1763.000=-21.800
σ176.164-178.827=-2.663
min1495.000-1618.000=-123.000
max1906.000-2032.000=-126.000
mean2.941-2.891=0.050
σ0.215-0.145=0.070
min2.742-2.777=-0.035
max3.306-3.143=0.163

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.785-1.228=0.557
σ0.221-0.363=-0.142
min1.398-0.932=0.466
max1.939-1.843=0.096

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.184-448.821=-2.637
σ577.140-581.372=-4.232
min157.611-158.131=-0.520
max1311.894-1320.880=-8.986
mean96.250
σ8.500
min92.000
max109.000
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean0.539-0.533=0.006
σ0.557-0.538=0.020
min0.258-0.260=-0.002
max1.374-1.339=0.035
policies=20
mean1576.419-1581.621=-5.202
σ0.345-0.340=0.005
min1576.185-1581.390=-5.205
max1576.931-1582.126=-5.194
mean920.000
σ0.000
min920.000
max920.000
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean2.613-2.608=0.004
σ0.033-0.014=0.019
min2.579-2.591=-0.011
max2.658-2.623=0.035
policies=200
mean15772.192-15824.268=-52.076
σ0.105-0.067=0.038
min15772.092-15824.218=-52.126
max15772.291-15824.366=-52.074
mean9200.000
σ0.000
min9200.000
max9200.000
mean1436.000-1618.000=-182.000
σ0.000
min1436.000-1618.000=-182.000
max1436.000-1618.000=-182.000
mean26.310-26.573=-0.263
σ0.104-0.048=0.055
min26.224-26.517=-0.294
max26.455-26.630=-0.175