b262a268dc9ba62b96a35266bbcb42dce7e0eaf8

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

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.622
σ0.349
min54.500
max55.616
mean420.000
σ0.000
min420.000
max420.000
mean0.141
σ0.005
min0.137
max0.149
cache=y
dps=1
iters=10
policies=100
mean43.787
σ0.007
min43.780
max43.803
mean420.000
σ0.000
min420.000
max420.000
mean0.120
σ0.006
min0.115
max0.130

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.616
max36.620
mean4156.125
σ1907.076
min1552.000
max7325.000
mean12.554
σ0.242
min12.241
max12.886
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.620
mean4156.125
σ1907.076
min1552.000
max7325.000
mean12.800
σ0.740
min11.432
max13.621
op=table_records(), no indexes
mean41.932
σ0.001
min41.928
max41.933
mean7325.000
σ0.000
min7325.000
max7325.000
mean15.298
σ0.987
min13.173
max16.573
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4156.125
σ1907.076
min1552.000
max7325.000
mean13.079
σ1.698
min11.264
max15.040
op=vertical_lookup_list() on indexed, after table_records()
mean27.653
σ0.136
min27.603
max27.990
mean4156.125
σ1907.076
min1552.000
max7325.000
mean8.994
σ0.338
min8.538
max9.622
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4156.125
σ1907.076
min1552.000
max7325.000
mean6.668
σ0.243
min6.383
max7.053
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.668
mean4156.125
σ1907.076
min1552.000
max7325.000
mean5.926
σ0.176
min5.631
max6.121
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.972
mean4156.125
σ1907.076
min1552.000
max7325.000
mean5.759
σ0.141
min5.490
max5.944

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606
σ0.000
min2524.606
max2524.607
mean7325.000
σ0.000
min7325.000
max7325.000
mean1042.408
σ7.925
min1032.537
max1057.853
op=load_product(), with indexes
mean8744.722
σ0.469
min8744.553
max8745.883
mean3578.000
σ1801.868
min1045.000
max5814.000
mean4723.743
σ1346.062
min3536.390
max6669.906

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.081
mean4156.125
σ1907.076
min1552.000
max7325.000
mean83.899
σ11.819
min70.085
max103.277
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.943
max40.945
mean7325.000
σ0.000
min7325.000
max7325.000
mean105.301
σ5.993
min94.012
max111.278
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean7325.000
σ0.000
min7325.000
max7325.000
mean161.179
σ9.935
min139.253
max167.646

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.836
σ4.324
min11655.305
max11667.538
mean4156.125
σ1907.076
min1552.000
max7325.000
mean6402.172
σ946.629
min4886.051
max7725.148
op=vertical_lookup_list() on indexed
mean11560.065
σ0.001
min11560.064
max11560.066
mean7325.000
σ0.000
min7325.000
max7325.000
mean5852.876
σ1508.979
min4384.165
max7769.029

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
mean375.021
σ21.823
min347.262
max394.879
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean560.625
σ0.518
min560.000
max561.000
mean748.412
σ57.767
min638.654
max798.328

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.377
σ0.759
min1007.903
max1011.515
mean1047.600
σ313.259
min574.000
max1510.000
mean1.524
σ0.090
min1.375
max1.739

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.386
σ0.472
min0.143
max1.227
name=error_case.art
mean2.338
σ0.012
min2.332
max2.359
mean402.000
σ0.000
min402.000
max402.000
mean0.485
σ0.332
min0.316
max1.078
name=heavy_item.art
mean1.522
σ0.002
min1.520
max1.524
mean402.000
σ0.000
min402.000
max402.000
mean0.215
σ0.024
min0.198
max0.254
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean402.000
σ0.000
min402.000
max402.000
mean0.324
σ0.015
min0.311
max0.349

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.908
σ0.011
min963.902
max963.926
mean434.600
σ1.517
min432.000
max436.000
mean0.544
σ0.056
min0.452
max0.595
name=cdr_enhanced_4k_loc.art
mean884.884
σ0.002
min884.883
max884.886
mean436.000
σ0.000
min436.000
max436.000
mean0.496
σ0.035
min0.447
max0.530

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean436.000
σ0.000
min436.000
max436.000
mean2.594
σ0.087
min2.436
max2.868
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean436.000
σ0.000
min436.000
max436.000
mean2.576
σ0.079
min2.447
max2.900
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean436.000
σ0.000
min436.000
max436.000
mean0.305
σ0.008
min0.292
max0.348
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean436.000
σ0.000
min436.000
max436.000
mean0.294
σ0.021
min0.274
max0.483

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.953
σ1.044
min297.559
max300.923
mean445.200
σ18.719
min417.000
max472.000
mean0.613
σ0.013
min0.595
max0.637

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean222.008
σ0.000
min222.008
max222.008
mean1746.000
σ0.000
min1746.000
max1746.000
mean202.615
σ3.136
min198.955
max207.134
phase=macro expansion
mean6.130
σ0.000
min6.130
max6.130
mean1746.000
σ0.000
min1746.000
max1746.000
mean11.337
σ1.921
min7.604
max12.658
phase=parser
mean1041.163
σ0.000
min1041.162
max1041.163
mean1746.000
σ0.000
min1746.000
max1746.000
mean647.043
σ108.126
min430.619
max722.660
phase=processProdDef
mean6169.655
σ0.001
min6169.655
max6169.656
mean1746.000
σ0.000
min1746.000
max1746.000
mean5316.133
σ959.788
min3088.097
max6136.172
phase=renaming
mean21.667
σ0.000
min21.667
max21.667
mean1746.000
σ0.000
min1746.000
max1746.000
mean42.402
σ7.793
min26.788
max48.040
phase=type checker
mean958.537
σ0.066
min958.439
max958.626
mean1746.000
σ0.000
min1746.000
max1746.000
mean773.859
σ93.676
min639.642
max876.961

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean292.771
σ0.036
min292.720
max292.808
mean445.000
σ0.000
min445.000
max445.000
mean0.405
σ0.006
min0.398
max0.412
iters=5
new-facts=1
prior-facts=6402
mean1302.862
σ0.082
min1302.719
max1302.916
mean1088.000
σ168.468
min893.000
max1322.000
mean2.094
σ0.297
min1.776
max2.501
iters=5
new-facts=6402
prior-facts=1
mean1545.958
σ4.005
min1544.023
max1553.116
mean632.800
σ85.891
min503.000
max727.000
mean2.464
σ0.272
min2.164
max2.670
iters=5
new-facts=6402
prior-facts=6402
mean1864.834
σ0.033
min1864.783
max1864.869
mean1727.800
σ172.698
min1487.000
max1890.000
mean3.008
σ0.191
min2.823
max3.327

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.694
σ0.217
min1.403
max1.966

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean448.223
σ579.088
min158.672
max1316.854
mean98.250
σ8.500
min94.000
max111.000
mean444.000
σ0.000
min444.000
max444.000
mean0.533
σ0.538
min0.262
max1.341
policies=20
mean1587.092
σ0.363
min1586.839
max1587.630
mean940.000
σ0.000
min940.000
max940.000
mean446.000
σ2.309
min444.000
max448.000
mean2.629
σ0.007
min2.621
max2.636
policies=200
mean15879.030
σ0.039
min15878.990
max15879.077
mean9400.000
σ0.000
min9400.000
max9400.000
mean496.750
σ4.856
min492.000
max503.000
mean26.753
σ0.152
min26.593
max26.897