d551cfb013e6666e46cef9d05fabf6d31d6ec70f

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

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.617
σ0.349
min54.483
max55.612
mean417.800
σ0.422
min417.000
max418.000
mean0.140
σ0.004
min0.136
max0.146
cache=y
dps=1
iters=10
policies=100
mean43.785
σ0.008
min43.776
max43.802
mean418.000
σ0.000
min418.000
max418.000
mean0.123
σ0.004
min0.116
max0.129

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=column_set() on indexed
rows=200000
mean36.617
σ0.002
min36.615
max36.619
mean4171.500
σ1899.709
min1552.000
max7206.000
mean12.888
σ0.423
min12.412
max13.758
iterations=8
operation_display=column_set() on indexed, repeat
rows=200000
mean36.617
σ0.002
min36.616
max36.621
mean4291.750
σ1979.587
min1552.000
max7206.000
mean93.622
σ228.106
min12.000
max658.156
iterations=8
operation_display=table_records(), no indexes
rows=200000
mean41.930
σ0.002
min41.928
max41.933
mean7206.000
σ0.000
min7206.000
max7206.000
mean14.795
σ1.144
min12.285
max15.473
iterations=8
operation_display=table_records(), no indexes, repeat
rows=200000
mean41.929
σ0.002
min41.928
max41.932
mean7206.000
σ0.000
min7206.000
max7206.000
mean13.938
σ1.035
min11.663
max14.796
iterations=8
operation_display=table_records(), repeat
rows=200000
mean41.929
σ0.002
min41.927
max41.932
mean4171.500
σ1899.709
min1552.000
max7206.000
mean13.635
σ1.612
min11.390
max15.480
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records()
rows=200000
mean27.605
σ0.003
min27.603
max27.611
mean4171.500
σ1899.709
min1552.000
max7206.000
mean9.161
σ0.268
min8.722
max9.515
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.400
σ0.002
min26.399
max26.403
mean4171.500
σ1899.709
min1552.000
max7206.000
mean6.790
σ0.254
min6.487
max7.114
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.666
σ0.002
min25.664
max25.669
mean4291.750
σ1979.587
min1552.000
max7206.000
mean6.376
σ0.675
min5.977
max7.975
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.661
σ0.002
min25.659
max25.663
mean4291.750
σ1979.587
min1552.000
max7206.000
mean5.930
σ0.681
min5.508
max7.591
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.969
σ0.002
min25.967
max25.971
mean4291.750
σ1979.587
min1552.000
max7206.000
mean5.878
σ0.742
min5.064
max7.582
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.968
σ0.002
min25.967
max25.971
mean4291.750
σ1979.587
min1552.000
max7206.000
mean5.697
σ0.742
min4.964
max7.353

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=load_product(), no indexes
rows=200000
mean2524.596
σ0.002
min2524.594
max2524.598
mean7206.000
σ0.000
min7206.000
max7206.000
mean1143.497
σ299.059
min1019.993
max1883.136
iterations=8
operation_display=load_product(), with indexes
rows=200000
mean8744.561
σ0.041
min8744.545
max8744.662
mean3598.375
σ1819.266
min1077.000
max5840.000
mean4628.426
σ1470.368
min3530.832
max7431.379

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=column_set() on unindexed, dense
rows=200000
mean62.077
σ0.002
min62.076
max62.080
mean4171.500
σ1899.709
min1552.000
max7206.000
mean81.047
σ8.831
min72.257
max98.367
iterations=8
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.077
σ0.002
min62.076
max62.080
mean4171.500
σ1899.709
min1552.000
max7206.000
mean81.827
σ9.028
min71.702
max99.059
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int
rows=200000
mean40.944
σ0.001
min40.943
max40.947
mean7206.000
σ0.000
min7206.000
max7206.000
mean101.555
σ11.526
min75.595
max107.949
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int, repeat
rows=200000
mean40.946
σ0.002
min40.944
max40.947
mean7206.000
σ0.000
min7206.000
max7206.000
mean101.604
σ11.486
min75.728
max108.166
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end
rows=200000
mean40.950
σ0.002
min40.949
max40.953
mean7206.000
σ0.000
min7206.000
max7206.000
mean103.648
σ10.624
min81.340
max111.502
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat
rows=200000
mean40.951
σ0.002
min40.949
max40.953
mean7206.000
σ0.000
min7206.000
max7206.000
mean101.722
σ11.686
min75.495
max108.252
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int
rows=200000
mean66.687
σ0.002
min66.685
max66.690
mean7206.000
σ0.000
min7206.000
max7206.000
mean220.512
σ179.841
min121.819
max663.889
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat
rows=200000
mean66.686
σ0.001
min66.685
max66.689
mean7206.000
σ0.000
min7206.000
max7206.000
mean153.076
σ19.869
min121.731
max168.140

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=table_records()
rows=200000
mean11656.834
σ4.318
min11655.305
max11667.520
mean4171.500
σ1899.709
min1552.000
max7206.000
mean7010.051
σ1273.178
min4935.992
max8267.292
iterations=8
operation_display=vertical_lookup_list() on indexed
rows=200000
mean11560.066
σ0.003
min11560.064
max11560.070
mean7206.000
σ0.000
min7206.000
max7206.000
mean5686.645
σ1390.811
min4417.108
max7647.565

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=pointedIndexFromKvs
rows=200000
mean172.668
σ0.008
min172.654
max172.679
mean489.250
σ0.707
min489.000
max491.000
mean404.562
σ19.514
min367.180
max422.584
iterations=8
operation_display=pointedIndexFromKvs
rows=400000
mean357.463
σ0.156
min357.321
max357.643
mean574.000
σ0.000
min574.000
max574.000
mean794.866
σ39.710
min720.423
max858.308

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.323
σ0.761
min1007.847
max1011.469
mean7206.000
σ0.000
min7206.000
max7206.000
mean1.534
σ0.178
min1.402
max2.081

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.310
σ0.098
min0.251
max0.483
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.641
σ0.075
min0.594
max0.773
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.483
σ0.059
min0.401
max0.536
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.852
σ0.034
min0.826
max0.908

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.552
σ0.023
min963.530
max963.579
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.821
σ0.037
min0.769
max0.853
name=cdr_enhanced_4k_loc.art
mean884.854
σ0.006
min884.847
max884.861
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.716
σ0.063
min0.603
max0.749

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.712
mean7206.000
σ0.000
min7206.000
max7206.000
mean3.534
σ0.084
min3.414
max3.936
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean7206.000
σ0.000
min7206.000
max7206.000
mean3.498
σ0.076
min3.259
max3.775
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.753
σ0.017
min0.725
max0.861
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.721
σ0.014
min0.695
max0.800

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.827
σ0.238
min297.667
max298.475
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.593
σ0.021
min0.555
max0.618

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean292.412
σ0.029
min292.372
max292.452
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.393
σ0.003
min0.389
max0.395
iters=5
new-facts=1
prior-facts=6402
mean1302.320
σ0.096
min1302.208
max1302.458
mean7206.000
σ0.000
min7206.000
max7206.000
mean1.976
σ0.124
min1.832
max2.166
iters=5
new-facts=6402
prior-facts=1
mean1545.315
σ4.057
min1543.280
max1552.563
mean7206.000
σ0.000
min7206.000
max7206.000
mean2.321
σ0.202
min2.060
max2.550
iters=5
new-facts=6402
prior-facts=6402
mean1864.318
σ0.076
min1864.222
max1864.417
mean7206.000
σ0.000
min7206.000
max7206.000
mean2.992
σ0.203
min2.748
max3.253

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.602
σ0.262
min1.248
max1.844

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.629
σ577.064
min158.094
max1312.226
mean96.250
σ8.500
min92.000
max109.000
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.506
σ0.479
min0.263
max1.224
policies=20
mean1581.244
σ0.362
min1580.997
max1581.779
mean920.000
σ0.000
min920.000
max920.000
mean7206.000
σ0.000
min7206.000
max7206.000
mean2.632
σ0.017
min2.614
max2.651
policies=200
mean15820.490
σ0.097
min15820.384
max15820.599
mean9200.000
σ0.000
min9200.000
max9200.000
mean7206.000
σ0.000
min7206.000
max7206.000
mean26.650
σ0.207
min26.375
max26.814