61ef181ec4709d0f3049f9cd44cc3d0c4c403944

Home / Branches / danieldiaz/bro-2220-create-backend-endpoints-for-team-subscriptions / 61ef181ec4709d0f3049f9cd44cc3d0c4c403944

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.626
σ0.348
min54.497
max55.615
mean418.000
σ0.000
min418.000
max418.000
mean0.148
σ0.011
min0.136
max0.169
cache=y
dps=1
iters=10
policies=100
mean43.787
σ0.007
min43.779
max43.800
mean418.000
σ0.000
min418.000
max418.000
mean0.122
σ0.006
min0.115
max0.132

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.619
mean4157.250
σ1908.864
min1552.000
max7329.000
mean12.953
σ0.264
min12.478
max13.206
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.620
mean4157.250
σ1908.864
min1552.000
max7329.000
mean13.128
σ0.512
min12.328
max13.718
op=table_records(), no indexes
mean41.932
σ0.001
min41.928
max41.933
mean7329.000
σ0.000
min7329.000
max7329.000
mean15.107
σ0.905
min13.183
max15.880
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4157.250
σ1908.864
min1552.000
max7329.000
mean12.677
σ1.854
min10.573
max14.972
op=vertical_lookup_list() on indexed, after table_records()
mean27.653
σ0.137
min27.603
max27.991
mean4157.250
σ1908.864
min1552.000
max7329.000
mean9.100
σ0.367
min8.589
max9.552
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4157.250
σ1908.864
min1552.000
max7329.000
mean7.114
σ0.256
min6.726
max7.522
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.668
mean4157.250
σ1908.864
min1552.000
max7329.000
mean6.057
σ0.116
min5.788
max6.163
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.972
mean4157.250
σ1908.864
min1552.000
max7329.000
mean5.932
σ0.121
min5.727
max6.104

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606
σ0.000
min2524.606
max2524.607
mean7329.000
σ0.000
min7329.000
max7329.000
mean1056.523
σ16.673
min1041.788
max1087.677
op=load_product(), with indexes
mean8744.721
σ0.469
min8744.553
max8745.883
mean3579.375
σ1803.308
min1046.000
max5818.000
mean4854.533
σ1449.037
min3547.713
max6782.126

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.081
mean4157.250
σ1908.864
min1552.000
max7329.000
mean80.564
σ9.760
min71.172
max101.528
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean7329.000
σ0.000
min7329.000
max7329.000
mean105.117
σ8.820
min85.257
max112.249
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean7329.000
σ0.000
min7329.000
max7329.000
mean161.036
σ13.158
min130.430
max169.066

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.836
σ4.324
min11655.305
max11667.537
mean4157.250
σ1908.864
min1552.000
max7329.000
mean6756.158
σ1251.974
min4994.491
max8175.345
op=vertical_lookup_list() on indexed
mean11560.065
σ0.001
min11560.064
max11560.066
mean7329.000
σ0.000
min7329.000
max7329.000
mean5339.720
σ1658.960
min4351.274
max9131.516

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
mean374.539
σ32.562
min299.549
max393.238
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean562.000
σ0.000
min562.000
max562.000
mean756.935
σ43.698
min658.609
max805.637

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.375
σ0.759
min1007.904
max1011.514
mean1039.850
σ300.615
min568.000
max1480.000
mean1.563
σ0.108
min1.480
max1.832

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.891
σ0.020
min0.881
max0.928
mean401.000
σ0.000
min401.000
max401.000
mean0.320
σ0.339
min0.141
max0.923
name=error_case.art
mean2.338
σ0.012
min2.332
max2.359
mean401.000
σ0.000
min401.000
max401.000
mean0.424
σ0.201
min0.324
max0.784
name=heavy_item.art
mean1.522
σ0.002
min1.520
max1.524
mean401.000
σ0.000
min401.000
max401.000
mean0.219
σ0.019
min0.200
max0.252
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean401.000
σ0.000
min401.000
max401.000
mean0.330
σ0.017
min0.319
max0.360

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.908
σ0.011
min963.902
max963.926
mean441.200
σ4.025
min434.000
max443.000
mean0.570
σ0.034
min0.536
max0.614
name=cdr_enhanced_4k_loc.art
mean884.884
σ0.002
min884.883
max884.886
mean443.000
σ0.000
min443.000
max443.000
mean0.515
σ0.021
min0.484
max0.537

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean443.000
σ0.000
min443.000
max443.000
mean1.991
σ0.098
min1.866
max2.613
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean443.000
σ0.000
min443.000
max443.000
mean1.978
σ0.078
min1.839
max2.231
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean443.000
σ0.000
min443.000
max443.000
mean0.318
σ0.033
min0.298
max0.558
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean443.000
σ0.000
min443.000
max443.000
mean0.294
σ0.007
min0.280
max0.327

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.999
σ1.005
min297.601
max300.850
mean440.800
σ15.796
min415.000
max461.000
mean0.618
σ0.010
min0.601
max0.630

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean222.011
σ0.000
min222.011
max222.011
mean1722.250
σ4.166
min1720.000
max1729.000
mean211.093
σ2.244
min206.871
max214.590
phase=macro expansion
mean6.133
σ0.000
min6.133
max6.133
mean1722.250
σ4.166
min1720.000
max1729.000
mean10.780
σ1.515
min9.401
max12.665
phase=parser
mean1041.161
σ0.000
min1041.160
max1041.161
mean1722.250
σ4.166
min1720.000
max1729.000
mean660.804
σ60.770
min567.659
max731.358
phase=processProdDef
mean6169.658
σ0.001
min6169.657
max6169.659
mean1723.375
σ4.658
min1720.000
max1729.000
mean5961.440
σ1193.484
min4105.031
max7488.209
phase=renaming
mean21.667
σ0.000
min21.667
max21.667
mean1722.250
σ4.166
min1720.000
max1729.000
mean44.405
σ5.385
min34.604
max49.853
phase=type checker
mean958.670
σ0.066
min958.573
max958.760
mean1722.250
σ4.166
min1720.000
max1729.000
mean760.168
σ66.663
min677.671
max885.674

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean292.772
σ0.036
min292.720
max292.808
mean445.000
σ0.000
min445.000
max445.000
mean0.409
σ0.005
min0.399
max0.413
iters=5
new-facts=1
prior-facts=6402
mean1302.842
σ0.077
min1302.746
max1302.917
mean1087.000
σ171.841
min889.000
max1320.000
mean1.974
σ0.192
min1.814
max2.224
iters=5
new-facts=6402
prior-facts=1
mean1545.926
σ4.009
min1543.992
max1553.092
mean624.200
σ88.234
min504.000
max724.000
mean2.352
σ0.216
min2.116
max2.589
iters=5
new-facts=6402
prior-facts=6402
mean1864.832
σ0.032
min1864.794
max1864.865
mean1723.200
σ166.911
min1488.000
max1880.000
mean2.992
σ0.135
min2.891
max3.221

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.910
σ0.063
min1.815
max1.967

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean448.238
σ579.120
min158.677
max1316.918
mean98.250
σ8.500
min94.000
max111.000
mean440.000
σ0.000
min440.000
max440.000
mean0.554
σ0.567
min0.264
max1.404
policies=20
mean1587.095
σ0.393
min1586.824
max1587.678
mean940.000
σ0.000
min940.000
max940.000
mean446.000
σ9.381
min440.000
max460.000
mean2.670
σ0.075
min2.613
max2.779
policies=200
mean15879.091
σ0.127
min15878.957
max15879.260
mean9400.000
σ0.000
min9400.000
max9400.000
mean494.000
σ4.243
min489.000
max498.000
mean26.795
σ0.203
min26.610
max27.000