6529ec61842907253959757ccbecdd15675be225

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

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.621
σ0.350
min54.492
max55.617
mean419.000
σ0.000
min419.000
max419.000
mean0.139
σ0.005
min0.132
max0.147
cache=y
dps=1
iters=10
policies=100
mean43.784
σ0.005
min43.775
max43.793
mean419.000
σ0.000
min419.000
max419.000
mean0.121
σ0.004
min0.116
max0.128

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4258.125
σ1898.484
min1909.000
max7559.000
mean12.286
σ0.182
min12.081
max12.584
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.615
max36.620
mean4258.125
σ1898.484
min1909.000
max7559.000
mean12.460
σ0.642
min11.439
max13.137
op=table_records(), no indexes
mean41.928
σ0.000
min41.928
max41.929
mean7559.000
σ0.000
min7559.000
max7559.000
mean13.726
σ1.409
min11.032
max15.308
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4187.625
σ1951.592
min1909.000
max7559.000
mean13.034
σ1.886
min10.718
max14.946
op=vertical_lookup_list() on indexed, after table_records()
mean27.605
σ0.002
min27.603
max27.607
mean4187.625
σ1951.592
min1909.000
max7559.000
mean8.568
σ0.809
min7.747
max10.346
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.399
max26.403
mean4258.125
σ1898.484
min1909.000
max7559.000
mean6.705
σ0.752
min5.924
max8.301
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.670
mean4258.125
σ1898.484
min1909.000
max7559.000
mean5.616
σ0.226
min5.335
max6.067
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.971
mean4258.125
σ1898.484
min1909.000
max7559.000
mean5.240
σ0.227
min4.765
max5.484

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.593
σ0.000
min2524.593
max2524.593
mean7559.000
σ0.000
min7559.000
max7559.000
mean1050.285
σ5.488
min1042.765
max1059.981
op=load_product(), with indexes
mean8744.558
σ0.033
min8744.544
max8744.640
mean3763.625
σ1639.917
min1909.000
max5949.000
mean4433.702
σ1266.448
min3545.109
max6418.236

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.077
σ0.002
min62.076
max62.080
mean4258.125
σ1898.484
min1909.000
max7559.000
mean82.730
σ12.451
min69.956
max105.862
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean7559.000
σ0.000
min7559.000
max7559.000
mean99.260
σ9.411
min84.581
max107.958
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.001
min66.685
max66.690
mean7559.000
σ0.000
min7559.000
max7559.000
mean150.683
σ15.649
min126.353
max167.806

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.317
min11655.305
max11667.516
mean4187.625
σ1951.592
min1909.000
max7559.000
mean6354.352
σ1183.528
min4961.971
max7949.842
op=vertical_lookup_list() on indexed
mean11560.068
σ0.001
min11560.066
max11560.069
mean7559.000
σ0.000
min7559.000
max7559.000
mean5491.143
σ1154.106
min4430.071
max7421.783

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.584
σ0.023
min172.558
max172.622
mean1909.000
σ0.000
min1909.000
max1909.000
mean360.555
σ42.869
min259.985
max391.256
op=pointedIndexFromKvs
rows=400000
mean357.363
σ0.040
min357.321
max357.408
mean1909.000
σ0.000
min1909.000
max1909.000
mean793.231
σ10.521
min774.369
max808.350

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.186
σ0.860
min1007.688
max1011.735
mean1051.800
σ301.670
min550.000
max1456.000
mean1.537
σ0.085
min1.455
max1.747

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean1456.000
σ0.000
min1456.000
max1456.000
mean0.421
σ0.126
min0.341
max0.644
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean1456.000
σ0.000
min1456.000
max1456.000
mean0.882
σ0.087
min0.818
max1.030
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean1456.000
σ0.000
min1456.000
max1456.000
mean0.542
σ0.046
min0.507
max0.620
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean1456.000
σ0.000
min1456.000
max1456.000
mean0.840
σ0.039
min0.815
max0.908

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.542
σ0.030
min963.523
max963.595
mean1456.000
σ0.000
min1456.000
max1456.000
mean0.833
σ0.038
min0.773
max0.867
name=cdr_enhanced_4k_loc.art
mean884.854
σ0.007
min884.847
max884.862
mean1456.000
σ0.000
min1456.000
max1456.000
mean0.702
σ0.039
min0.662
max0.745

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.711
mean1456.000
σ0.000
min1456.000
max1456.000
mean4.245
σ0.097
min4.085
max4.593
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean1456.000
σ0.000
min1456.000
max1456.000
mean4.236
σ0.068
min4.091
max4.491
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean1456.000
σ0.000
min1456.000
max1456.000
mean0.751
σ0.021
min0.652
max0.883
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean1456.000
σ0.000
min1456.000
max1456.000
mean0.711
σ0.033
min0.674
max0.994

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.386
σ0.233
min297.171
max298.018
mean1909.000
σ0.000
min1909.000
max1909.000
mean0.591
σ0.057
min0.512
max0.722

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.729
σ0.051
min289.653
max289.788
mean1456.000
σ0.000
min1456.000
max1456.000
mean0.392
σ0.008
min0.384
max0.404
iters=5
new-facts=1
prior-facts=6402
mean1299.699
σ0.049
min1299.647
max1299.744
mean1456.000
σ0.000
min1456.000
max1456.000
mean2.191
σ0.058
min2.114
max2.263
iters=5
new-facts=6402
prior-facts=1
mean1542.735
σ4.018
min1540.797
max1549.918
mean1456.000
σ0.000
min1456.000
max1456.000
mean2.373
σ0.196
min2.173
max2.701
iters=5
new-facts=6402
prior-facts=6402
mean1861.619
σ0.073
min1861.540
max1861.717
mean1745.400
σ175.078
min1500.000
max1909.000
mean3.065
σ0.272
min2.780
max3.472

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.777
σ0.153
min1.512
max1.898

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.665
σ577.138
min158.091
max1312.372
mean98.250
σ8.500
min94.000
max111.000
mean1456.000
σ0.000
min1456.000
max1456.000
mean0.548
σ0.564
min0.264
max1.395
policies=20
mean1581.223
σ0.369
min1580.973
max1581.771
mean940.000
σ0.000
min940.000
max940.000
mean1456.000
σ0.000
min1456.000
max1456.000
mean2.643
σ0.014
min2.624
max2.658
policies=200
mean15820.424
σ0.087
min15820.347
max15820.545
mean9400.000
σ0.000
min9400.000
max9400.000
mean1456.000
σ0.000
min1456.000
max1456.000
mean26.607
σ0.137
min26.428
max26.753