7c7b15952544e85ad9b62aebcf3d3ab7f57d8912

Home / Branches / sergei/exp-1403-deprecate-ff_teams-clean / 7c7b15952544e85ad9b62aebcf3d3ab7f57d8912

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.615
σ0.344
min54.485
max55.593
mean421.000
σ0.000
min421.000
max421.000
mean0.141
σ0.004
min0.137
max0.148
cache=y
dps=1
iters=10
policies=100
mean43.793
σ0.007
min43.781
max43.806
mean421.000
σ0.000
min421.000
max421.000
mean0.123
σ0.004
min0.119
max0.130

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4153.000
σ1898.540
min1556.000
max7298.000
mean12.737
σ0.253
min12.374
max13.163
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.619
mean4153.000
σ1898.540
min1556.000
max7298.000
mean12.733
σ0.500
min11.958
max13.356
op=table_records(), no indexes
mean41.931
σ0.001
min41.929
max41.932
mean7298.000
σ0.000
min7298.000
max7298.000
mean15.190
σ0.645
min13.701
max15.709
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.932
mean4153.000
σ1898.540
min1556.000
max7298.000
mean13.400
σ1.739
min11.310
max15.690
op=vertical_lookup_list() on indexed, after table_records()
mean27.653
σ0.137
min27.603
max27.991
mean4153.000
σ1898.540
min1556.000
max7298.000
mean9.000
σ0.463
min8.432
max9.895
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4153.000
σ1898.540
min1556.000
max7298.000
mean6.744
σ0.376
min6.325
max7.413
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.668
mean4153.000
σ1898.540
min1556.000
max7298.000
mean5.980
σ0.106
min5.822
max6.088
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.972
mean4153.000
σ1898.540
min1556.000
max7298.000
mean5.784
σ0.025
min5.752
max5.839

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606
σ0.000
min2524.606
max2524.607
mean7298.000
σ0.000
min7298.000
max7298.000
mean1324.640
σ520.695
min1035.251
max2530.279
op=load_product(), with indexes
mean8744.721
σ0.469
min8744.553
max8745.883
mean3572.625
σ1795.002
min1044.000
max5790.000
mean4947.233
σ1721.904
min3521.339
max7357.235

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.081
mean4153.000
σ1898.540
min1556.000
max7298.000
mean82.940
σ13.679
min70.274
max104.843
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean7298.000
σ0.000
min7298.000
max7298.000
mean105.384
σ5.109
min94.707
max109.839
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean7298.000
σ0.000
min7298.000
max7298.000
mean162.997
σ8.234
min144.414
max168.863

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.836
σ4.324
min11655.305
max11667.538
mean4153.000
σ1898.540
min1556.000
max7298.000
mean6564.454
σ1297.508
min4899.666
max8083.975
op=vertical_lookup_list() on indexed
mean11560.065
σ0.001
min11560.064
max11560.066
mean7298.000
σ0.000
min7298.000
max7298.000
mean5420.748
σ1058.963
min4343.321
max7083.232

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.559
σ0.001
min172.558
max172.562
mean477.000
σ0.000
min477.000
max477.000
mean378.980
σ18.931
min346.203
max390.830
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean562.000
σ0.000
min562.000
max562.000
mean705.825
σ68.971
min633.350
max782.019

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.191
σ0.757
min1007.720
max1011.321
mean1056.650
σ313.915
min582.000
max1526.000
mean1.545
σ0.077
min1.426
max1.771

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.891
σ0.020
min0.881
max0.928
mean402.000
σ0.000
min402.000
max402.000
mean0.389
σ0.499
min0.130
max1.278
name=error_case.art
mean2.338
σ0.012
min2.332
max2.359
mean402.000
σ0.000
min402.000
max402.000
mean0.482
σ0.323
min0.318
max1.059
name=heavy_item.art
mean1.522
σ0.002
min1.520
max1.524
mean402.000
σ0.000
min402.000
max402.000
mean0.221
σ0.025
min0.201
max0.264
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean402.000
σ0.000
min402.000
max402.000
mean0.335
σ0.014
min0.322
max0.356

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.908
σ0.011
min963.902
max963.926
mean430.000
σ0.000
min430.000
max430.000
mean0.569
σ0.046
min0.490
max0.611
name=cdr_enhanced_4k_loc.art
mean884.884
σ0.002
min884.883
max884.886
mean430.000
σ0.000
min430.000
max430.000
mean0.508
σ0.027
min0.474
max0.537

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean430.000
σ0.000
min430.000
max430.000
mean1.958
σ0.090
min1.796
max2.237
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean430.000
σ0.000
min430.000
max430.000
mean1.922
σ0.061
min1.805
max2.088
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean430.000
σ0.000
min430.000
max430.000
mean0.307
σ0.047
min0.288
max0.769
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean430.000
σ0.000
min430.000
max430.000
mean0.288
σ0.008
min0.273
max0.338

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.738
σ0.924
min297.260
max300.353
mean446.400
σ17.050
min426.000
max471.000
mean0.606
σ0.015
min0.576
max0.636

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean222.008
σ0.000
min222.008
max222.008
mean1660.125
σ116.233
min1431.000
max1746.000
mean207.577
σ2.570
min202.522
max210.841
phase=macro expansion
mean6.130
σ0.000
min6.130
max6.130
mean1660.125
σ116.233
min1431.000
max1746.000
mean11.831
σ1.451
min9.412
max12.738
phase=parser
mean1041.160
σ0.000
min1041.159
max1041.160
mean1660.125
σ116.233
min1431.000
max1746.000
mean686.329
σ59.828
min587.443
max723.941
phase=processProdDef
mean6169.661
σ0.001
min6169.660
max6169.662
mean1699.500
σ72.746
min1548.000
max1746.000
mean5703.615
σ1188.079
min4213.430
max7091.494
phase=renaming
mean21.671
σ0.000
min21.671
max21.671
mean1660.125
σ116.233
min1431.000
max1746.000
mean45.931
σ3.185
min40.601
max47.974
phase=type checker
mean958.670
σ0.066
min958.573
max958.760
mean1660.125
σ116.233
min1431.000
max1746.000
mean789.813
σ74.213
min663.998
max886.169

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean292.589
σ0.024
min292.571
max292.620
mean445.000
σ0.000
min445.000
max445.000
mean0.407
σ0.008
min0.398
max0.415
iters=5
new-facts=1
prior-facts=6402
mean1302.682
σ0.103
min1302.499
max1302.736
mean1087.000
σ169.105
min891.000
max1322.000
mean2.142
σ0.361
min1.827
max2.721
iters=5
new-facts=6402
prior-facts=1
mean1545.740
σ4.034
min1543.800
max1552.952
mean631.200
σ85.034
min503.000
max724.000
mean2.382
σ0.337
min2.097
max2.795
iters=5
new-facts=6402
prior-facts=6402
mean1864.646
σ0.043
min1864.591
max1864.698
mean1728.200
σ176.728
min1485.000
max1896.000
mean3.070
σ0.267
min2.886
max3.541

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.691
σ0.261
min1.271
max1.912

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean448.971
σ579.122
min159.409
max1317.654
mean96.000
σ8.000
min92.000
max108.000
mean447.000
σ0.000
min447.000
max447.000
mean0.541
σ0.544
min0.266
max1.357
policies=20
mean1594.409
σ0.348
min1594.162
max1594.923
mean920.000
σ0.000
min920.000
max920.000
mean447.000
σ0.000
min447.000
max447.000
mean2.620
σ0.023
min2.586
max2.640
policies=200
mean15952.015
σ0.111
min15951.922
max15952.175
mean9200.000
σ0.000
min9200.000
max9200.000
mean498.750
σ6.500
min490.000
max505.000
mean26.718
σ0.185
min26.533
max26.953