2c1d13a75befd9297f6968447757ab701cbe7884

Home / Branches / villesokk/bro-2242-store-workflow-status-category-and-label-in-db / 2c1d13a75befd9297f6968447757ab701cbe7884

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.620
σ0.349
min54.484
max55.612
mean415.000
σ0.000
min415.000
max415.000
mean0.144
σ0.005
min0.138
max0.153
cache=y
dps=1
iters=10
policies=100
mean43.791
σ0.005
min43.785
max43.804
mean415.000
σ0.000
min415.000
max415.000
mean0.133
σ0.009
min0.121
max0.150

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4118.125
σ1551.236
min2080.000
max6044.000
mean12.412
σ0.221
min11.945
max12.637
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.619
mean4118.125
σ1551.236
min2080.000
max6044.000
mean12.493
σ0.554
min11.649
max13.156
op=table_records(), no indexes
mean41.929
σ0.001
min41.928
max41.932
mean6044.000
σ0.000
min6044.000
max6044.000
mean13.234
σ1.197
min10.868
max14.765
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4118.125
σ1551.236
min2080.000
max6044.000
mean12.032
σ1.641
min10.476
max14.212
op=vertical_lookup_list() on indexed, after table_records()
mean27.605
σ0.002
min27.603
max27.607
mean4118.125
σ1551.236
min2080.000
max6044.000
mean8.441
σ0.410
min8.003
max8.955
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4118.125
σ1551.236
min2080.000
max6044.000
mean6.580
σ0.236
min6.262
max6.839
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.665
max25.670
mean4118.125
σ1551.236
min2080.000
max6044.000
mean5.567
σ0.113
min5.448
max5.752
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.971
mean4118.125
σ1551.236
min2080.000
max6044.000
mean5.366
σ0.098
min5.261
max5.571

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
mean1499.200
σ706.358
min1031.995
max2939.521
op=load_product(), with indexes
mean8744.559
σ0.033
min8744.545
max8744.640
mean3849.625
σ1616.931
min2080.000
max6044.000
mean4291.900
σ1327.781
min3549.013
max7416.066

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.075
max62.080
mean4118.125
σ1551.236
min2080.000
max6044.000
mean79.609
σ9.632
min71.045
max98.931
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.241
σ9.066
min83.460
max108.122
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.686
mean6044.000
σ0.000
min6044.000
max6044.000
mean185.456
σ118.469
min124.909
max476.794

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.318
min11655.305
max11667.521
mean4118.125
σ1551.236
min2080.000
max6044.000
mean6296.751
σ1267.213
min5004.141
max8299.387
op=vertical_lookup_list() on indexed
mean11560.069
σ0.001
min11560.067
max11560.069
mean6044.000
σ0.000
min6044.000
max6044.000
mean6806.773
σ1290.292
min4471.512
max8329.505

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.589
σ0.037
min172.561
max172.668
mean2080.000
σ0.000
min2080.000
max2080.000
mean367.276
σ46.863
min325.484
max465.828
op=pointedIndexFromKvs
rows=400000
mean357.364
σ0.041
min357.321
max357.418
mean2080.000
σ0.000
min2080.000
max2080.000
mean786.789
σ20.971
min752.414
max809.552

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.477
σ0.895
min1007.979
max1012.194
mean1041.700
σ301.254
min546.000
max1467.000
mean1.532
σ0.070
min1.474
max1.754

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean1467.000
σ0.000
min1467.000
max1467.000
mean0.447
σ0.188
min0.335
max0.781
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean1467.000
σ0.000
min1467.000
max1467.000
mean0.925
σ0.160
min0.839
max1.210
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean1467.000
σ0.000
min1467.000
max1467.000
mean0.553
σ0.048
min0.518
max0.633
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean1467.000
σ0.000
min1467.000
max1467.000
mean0.844
σ0.032
min0.818
max0.896

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.543
σ0.026
min963.523
max963.585
mean1467.000
σ0.000
min1467.000
max1467.000
mean0.760
σ0.051
min0.697
max0.822
name=cdr_enhanced_4k_loc.art
mean884.854
σ0.006
min884.847
max884.860
mean1467.000
σ0.000
min1467.000
max1467.000
mean0.717
σ0.034
min0.672
max0.746

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean1467.000
σ0.000
min1467.000
max1467.000
mean4.321
σ0.080
min4.167
max4.659
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean1467.000
σ0.000
min1467.000
max1467.000
mean4.292
σ0.071
min4.173
max4.575
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean1467.000
σ0.000
min1467.000
max1467.000
mean0.755
σ0.018
min0.722
max0.865
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean1467.000
σ0.000
min1467.000
max1467.000
mean0.713
σ0.015
min0.681
max0.791

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.756
σ0.243
min297.630
max298.440
mean2080.000
σ0.000
min2080.000
max2080.000
mean0.601
σ0.018
min0.553
max0.624

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean292.979
σ0.055
min292.915
max293.038
mean1467.000
σ0.000
min1467.000
max1467.000
mean0.402
σ0.005
min0.397
max0.411
iters=5
new-facts=1
prior-facts=6402
mean1302.914
σ0.109
min1302.755
max1303.050
mean1467.000
σ0.000
min1467.000
max1467.000
mean2.197
σ0.035
min2.138
max2.231
iters=5
new-facts=6402
prior-facts=1
mean1545.890
σ4.021
min1543.926
max1553.078
mean1467.000
σ0.000
min1467.000
max1467.000
mean2.300
σ0.126
min2.152
max2.456
iters=5
new-facts=6402
prior-facts=6402
mean1864.855
σ0.062
min1864.773
max1864.931
mean1743.800
σ244.235
min1467.000
max2080.000
mean2.927
σ0.075
min2.840
max2.997

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.767
σ0.205
min1.441
max1.943

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.770
σ577.139
min158.199
max1312.479
mean96.250
σ8.500
min92.000
max109.000
mean1467.000
σ0.000
min1467.000
max1467.000
mean0.541
σ0.554
min0.263
max1.373
policies=20
mean1582.271
σ0.347
min1582.035
max1582.787
mean920.000
σ0.000
min920.000
max920.000
mean1467.000
σ0.000
min1467.000
max1467.000
mean2.623
σ0.016
min2.603
max2.642
policies=200
mean15830.809
σ0.034
min15830.783
max15830.857
mean9200.000
σ0.000
min9200.000
max9200.000
mean1467.000
σ0.000
min1467.000
max1467.000
mean26.694
σ0.091
min26.610
max26.784