8d3e641c3473b7e8d2b2de648e0b5d8d29931800

Home / Branches / villesokk/bro-2242-store-workflow-status-category-and-label-in-db / 8d3e641c3473b7e8d2b2de648e0b5d8d29931800

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.617
σ0.349
min54.482
max55.610
mean419.000
σ0.000
min419.000
max419.000
mean0.141
σ0.004
min0.138
max0.147
cache=y
dps=1
iters=10
policies=100
mean43.785
σ0.005
min43.780
max43.797
mean419.000
σ0.000
min419.000
max419.000
mean0.123
σ0.004
min0.120
max0.129

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4107.625
σ1572.631
min1973.000
max6049.000
mean12.501
σ0.236
min12.169
max12.791
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.619
mean4107.625
σ1572.631
min1973.000
max6049.000
mean12.222
σ0.717
min11.375
max13.116
op=table_records(), no indexes
mean41.929
σ0.000
min41.928
max41.929
mean6049.000
σ0.000
min6049.000
max6049.000
mean13.130
σ1.174
min10.570
max14.587
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4107.625
σ1572.631
min1973.000
max6049.000
mean12.435
σ2.060
min10.407
max14.827
op=vertical_lookup_list() on indexed, after table_records()
mean27.605
σ0.003
min27.603
max27.611
mean4107.625
σ1572.631
min1973.000
max6049.000
mean8.558
σ0.537
min7.953
max9.302
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.399
max26.403
mean4107.625
σ1572.631
min1973.000
max6049.000
mean6.472
σ0.328
min6.056
max6.959
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.670
mean4107.625
σ1572.631
min1973.000
max6049.000
mean5.478
σ0.171
min5.257
max5.737
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.971
mean4107.625
σ1572.631
min1973.000
max6049.000
mean5.292
σ0.175
min4.925
max5.454

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.593
σ0.000
min2524.593
max2524.594
mean6049.000
σ0.000
min6049.000
max6049.000
mean1410.868
σ552.009
min1046.325
max2498.387
op=load_product(), with indexes
mean8744.558
σ0.033
min8744.544
max8744.640
mean3825.500
σ1652.396
min1973.000
max6049.000
mean4555.312
σ1490.956
min3543.551
max7633.217

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.077
σ0.002
min62.076
max62.080
mean4107.625
σ1572.631
min1973.000
max6049.000
mean80.975
σ9.056
min72.125
max96.955
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean6049.000
σ0.000
min6049.000
max6049.000
mean96.592
σ9.317
min84.813
max108.275
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean6049.000
σ0.000
min6049.000
max6049.000
mean227.754
σ236.975
min126.280
max813.310

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.317
min11655.305
max11667.517
mean4107.625
σ1572.631
min1973.000
max6049.000
mean6453.813
σ1307.327
min4919.701
max8215.523
op=vertical_lookup_list() on indexed
mean11560.069
σ0.002
min11560.066
max11560.072
mean6049.000
σ0.000
min6049.000
max6049.000
mean6761.089
σ1498.929
min4378.643
max8203.877

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.588
σ0.025
min172.558
max172.624
mean1973.000
σ0.000
min1973.000
max1973.000
mean364.942
σ42.445
min272.558
max402.833
op=pointedIndexFromKvs
rows=400000
mean357.356
σ0.039
min357.321
max357.415
mean1973.000
σ0.000
min1973.000
max1973.000
mean799.830
σ14.927
min782.331
max820.353

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.423
σ0.897
min1007.945
max1012.146
mean1044.900
σ306.695
min550.000
max1474.000
mean1.563
σ0.117
min1.447
max1.942

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean1474.000
σ0.000
min1474.000
max1474.000
mean0.432
σ0.126
min0.343
max0.643
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean1474.000
σ0.000
min1474.000
max1474.000
mean0.883
σ0.089
min0.821
max1.037
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean1474.000
σ0.000
min1474.000
max1474.000
mean0.544
σ0.045
min0.512
max0.622
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean1474.000
σ0.000
min1474.000
max1474.000
mean0.839
σ0.047
min0.799
max0.910

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.541
σ0.028
min963.523
max963.589
mean1474.000
σ0.000
min1474.000
max1474.000
mean0.843
σ0.025
min0.805
max0.865
name=cdr_enhanced_4k_loc.art
mean884.854
σ0.005
min884.847
max884.859
mean1474.000
σ0.000
min1474.000
max1474.000
mean0.696
σ0.047
min0.639
max0.745

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean1474.000
σ0.000
min1474.000
max1474.000
mean4.264
σ0.076
min4.130
max4.602
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean1474.000
σ0.000
min1474.000
max1474.000
mean4.247
σ0.086
min4.105
max4.604
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean1474.000
σ0.000
min1474.000
max1474.000
mean0.750
σ0.017
min0.719
max0.859
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean1474.000
σ0.000
min1474.000
max1474.000
mean0.713
σ0.018
min0.630
max0.783

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.636
σ0.204
min297.466
max298.180
mean1973.000
σ0.000
min1973.000
max1973.000
mean0.604
σ0.043
min0.537
max0.703

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean292.458
σ0.035
min292.420
max292.501
mean1474.000
σ0.000
min1474.000
max1474.000
mean0.403
σ0.009
min0.397
max0.418
iters=5
new-facts=1
prior-facts=6402
mean1302.380
σ0.090
min1302.277
max1302.509
mean1474.000
σ0.000
min1474.000
max1474.000
mean2.290
σ0.103
min2.154
max2.395
iters=5
new-facts=6402
prior-facts=1
mean1545.345
σ4.019
min1543.388
max1552.529
mean1474.000
σ0.000
min1474.000
max1474.000
mean2.287
σ0.149
min2.107
max2.468
iters=5
new-facts=6402
prior-facts=6402
mean1864.322
σ0.079
min1864.209
max1864.394
mean1769.200
σ215.040
min1482.000
max1973.000
mean3.353
σ0.486
min2.882
max3.969

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.803
σ0.050
min1.724
max1.850

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.667
σ577.140
min158.096
max1312.377
mean96.250
σ8.500
min92.000
max109.000
mean1474.000
σ0.000
min1474.000
max1474.000
mean0.546
σ0.562
min0.261
max1.388
policies=20
mean1581.246
σ0.358
min1581.005
max1581.778
mean920.000
σ0.000
min920.000
max920.000
mean1474.000
σ0.000
min1474.000
max1474.000
mean2.637
σ0.015
min2.624
max2.654
policies=200
mean15820.487
σ0.114
min15820.387
max15820.639
mean9200.000
σ0.000
min9200.000
max9200.000
mean1474.000
σ0.000
min1474.000
max1474.000
mean26.508
σ0.016
min26.488
max26.528