8e33483fafe3cd172a2149b38a571387b1360e67

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

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.621
σ0.350
min54.491
max55.617
mean418.000
σ0.000
min418.000
max418.000
mean0.139
σ0.005
min0.132
max0.146
cache=y
dps=1
iters=10
policies=100
mean43.786
σ0.007
min43.774
max43.799
mean418.000
σ0.000
min418.000
max418.000
mean0.123
σ0.003
min0.120
max0.130

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4104.625
σ1569.243
min1983.000
max6044.000
mean12.429
σ0.267
min11.978
max12.856
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.615
max36.620
mean4104.625
σ1569.243
min1983.000
max6044.000
mean12.209
σ0.643
min11.375
max12.906
op=table_records(), no indexes
mean41.929
σ0.002
min41.928
max41.933
mean6044.000
σ0.000
min6044.000
max6044.000
mean13.319
σ1.177
min11.111
max14.826
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4104.625
σ1569.243
min1983.000
max6044.000
mean12.105
σ1.532
min10.297
max14.423
op=vertical_lookup_list() on indexed, after table_records()
mean27.605
σ0.002
min27.603
max27.607
mean4104.625
σ1569.243
min1983.000
max6044.000
mean8.359
σ0.388
min7.739
max8.861
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.399
max26.403
mean4104.625
σ1569.243
min1983.000
max6044.000
mean6.353
σ0.227
min6.012
max6.698
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.670
mean4104.625
σ1569.243
min1983.000
max6044.000
mean5.550
σ0.116
min5.343
max5.729
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.971
mean4104.625
σ1569.243
min1983.000
max6044.000
mean5.390
σ0.061
min5.289
max5.483

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.593
σ0.000
min2524.593
max2524.594
mean6044.000
σ0.000
min6044.000
max6044.000
mean1482.121
σ673.471
min1045.964
max2607.020
op=load_product(), with indexes
mean8744.559
σ0.033
min8744.545
max8744.640
mean3823.125
σ1648.322
min1983.000
max6044.000
mean4807.478
σ1453.314
min3550.465
max7233.500

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.080
mean4104.625
σ1569.243
min1983.000
max6044.000
mean80.197
σ11.654
min70.540
max102.801
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean6044.000
σ0.000
min6044.000
max6044.000
mean97.434
σ8.663
min84.413
max108.238
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean6044.000
σ0.000
min6044.000
max6044.000
mean223.757
σ224.591
min125.830
max778.536

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.318
min11655.305
max11667.521
mean4104.625
σ1569.243
min1983.000
max6044.000
mean6578.120
σ1359.328
min4932.225
max8203.077
op=vertical_lookup_list() on indexed
mean11560.068
σ0.001
min11560.066
max11560.069
mean6044.000
σ0.000
min6044.000
max6044.000
mean6709.772
σ1333.832
min4393.979
max8188.371

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.583
σ0.029
min172.558
max172.635
mean1983.000
σ0.000
min1983.000
max1983.000
mean373.078
σ20.808
min346.817
max398.127
op=pointedIndexFromKvs
rows=400000
mean357.362
σ0.043
min357.321
max357.407
mean1983.000
σ0.000
min1983.000
max1983.000
mean759.256
σ17.678
min732.225
max778.290

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.184
σ0.882
min1007.690
max1011.841
mean1044.000
σ308.256
min548.000
max1477.000
mean1.532
σ0.076
min1.463
max1.808

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean1477.000
σ0.000
min1477.000
max1477.000
mean0.449
σ0.172
min0.355
max0.755
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean1477.000
σ0.000
min1477.000
max1477.000
mean0.916
σ0.161
min0.819
max1.201
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean1477.000
σ0.000
min1477.000
max1477.000
mean0.552
σ0.048
min0.506
max0.628
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean1477.000
σ0.000
min1477.000
max1477.000
mean0.875
σ0.030
min0.847
max0.919

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.543
σ0.024
min963.523
max963.582
mean1477.000
σ0.000
min1477.000
max1477.000
mean0.816
σ0.043
min0.774
max0.869
name=cdr_enhanced_4k_loc.art
mean884.854
σ0.007
min884.847
max884.862
mean1477.000
σ0.000
min1477.000
max1477.000
mean0.705
σ0.042
min0.661
max0.750

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.711
mean1477.000
σ0.000
min1477.000
max1477.000
mean4.310
σ0.095
min4.134
max4.578
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean1477.000
σ0.000
min1477.000
max1477.000
mean4.273
σ0.094
min4.118
max4.533
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean1477.000
σ0.000
min1477.000
max1477.000
mean0.742
σ0.019
min0.715
max0.848
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean1477.000
σ0.000
min1477.000
max1477.000
mean0.726
σ0.025
min0.528
max0.802

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.426
σ0.177
min297.256
max297.840
mean1983.000
σ0.000
min1983.000
max1983.000
mean0.567
σ0.029
min0.524
max0.614

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.730
σ0.044
min289.658
max289.766
mean1477.000
σ0.000
min1477.000
max1477.000
mean0.404
σ0.012
min0.394
max0.417
iters=5
new-facts=1
prior-facts=6402
mean1299.695
σ0.040
min1299.632
max1299.732
mean1477.000
σ0.000
min1477.000
max1477.000
mean2.281
σ0.093
min2.161
max2.382
iters=5
new-facts=6402
prior-facts=1
mean1542.724
σ4.014
min1540.768
max1549.901
mean1477.000
σ0.000
min1477.000
max1477.000
mean2.297
σ0.127
min2.166
max2.451
iters=5
new-facts=6402
prior-facts=6402
mean1861.629
σ0.066
min1861.565
max1861.715
mean1770.400
σ223.875
min1477.000
max1983.000
mean3.258
σ0.342
min2.887
max3.686

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.718
σ0.094
min1.612
max1.831

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.666
σ577.139
min158.091
max1312.374
mean98.250
σ8.500
min94.000
max111.000
mean1477.000
σ0.000
min1477.000
max1477.000
mean0.541
σ0.547
min0.264
max1.361
policies=20
mean1581.234
σ0.348
min1580.994
max1581.750
mean940.000
σ0.000
min940.000
max940.000
mean1477.000
σ0.000
min1477.000
max1477.000
mean2.620
σ0.011
min2.610
max2.634
policies=200
mean15820.414
σ0.095
min15820.298
max15820.504
mean9400.000
σ0.000
min9400.000
max9400.000
mean1477.000
σ0.000
min1477.000
max1477.000
mean26.574
σ0.029
min26.544
max26.612