6fdbc1922aa4c5ba9fd22592089f46cc5b053925

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

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.621
σ0.351
min54.493
max55.618
mean418.000
σ0.000
min418.000
max418.000
mean0.141
σ0.005
min0.131
max0.148
cache=y
dps=1
iters=10
policies=100
mean43.785
σ0.008
min43.768
max43.796
mean418.000
σ0.000
min418.000
max418.000
mean0.124
σ0.007
min0.114
max0.136

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4264.500
σ1878.239
min1979.000
max7543.000
mean12.910
σ1.785
min11.883
max17.258
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.615
max36.620
mean4264.500
σ1878.239
min1979.000
max7543.000
mean12.581
σ2.205
min11.364
max17.881
op=table_records(), no indexes
mean41.929
σ0.000
min41.928
max41.929
mean7543.000
σ0.000
min7543.000
max7543.000
mean13.509
σ1.364
min10.791
max14.996
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.932
mean4264.500
σ1878.239
min1979.000
max7543.000
mean12.080
σ1.952
min10.312
max15.164
op=vertical_lookup_list() on indexed, after table_records()
mean27.605
σ0.002
min27.603
max27.607
mean4264.500
σ1878.239
min1979.000
max7543.000
mean8.874
σ1.237
min7.843
max11.779
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.399
max26.403
mean4264.500
σ1878.239
min1979.000
max7543.000
mean6.938
σ1.096
min6.197
max9.600
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.670
mean4264.500
σ1878.239
min1979.000
max7543.000
mean5.662
σ0.591
min5.238
max7.057
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.971
mean4264.500
σ1878.239
min1979.000
max7543.000
mean5.526
σ0.559
min5.137
max6.870

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.593
σ0.000
min2524.593
max2524.594
mean7543.000
σ0.000
min7543.000
max7543.000
mean1106.145
σ159.470
min1035.480
max1500.429
op=load_product(), with indexes
mean8744.558
σ0.033
min8744.544
max8744.639
mean3787.375
σ1608.349
min1979.000
max5944.000
mean4373.533
σ1362.961
min3532.642
max6591.113

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.077
σ0.002
min62.075
max62.080
mean4264.500
σ1878.239
min1979.000
max7543.000
mean86.003
σ13.780
min71.966
max106.538
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean7543.000
σ0.000
min7543.000
max7543.000
mean94.531
σ12.663
min71.741
max107.442
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean7543.000
σ0.000
min7543.000
max7543.000
mean146.089
σ21.151
min105.645
max166.520

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.317
min11655.305
max11667.517
mean4264.500
σ1878.239
min1979.000
max7543.000
mean6349.435
σ1044.915
min4982.830
max8148.861
op=vertical_lookup_list() on indexed
mean11560.068
σ0.001
min11560.066
max11560.069
mean7543.000
σ0.000
min7543.000
max7543.000
mean5153.673
σ1013.960
min4412.510
max7392.538

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.582
σ0.022
min172.558
max172.614
mean1979.000
σ0.000
min1979.000
max1979.000
mean354.912
σ43.918
min263.619
max407.085
op=pointedIndexFromKvs
rows=400000
mean357.361
σ0.041
min357.321
max357.405
mean1979.000
σ0.000
min1979.000
max1979.000
mean788.728
σ19.406
min761.878
max822.529

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.188
σ0.870
min1007.684
max1011.785
mean1046.400
σ301.976
min549.000
max1469.000
mean1.493
σ0.055
min1.357
max1.590

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.003
min0.881
max0.887
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.421
σ0.090
min0.332
max0.567
name=error_case.art
mean2.334
σ0.003
min2.332
max2.339
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.873
σ0.081
min0.819
max1.016
name=heavy_item.art
mean1.522
σ0.002
min1.520
max1.524
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.537
σ0.052
min0.495
max0.625
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.862
σ0.061
min0.799
max0.944

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.545
σ0.029
min963.523
max963.593
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.832
σ0.023
min0.801
max0.856
name=cdr_enhanced_4k_loc.art
mean884.854
σ0.008
min884.847
max884.866
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.712
σ0.033
min0.680
max0.748

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.711
mean1469.000
σ0.000
min1469.000
max1469.000
mean4.283
σ0.084
min4.147
max4.629
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean1469.000
σ0.000
min1469.000
max1469.000
mean4.256
σ0.079
min4.113
max4.508
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.753
σ0.018
min0.728
max0.871
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.708
σ0.021
min0.647
max0.798

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.474
σ0.267
min297.272
max298.201
mean1979.000
σ0.000
min1979.000
max1979.000
mean0.560
σ0.033
min0.512
max0.592

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.720
σ0.037
min289.655
max289.750
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.402
σ0.009
min0.395
max0.412
iters=5
new-facts=1
prior-facts=6402
mean1299.673
σ0.093
min1299.530
max1299.788
mean1469.000
σ0.000
min1469.000
max1469.000
mean2.129
σ0.076
min2.015
max2.202
iters=5
new-facts=6402
prior-facts=1
mean1542.698
σ4.037
min1540.672
max1549.911
mean1469.000
σ0.000
min1469.000
max1469.000
mean2.301
σ0.170
min2.143
max2.519
iters=5
new-facts=6402
prior-facts=6402
mean1861.621
σ0.071
min1861.564
max1861.717
mean1767.600
σ223.244
min1473.000
max1979.000
mean3.387
σ0.334
min2.880
max3.693

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.695
σ0.073
min1.608
max1.776

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.665
σ577.138
min158.092
max1312.373
mean98.250
σ8.500
min94.000
max111.000
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.538
σ0.548
min0.263
max1.360
policies=20
mean1581.224
σ0.360
min1580.980
max1581.758
mean940.000
σ0.000
min940.000
max940.000
mean1469.000
σ0.000
min1469.000
max1469.000
mean2.631
σ0.012
min2.616
max2.646
policies=200
mean15820.530
σ0.093
min15820.459
max15820.667
mean9400.000
σ0.000
min9400.000
max9400.000
mean1469.000
σ0.000
min1469.000
max1469.000
mean26.582
σ0.112
min26.462
max26.720