b5924688e2d6e28a9d3351119c202292fe8c5ca9

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

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.869
σ0.359
min54.735
max55.891
mean419.000
σ0.000
min419.000
max419.000
mean0.142
σ0.004
min0.138
max0.149
cache=y
dps=1
iters=10
policies=100
mean43.840
σ0.005
min43.833
max43.849
mean419.000
σ0.000
min419.000
max419.000
mean0.125
σ0.005
min0.120
max0.133

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.616
max36.620
mean4145.500
σ1889.090
min1554.000
max7268.000
mean12.130
σ0.384
min11.676
max12.822
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.620
mean4145.500
σ1889.090
min1554.000
max7268.000
mean12.115
σ0.418
min11.457
max12.612
op=table_records(), no indexes
mean41.932
σ0.001
min41.930
max41.933
mean7268.000
σ0.000
min7268.000
max7268.000
mean14.846
σ0.369
min14.043
max15.255
op=table_records(), repeat
mean41.929
σ0.002
min41.927
max41.931
mean4145.500
σ1889.090
min1554.000
max7268.000
mean12.557
σ1.893
min10.569
max14.866
op=vertical_lookup_list() on indexed, after table_records()
mean27.654
σ0.136
min27.604
max27.991
mean4145.500
σ1889.090
min1554.000
max7268.000
mean9.009
σ0.379
min8.481
max9.504
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.400
max26.404
mean4145.500
σ1889.090
min1554.000
max7268.000
mean6.274
σ0.302
min5.880
max6.894
op=vertical_lookup_row_list() on 2 indexed
mean25.668
σ0.003
min25.666
max25.674
mean4145.500
σ1889.090
min1554.000
max7268.000
mean5.561
σ0.170
min5.333
max5.841
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.970
σ0.002
min25.968
max25.974
mean4145.500
σ1889.090
min1554.000
max7268.000
mean5.241
σ0.176
min4.907
max5.459

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606
σ0.000
min2524.606
max2524.606
mean7268.000
σ0.000
min7268.000
max7268.000
mean1454.105
σ749.609
min1036.737
max3202.632
op=load_product(), with indexes
mean8744.721
σ0.469
min8744.553
max8745.882
mean3567.750
σ1788.695
min1045.000
max5774.000
mean4929.528
σ1631.397
min3526.017
max7438.962

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.080
mean4145.500
σ1889.090
min1554.000
max7268.000
mean83.984
σ12.130
min69.358
max99.490
op=vertical_lookup_list() on unindexed missing Int
mean40.945
σ0.001
min40.945
max40.946
mean7268.000
σ0.000
min7268.000
max7268.000
mean108.274
σ1.891
min104.942
max111.053
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.686
max66.687
mean7268.000
σ0.000
min7268.000
max7268.000
mean164.940
σ5.187
min153.690
max169.761

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.901
σ4.304
min11655.306
max11667.552
mean4145.500
σ1889.090
min1554.000
max7268.000
mean6302.546
σ1013.348
min4906.511
max7926.361
op=vertical_lookup_list() on indexed
mean11560.066
σ0.001
min11560.065
max11560.067
mean7268.000
σ0.000
min7268.000
max7268.000
mean5351.989
σ1643.655
min4380.883
max8207.014

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
mean361.306
σ18.263
min341.638
max394.374
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean560.000
σ0.000
min560.000
max560.000
mean743.138
σ37.268
min660.991
max779.466

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1024.326
σ0.759
min1023.848
max1027.463
mean1040.650
σ293.763
min544.000
max1438.000
mean1.561
σ0.079
min1.493
max1.796

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.436
σ0.565
min0.151
max1.442
name=error_case.art
mean2.339
σ0.012
min2.333
max2.361
mean402.000
σ0.000
min402.000
max402.000
mean0.492
σ0.325
min0.335
max1.074
name=heavy_item.art
mean1.522
σ0.002
min1.521
max1.525
mean402.000
σ0.000
min402.000
max402.000
mean0.226
σ0.021
min0.206
max0.261
name=nested_use.art
mean2.357
σ0.002
min2.356
max2.360
mean402.000
σ0.000
min402.000
max402.000
mean0.340
σ0.024
min0.320
max0.381

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.840
σ0.011
min964.835
max964.859
mean436.000
σ2.236
min432.000
max437.000
mean0.555
σ0.038
min0.503
max0.595
name=cdr_enhanced_4k_loc.art
mean885.820
σ0.002
min885.819
max885.823
mean440.000
σ0.000
min440.000
max440.000
mean0.481
σ0.037
min0.445
max0.522

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.709
σ0.002
min7.708
max7.712
mean440.000
σ0.000
min440.000
max440.000
mean2.643
σ0.078
min2.511
max2.841
name=record_render_large_syntax_err.art
mean7.657
σ0.002
min7.656
max7.660
mean440.000
σ0.000
min440.000
max440.000
mean2.621
σ0.074
min2.455
max2.830
name=record_render_success.art
mean2.289
σ0.002
min2.289
max2.293
mean440.000
σ0.000
min440.000
max440.000
mean0.304
σ0.008
min0.290
max0.358
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean440.000
σ0.000
min440.000
max440.000
mean0.295
σ0.007
min0.283
max0.336

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean298.636
σ1.064
min298.159
max301.653
mean443.500
σ18.567
min414.000
max465.000
mean0.620
σ0.011
min0.604
max0.642

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean239.536
σ0.000
min239.536
max239.536
mean1707.500
σ49.068
min1681.000
max1787.000
mean224.136
σ1.330
min222.147
max226.179
phase=macro expansion
mean6.133
σ0.000
min6.133
max6.133
mean1707.500
σ49.068
min1681.000
max1787.000
mean10.656
σ2.605
min6.396
max13.118
phase=parser
mean1042.363
σ0.000
min1042.363
max1042.363
mean1707.500
σ49.068
min1681.000
max1787.000
mean615.744
σ132.327
min421.058
max735.926
phase=processProdDef
mean6169.657
σ0.000
min6169.657
max6169.657
mean1720.750
σ54.860
min1681.000
max1787.000
mean5294.624
σ1529.520
min3117.512
max7516.954
phase=renaming
mean21.671
σ0.000
min21.671
max21.671
mean1707.500
σ49.068
min1681.000
max1787.000
mean41.533
σ9.448
min20.949
max48.642
phase=type checker
mean990.442
σ0.066
min990.344
max990.532
mean1707.500
σ49.068
min1681.000
max1787.000
mean831.169
σ84.007
min680.868
max912.378

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean293.936
σ0.045
min293.872
max293.981
mean445.200
σ0.447
min445.000
max446.000
mean0.406
σ0.002
min0.403
max0.407
iters=5
new-facts=1
prior-facts=6402
mean1320.235
σ0.048
min1320.192
max1320.317
mean1087.400
σ168.328
min887.000
max1319.000
mean2.122
σ0.159
min1.849
max2.234
iters=5
new-facts=6402
prior-facts=1
mean1559.752
σ4.055
min1557.771
max1567.000
mean626.000
σ80.212
min538.000
max728.000
mean2.265
σ0.140
min2.135
max2.441
iters=5
new-facts=6402
prior-facts=6402
mean1882.284
σ0.060
min1882.199
max1882.361
mean1720.000
σ172.012
min1472.000
max1878.000
mean2.966
σ0.125
min2.809
max3.150

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.722
σ0.208
min1.409
max1.947

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean453.530
σ585.530
min160.760
max1331.826
mean102.250
σ8.500
min98.000
max115.000
mean442.000
σ0.000
min442.000
max442.000
mean0.553
σ0.561
min0.271
max1.394
policies=20
mean1607.972
σ0.428
min1607.685
max1608.609
mean980.000
σ0.000
min980.000
max980.000
mean448.750
σ10.874
min442.000
max465.000
mean2.721
σ0.015
min2.706
max2.738
policies=200
mean16087.793
σ0.203
min16087.626
max16088.084
mean9800.000
σ0.000
min9800.000
max9800.000
mean498.750
σ3.594
min494.000
max502.000
mean27.552
σ0.248
min27.323
max27.867