1c294ba3db29e14348a0b1908e0bc77251dd243c

Home / Branches / danieldiaz/bro-2220-create-backend-endpoints-for-team-subscriptions / 1c294ba3db29e14348a0b1908e0bc77251dd243c

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.624
σ0.350
min54.490
max55.619
mean420.400
σ0.966
min419.000
max421.000
mean0.140
σ0.005
min0.133
max0.148
cache=y
dps=1
iters=10
policies=100
mean43.787
σ0.005
min43.779
max43.795
mean421.000
σ0.000
min421.000
max421.000
mean0.122
σ0.005
min0.116
max0.130

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4157.500
σ1907.207
min1556.000
max7330.000
mean12.403
σ0.323
min11.925
max12.976
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.620
mean4157.500
σ1907.207
min1556.000
max7330.000
mean11.944
σ0.556
min11.232
max13.044
op=table_records(), no indexes
mean41.931
σ0.001
min41.928
max41.932
mean7330.000
σ0.000
min7330.000
max7330.000
mean14.659
σ0.822
min12.696
max15.167
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4157.500
σ1907.207
min1556.000
max7330.000
mean12.098
σ1.900
min10.272
max14.797
op=vertical_lookup_list() on indexed, after table_records()
mean27.653
σ0.137
min27.603
max27.991
mean4157.500
σ1907.207
min1556.000
max7330.000
mean8.510
σ0.331
min8.024
max8.888
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4157.500
σ1907.207
min1556.000
max7330.000
mean6.632
σ0.376
min6.188
max7.449
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.668
mean4157.500
σ1907.207
min1556.000
max7330.000
mean5.453
σ0.232
min5.299
max5.961
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.972
mean4157.500
σ1907.207
min1556.000
max7330.000
mean5.360
σ0.248
min5.092
max5.744

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606
σ0.000
min2524.606
max2524.607
mean7330.000
σ0.000
min7330.000
max7330.000
mean1046.675
σ7.176
min1037.944
max1061.064
op=load_product(), with indexes
mean8744.722
σ0.469
min8744.554
max8745.883
mean3578.375
σ1802.723
min1044.000
max5816.000
mean4889.947
σ1575.562
min3519.310
max7496.421

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.080
mean4157.500
σ1907.207
min1556.000
max7330.000
mean83.333
σ10.965
min70.937
max99.457
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean7330.000
σ0.000
min7330.000
max7330.000
mean106.552
σ8.136
min88.054
max113.987
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean7330.000
σ0.000
min7330.000
max7330.000
mean162.041
σ11.651
min134.664
max168.916

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.836
σ4.324
min11655.305
max11667.538
mean4157.500
σ1907.207
min1556.000
max7330.000
mean6459.746
σ1207.809
min4956.328
max8067.259
op=vertical_lookup_list() on indexed
mean11560.065
σ0.001
min11560.064
max11560.066
mean7330.000
σ0.000
min7330.000
max7330.000
mean5458.316
σ1600.227
min4313.531
max8896.866

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
mean390.308
σ5.547
min381.322
max395.207
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean558.500
σ0.926
min558.000
max560.000
mean709.589
σ75.759
min599.031
max814.683

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.375
σ0.760
min1007.900
max1011.517
mean1048.350
σ294.883
min574.000
max1447.000
mean1.537
σ0.081
min1.386
max1.737

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.289
σ0.273
min0.145
max0.773
name=error_case.art
mean2.338
σ0.012
min2.332
max2.359
mean402.000
σ0.000
min402.000
max402.000
mean0.481
σ0.324
min0.326
max1.060
name=heavy_item.art
mean1.522
σ0.002
min1.520
max1.524
mean402.000
σ0.000
min402.000
max402.000
mean0.225
σ0.017
min0.210
max0.254
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean402.000
σ0.000
min402.000
max402.000
mean0.346
σ0.018
min0.332
max0.371

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.908
σ0.011
min963.902
max963.926
mean432.400
σ2.510
min430.000
max435.000
mean0.574
σ0.049
min0.489
max0.612
name=cdr_enhanced_4k_loc.art
mean884.884
σ0.002
min884.883
max884.886
mean435.000
σ0.000
min435.000
max435.000
mean0.488
σ0.032
min0.438
max0.524

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean435.000
σ0.000
min435.000
max435.000
mean2.607
σ0.111
min2.441
max3.097
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean435.000
σ0.000
min435.000
max435.000
mean2.582
σ0.075
min2.465
max2.798
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean435.000
σ0.000
min435.000
max435.000
mean0.309
σ0.011
min0.290
max0.362
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean435.000
σ0.000
min435.000
max435.000
mean0.294
σ0.009
min0.280
max0.345

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.909
σ1.012
min297.539
max300.788
mean443.900
σ15.996
min418.000
max469.000
mean0.612
σ0.016
min0.586
max0.647

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean222.011
σ0.000
min222.011
max222.011
mean1724.375
σ9.546
min1721.000
max1748.000
mean203.041
σ2.340
min200.322
max207.293
phase=macro expansion
mean6.133
σ0.000
min6.133
max6.133
mean1724.375
σ9.546
min1721.000
max1748.000
mean11.055
σ2.117
min7.464
max12.687
phase=parser
mean1041.161
σ0.000
min1041.160
max1041.161
mean1724.375
σ9.546
min1721.000
max1748.000
mean702.759
σ55.499
min585.450
max755.098
phase=processProdDef
mean6169.658
σ0.000
min6169.657
max6169.658
mean1727.750
σ12.499
min1721.000
max1748.000
mean5859.896
σ1526.815
min3988.767
max7609.087
phase=renaming
mean21.667
σ0.000
min21.667
max21.667
mean1724.375
σ9.546
min1721.000
max1748.000
mean44.205
σ7.656
min26.860
max50.035
phase=type checker
mean958.670
σ0.066
min958.573
max958.760
mean1724.375
σ9.546
min1721.000
max1748.000
mean755.249
σ38.083
min666.612
max781.311

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean292.770
σ0.036
min292.720
max292.808
mean444.000
σ0.000
min444.000
max444.000
mean0.403
σ0.005
min0.399
max0.411
iters=5
new-facts=1
prior-facts=6402
mean1302.846
σ0.083
min1302.736
max1302.939
mean1085.000
σ177.712
min886.000
max1331.000
mean1.983
σ0.211
min1.814
max2.255
iters=5
new-facts=6402
prior-facts=1
mean1545.930
σ4.022
min1543.972
max1553.119
mean623.800
σ89.352
min502.000
max725.000
mean2.379
σ0.248
min2.080
max2.631
iters=5
new-facts=6402
prior-facts=6402
mean1864.834
σ0.044
min1864.773
max1864.878
mean1723.600
σ168.328
min1478.000
max1873.000
mean3.011
σ0.272
min2.782
max3.476

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.778
σ0.137
min1.559
max1.885

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean448.237
σ579.118
min158.677
max1316.915
mean98.250
σ8.500
min94.000
max111.000
mean440.000
σ0.000
min440.000
max440.000
mean0.539
σ0.537
min0.264
max1.345
policies=20
mean1587.086
σ0.373
min1586.824
max1587.638
mean940.000
σ0.000
min940.000
max940.000
mean447.500
σ8.660
min440.000
max455.000
mean2.645
σ0.011
min2.632
max2.657
policies=200
mean15879.044
σ0.157
min15878.905
max15879.266
mean9400.000
σ0.000
min9400.000
max9400.000
mean495.500
σ5.000
min490.000
max502.000
mean26.781
σ0.179
min26.573
max26.979