Compare commits

Home / Compare cc498ae2 .. 6a71421f

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.617-54.054=0.563
σ0.350-0.369=-0.019
min54.479-53.911=0.569
max55.612-55.103=0.508
mean417.000-414.000=3.000
σ0.000
min417.000-414.000=3.000
max417.000-414.000=3.000
mean0.141-0.137=0.004
σ0.004-0.005=-0.001
min0.137-0.131=0.006
max0.150-0.148=0.002
cache=y
dps=1
iters=10
policies=100
mean43.786-43.393=0.393
σ0.007-0.006=0.001
min43.778-43.387=0.391
max43.801-43.403=0.399
mean417.000-414.000=3.000
σ0.000
min417.000-414.000=3.000
max417.000-414.000=3.000
mean0.123-0.122=0.001
σ0.004-0.004=-0.000
min0.119-0.117=0.002
max0.129-0.129=0.001

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4266.250
σ1878.767
min1981.000
max7547.000
mean12.276
σ0.204
min12.055
max12.719
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.620
mean4266.250
σ1878.767
min1981.000
max7547.000
mean12.743
σ0.131
min12.590
max12.930
op=table_records(), no indexes
mean41.928
σ0.000
min41.928
max41.929
mean7547.000
σ0.000
min7547.000
max7547.000
mean13.584
σ1.080
min12.141
max15.115
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4266.250
σ1878.767
min1981.000
max7547.000
mean12.016
σ1.931
min10.394
max15.090
op=vertical_lookup_list() on indexed, after table_records()
mean27.605
σ0.002
min27.603
max27.607
mean4266.250
σ1878.767
min1981.000
max7547.000
mean8.171
σ0.347
min7.770
max8.798
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4266.250
σ1878.767
min1981.000
max7547.000
mean6.290
σ0.195
min5.968
max6.570
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.669
mean4266.250
σ1878.767
min1981.000
max7547.000
mean5.343
σ0.166
min5.179
max5.646
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.971
mean4266.250
σ1878.767
min1981.000
max7547.000
mean5.203
σ0.109
min5.082
max5.397

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.594
σ0.000
min2524.594
max2524.594
mean7547.000
σ0.000
min7547.000
max7547.000
mean1042.968
σ5.881
min1035.009
max1050.305
op=load_product(), with indexes
mean8744.559
σ0.033
min8744.545
max8744.640
mean3789.125
σ1608.662
min1981.000
max5947.000
mean4331.244
σ1203.863
min3555.277
max6740.997

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.080
mean4266.250
σ1878.767
min1981.000
max7547.000
mean81.406
σ10.987
min68.738
max96.258
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.943
max40.945
mean7547.000
σ0.000
min7547.000
max7547.000
mean238.267
σ389.389
min88.115
max1201.760
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.686
mean7547.000
σ0.000
min7547.000
max7547.000
mean152.291
σ13.890
min136.005
max168.949

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.318
min11655.305
max11667.520
mean4266.250
σ1878.767
min1981.000
max7547.000
mean6259.788
σ1101.380
min4948.088
max7908.891
op=vertical_lookup_list() on indexed
mean11560.069
σ0.002
min11560.066
max11560.073
mean7547.000
σ0.000
min7547.000
max7547.000
mean5401.392
σ1269.671
min4386.568
max7427.751

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.580
σ0.023
min172.558
max172.619
mean1981.000
σ0.000
min1981.000
max1981.000
mean342.475
σ40.436
min264.384
max381.033
op=pointedIndexFromKvs
rows=400000
mean357.363
σ0.040
min357.321
max357.409
mean1981.000
σ0.000
min1981.000
max1981.000
mean713.053
σ78.759
min619.789
max788.266

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.186-1007.005=1.181
σ0.876-1.190=-0.315
min1007.687-1006.430=1.257
max1011.810-1011.993=-0.183
mean1040.150-1051.400=-11.250
σ297.286-307.928=-10.643
min548.000-576.000=-28.000
max1441.000-1644.000=-203.000
mean1.521-1.555=-0.034
σ0.086-0.081=0.005
min1.358-1.454=-0.096
max1.745-1.764=-0.019

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
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean0.413-0.423=-0.010
σ0.134-0.146=-0.012
min0.330-0.344=-0.014
max0.651-0.684=-0.033
name=error_case.art
mean2.333-2.339=-0.005
σ0.003
min2.332-2.337=-0.005
max2.337-2.342=-0.005
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean0.885-0.923=-0.037
σ0.085-0.195=-0.110
min0.831-0.821=0.010
max1.034-1.271=-0.237
name=heavy_item.art
mean1.521-1.524=-0.002
σ0.002
min1.520-1.522=-0.002
max1.524-1.526=-0.002
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean0.545-0.532=0.013
σ0.057-0.049=0.008
min0.495-0.497=-0.002
max0.641-0.615=0.027
name=nested_use.art
mean2.355-2.361=-0.005
σ0.002
min2.355-2.360=-0.005
max2.358-2.364=-0.005
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean0.845-0.845=-0.001
σ0.038-0.046=-0.008
min0.812-0.803=0.009
max0.906-0.917=-0.011

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.548-964.839=-1.291
σ0.035-0.034=0.001
min963.523-964.810=-1.287
max963.609-964.894=-1.285
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean0.827-0.825=0.002
σ0.059-0.032=0.027
min0.724-0.776=-0.053
max0.868-0.853=0.015
name=cdr_enhanced_4k_loc.art
mean884.854-885.511=-0.657
σ0.008-0.007=0.001
min884.847-885.504=-0.657
max884.866-885.522=-0.656
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean0.703-0.701=0.002
σ0.047-0.034=0.013
min0.643-0.665=-0.022
max0.738-0.738=0.000

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.713-7.719=-0.006
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean4.290-4.232=0.058
σ0.085-0.082=0.003
min4.135-4.075=0.060
max4.591-4.619=-0.028
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
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean4.290-4.213=0.077
σ0.076-0.069=0.007
min4.146-4.088=0.057
max4.596-4.429=0.167
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
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean0.741-0.743=-0.002
σ0.018-0.018=-0.000
min0.713-0.709=0.003
max0.852-0.861=-0.009
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
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean0.700-0.706=-0.006
σ0.014-0.015=-0.002
min0.676-0.675=0.002
max0.784-0.760=0.024

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.460-296.811=0.649
σ0.245-0.267=-0.022
min297.251-296.574=0.676
max298.103-297.538=0.565
mean1981.000-1941.000=40.000
σ0.000
min1981.000-1941.000=40.000
max1981.000-1941.000=40.000
mean0.598-0.597=0.001
σ0.012-0.021=-0.009
min0.579-0.573=0.006
max0.616-0.646=-0.031

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.780-286.830=2.950
σ0.040-0.039=0.001
min289.729-286.779=2.950
max289.822-286.871=2.951
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean0.402-0.394=0.008
σ0.013-0.007=0.006
min0.392-0.384=0.008
max0.425-0.401=0.024
iters=5
new-facts=1
prior-facts=6402
mean1299.623-1297.221=2.403
σ0.102-0.112=-0.009
min1299.511-1297.093=2.418
max1299.773-1297.351=2.422
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean1.926-1.905=0.021
σ0.049-0.094=-0.045
min1.870-1.801=0.069
max1.994-1.998=-0.004
iters=5
new-facts=6402
prior-facts=1
mean1542.608-1541.320=1.288
σ4.047-6.824=-2.777
min1540.582-1538.094=2.488
max1549.838-1553.523=-3.685
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean2.213-2.206=0.007
σ0.158-0.183=-0.026
min2.051-2.055=-0.004
max2.413-2.472=-0.058
iters=5
new-facts=6402
prior-facts=6402
mean1861.648-1859.121=2.527
σ0.069-0.059=0.009
min1861.562-1859.064=2.498
max1861.715-1859.200=2.515
mean1769.600-1786.800=-17.200
σ223.280-149.046=74.234
min1476.000-1644.000=-168.000
max1981.000-1941.000=40.000
mean3.112-2.961=0.150
σ0.296-0.173=0.123
min2.777-2.856=-0.079
max3.443-3.259=0.184

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.677-1.207=0.470
σ0.136-0.282=-0.145
min1.569-0.925=0.644
max1.857-1.670=0.187

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.148-448.820=-2.673
σ577.065-581.372=-4.307
min157.611-158.132=-0.521
max1311.745-1320.878=-9.133
mean96.250
σ8.500
min92.000
max109.000
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean0.536-0.562=-0.026
σ0.530-0.589=-0.059
min0.266-0.260=0.007
max1.330-1.445=-0.114
policies=20
mean1576.421-1581.610=-5.189
σ0.352-0.355=-0.003
min1576.182-1581.367=-5.185
max1576.944-1582.137=-5.193
mean920.000
σ0.000
min920.000
max920.000
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean2.630-2.630=0.001
σ0.026-0.009=0.017
min2.600-2.617=-0.017
max2.662-2.639=0.024
policies=200
mean15772.313-15824.164=-51.851
σ0.103-0.123=-0.020
min15772.243-15823.986=-51.743
max15772.465-15824.260=-51.795
mean9200.000
σ0.000
min9200.000
max9200.000
mean1441.000-1644.000=-203.000
σ0.000
min1441.000-1644.000=-203.000
max1441.000-1644.000=-203.000
mean26.452-26.457=-0.005
σ0.070-0.027=0.043
min26.382-26.435=-0.053
max26.544-26.494=0.049