dbaf129f50467848c512789387b28ab02accc7bb

Home / Branches / austinplatt/bro-2295-move-database-config-into-own-env-record / dbaf129f50467848c512789387b28ab02accc7bb

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.871
σ0.360
min54.731
max55.894
mean419.000
σ0.000
min419.000
max419.000
mean0.143
σ0.007
min0.137
max0.159
cache=y
dps=1
iters=10
policies=100
mean43.840
σ0.005
min43.833
max43.849
mean419.300
σ0.483
min419.000
max420.000
mean0.122
σ0.006
min0.116
max0.131

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.616
max36.620
mean4148.500
σ1891.126
min1555.000
max7275.000
mean12.827
σ0.223
min12.555
max13.211
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.620
mean4148.500
σ1891.126
min1555.000
max7275.000
mean12.931
σ0.561
min11.987
max13.421
op=table_records(), no indexes
mean41.932
σ0.001
min41.930
max41.933
mean7275.000
σ0.000
min7275.000
max7275.000
mean15.351
σ0.524
min14.256
max15.841
op=table_records(), repeat
mean41.929
σ0.002
min41.928
max41.932
mean4148.500
σ1891.126
min1555.000
max7275.000
mean13.165
σ1.777
min11.281
max15.473
op=vertical_lookup_list() on indexed, after table_records()
mean27.654
σ0.136
min27.604
max27.991
mean4148.500
σ1891.126
min1555.000
max7275.000
mean9.045
σ0.479
min8.367
max9.954
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.400
max26.404
mean4148.500
σ1891.126
min1555.000
max7275.000
mean6.760
σ0.262
min6.372
max7.111
op=vertical_lookup_row_list() on 2 indexed
mean25.668
σ0.003
min25.666
max25.674
mean4148.500
σ1891.126
min1555.000
max7275.000
mean6.144
σ0.118
min6.010
max6.368
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.970
σ0.002
min25.968
max25.974
mean4148.500
σ1891.126
min1555.000
max7275.000
mean5.852
σ0.151
min5.528
max6.023

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606
σ0.000
min2524.606
max2524.606
mean7275.000
σ0.000
min7275.000
max7275.000
mean1555.536
σ984.377
min1054.420
max3902.578
op=load_product(), with indexes
mean8744.721
σ0.469
min8744.553
max8745.882
mean3570.000
σ1790.856
min1044.000
max5778.000
mean5031.285
σ1687.448
min3546.585
max7480.955

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.081
mean4148.500
σ1891.126
min1555.000
max7275.000
mean83.213
σ11.260
min69.391
max97.349
op=vertical_lookup_list() on unindexed missing Int
mean40.945
σ0.001
min40.945
max40.946
mean7275.000
σ0.000
min7275.000
max7275.000
mean108.222
σ2.391
min103.689
max109.996
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.686
max66.687
mean7275.000
σ0.000
min7275.000
max7275.000
mean164.048
σ5.382
min151.888
max168.768

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.901
σ4.304
min11655.306
max11667.551
mean4148.500
σ1891.126
min1555.000
max7275.000
mean6603.452
σ1050.743
min4895.152
max7921.879
op=vertical_lookup_list() on indexed
mean11560.066
σ0.001
min11560.065
max11560.067
mean7275.000
σ0.000
min7275.000
max7275.000
mean5410.227
σ1321.174
min4441.107
max8076.325

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.559
σ0.001
min172.558
max172.562
mean478.000
σ0.000
min478.000
max478.000
mean381.846
σ16.558
min353.046
max394.989
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean560.625
σ0.518
min560.000
max561.000
mean772.415
σ20.715
min724.431
max790.541

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1024.324
σ0.759
min1023.849
max1027.463
mean1038.750
σ301.570
min563.000
max1462.000
mean1.560
σ0.069
min1.486
max1.772

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.913
σ0.020
min0.903
max0.949
mean402.000
σ0.000
min402.000
max402.000
mean0.395
σ0.506
min0.142
max1.298
name=error_case.art
mean2.339
σ0.012
min2.333
max2.361
mean402.000
σ0.000
min402.000
max402.000
mean0.496
σ0.311
min0.337
max1.051
name=heavy_item.art
mean1.522
σ0.002
min1.521
max1.525
mean402.000
σ0.000
min402.000
max402.000
mean0.223
σ0.026
min0.204
max0.266
name=nested_use.art
mean2.357
σ0.002
min2.356
max2.360
mean402.000
σ0.000
min402.000
max402.000
mean0.346
σ0.019
min0.324
max0.374

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.840
σ0.011
min964.835
max964.859
mean431.000
σ0.000
min431.000
max431.000
mean0.569
σ0.037
min0.540
max0.610
name=cdr_enhanced_4k_loc.art
mean885.820
σ0.002
min885.819
max885.823
mean431.000
σ0.000
min431.000
max431.000
mean0.500
σ0.041
min0.438
max0.540

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.709
σ0.002
min7.708
max7.712
mean431.000
σ0.000
min431.000
max431.000
mean1.993
σ0.094
min1.861
max2.514
name=record_render_large_syntax_err.art
mean7.657
σ0.002
min7.656
max7.660
mean431.000
σ0.000
min431.000
max431.000
mean2.614
σ0.209
min1.932
max3.282
name=record_render_success.art
mean2.289
σ0.002
min2.289
max2.293
mean431.000
σ0.000
min431.000
max431.000
mean0.314
σ0.008
min0.300
max0.355
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean431.000
σ0.000
min431.000
max431.000
mean0.297
σ0.008
min0.283
max0.335

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean298.776
σ1.015
min298.408
max301.662
mean444.600
σ15.721
min425.000
max472.000
mean0.618
σ0.011
min0.606
max0.647

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean239.536
σ0.000
min239.536
max239.536
mean1752.000
σ0.000
min1752.000
max1752.000
mean224.273
σ1.699
min222.672
max227.493
phase=macro expansion
mean6.133
σ0.000
min6.133
max6.133
mean1752.000
σ0.000
min1752.000
max1752.000
mean11.735
σ1.534
min9.480
max12.956
phase=parser
mean1042.363
σ0.000
min1042.363
max1042.363
mean1752.000
σ0.000
min1752.000
max1752.000
mean698.674
σ83.822
min579.286
max838.075
phase=processProdDef
mean6169.657
σ0.001
min6169.657
max6169.658
mean1752.000
σ0.000
min1752.000
max1752.000
mean5136.498
σ955.260
min4274.883
max6895.757
phase=renaming
mean21.671
σ0.000
min21.671
max21.671
mean1752.000
σ0.000
min1752.000
max1752.000
mean46.354
σ5.905
min34.908
max52.037
phase=type checker
mean990.442
σ0.066
min990.344
max990.532
mean1752.000
σ0.000
min1752.000
max1752.000
mean824.371
σ84.542
min691.554
max924.229

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean293.936
σ0.045
min293.872
max293.981
mean442.400
σ2.408
min440.000
max445.000
mean0.405
σ0.001
min0.404
max0.406
iters=5
new-facts=1
prior-facts=6402
mean1320.246
σ0.069
min1320.188
max1320.326
mean1068.600
σ167.412
min844.000
max1276.000
mean2.029
σ0.213
min1.841
max2.336
iters=5
new-facts=6402
prior-facts=1
mean1559.746
σ4.079
min1557.720
max1567.037
mean618.800
σ81.533
min497.000
max716.000
mean2.262
σ0.174
min2.166
max2.573
iters=5
new-facts=6402
prior-facts=6402
mean1882.287
σ0.056
min1882.211
max1882.348
mean1700.200
σ246.474
min1406.000
max2032.000
mean2.934
σ0.052
min2.881
max3.003

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.839
σ0.098
min1.727
max1.946

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean453.528
σ585.528
min160.762
max1331.820
mean102.250
σ8.500
min98.000
max115.000
mean442.000
σ0.000
min442.000
max442.000
mean0.553
σ0.562
min0.268
max1.396
policies=20
mean1607.973
σ0.429
min1607.682
max1608.609
mean980.000
σ0.000
min980.000
max980.000
mean450.250
σ10.112
min442.000
max465.000
mean2.729
σ0.037
min2.684
max2.764
policies=200
mean16087.873
σ0.094
min16087.811
max16088.012
mean9800.000
σ0.000
min9800.000
max9800.000
mean497.750
σ5.852
min491.000
max505.000
mean27.548
σ0.186
min27.382
max27.735