1cb688fc19280439653841a9b476b3df87bc5f87

Home / Branches / harryroscoe/add-contract-status-information / 1cb688fc19280439653841a9b476b3df87bc5f87

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.615
σ0.348
min54.485
max55.605
mean414.700
σ0.483
min414.000
max415.000
mean0.137
σ0.004
min0.131
max0.142
cache=y
dps=1
iters=10
policies=100
mean43.785
σ0.007
min43.774
max43.798
mean415.000
σ0.000
min415.000
max415.000
mean0.122
σ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.620
mean4169.375
σ1898.642
min1551.000
max7200.000
mean12.663
σ0.346
min12.361
max13.229
iterations=8
operation_display=column_set() on indexed, repeat
rows=200000
mean36.617
σ0.002
min36.616
max36.620
mean4289.750
σ1978.683
min1551.000
max7200.000
mean98.041
σ242.618
min11.984
max698.491
iterations=8
operation_display=table_records(), no indexes
rows=200000
mean41.929
σ0.002
min41.928
max41.932
mean7200.000
σ0.000
min7200.000
max7200.000
mean14.879
σ1.432
min11.786
max16.083
iterations=8
operation_display=table_records(), no indexes, repeat
rows=200000
mean41.930
σ0.002
min41.928
max41.932
mean7200.000
σ0.000
min7200.000
max7200.000
mean14.374
σ1.445
min11.161
max15.600
iterations=8
operation_display=table_records(), repeat
rows=200000
mean41.929
σ0.002
min41.927
max41.932
mean4169.375
σ1898.642
min1551.000
max7200.000
mean13.677
σ1.541
min11.008
max15.273
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records()
rows=200000
mean27.605
σ0.002
min27.603
max27.607
mean4169.375
σ1898.642
min1551.000
max7200.000
mean9.222
σ0.350
min8.719
max9.667
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.400
σ0.002
min26.399
max26.403
mean4169.375
σ1898.642
min1551.000
max7200.000
mean6.673
σ0.324
min6.329
max7.213
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.666
σ0.002
min25.664
max25.670
mean4289.750
σ1978.683
min1551.000
max7200.000
mean6.150
σ0.627
min5.682
max7.654
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.661
σ0.002
min25.659
max25.663
mean4289.750
σ1978.683
min1551.000
max7200.000
mean5.732
σ0.497
min5.110
max6.859
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.969
σ0.002
min25.967
max25.972
mean4289.750
σ1978.683
min1551.000
max7200.000
mean5.802
σ0.542
min5.169
max7.033
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.969
σ0.002
min25.967
max25.971
mean4289.750
σ1978.683
min1551.000
max7200.000
mean5.757
σ0.403
min5.399
max6.705

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
mean7200.000
σ0.000
min7200.000
max7200.000
mean1181.375
σ387.549
min1030.191
max2140.087
iterations=8
operation_display=load_product(), with indexes
rows=200000
mean8744.560
σ0.041
min8744.545
max8744.662
mean3597.250
σ1819.206
min1075.000
max5839.000
mean4813.500
σ1691.174
min3512.674
max7715.764

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=column_set() on unindexed, dense
rows=200000
mean62.076
σ0.001
min62.075
max62.080
mean4169.375
σ1898.642
min1551.000
max7200.000
mean80.914
σ9.171
min72.582
max98.794
iterations=8
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.077
σ0.002
min62.076
max62.080
mean4169.375
σ1898.642
min1551.000
max7200.000
mean81.963
σ9.404
min72.071
max100.190
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int
rows=200000
mean40.945
σ0.002
min40.944
max40.947
mean7200.000
σ0.000
min7200.000
max7200.000
mean102.186
σ9.796
min82.733
max108.849
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int, repeat
rows=200000
mean40.945
σ0.002
min40.943
max40.948
mean7200.000
σ0.000
min7200.000
max7200.000
mean102.437
σ9.755
min82.884
max109.065
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end
rows=200000
mean40.951
σ0.002
min40.949
max40.953
mean7200.000
σ0.000
min7200.000
max7200.000
mean105.603
σ7.592
min89.821
max112.221
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat
rows=200000
mean40.950
σ0.002
min40.948
max40.954
mean7200.000
σ0.000
min7200.000
max7200.000
mean102.460
σ9.673
min83.128
max108.945
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int
rows=200000
mean66.687
σ0.002
min66.685
max66.690
mean7200.000
σ0.000
min7200.000
max7200.000
mean218.280
σ173.822
min131.146
max647.197
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat
rows=200000
mean66.687
σ0.002
min66.685
max66.689
mean7200.000
σ0.000
min7200.000
max7200.000
mean152.180
σ20.397
min113.894
max167.768

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=table_records()
rows=200000
mean11656.833
σ4.318
min11655.305
max11667.520
mean4169.375
σ1898.642
min1551.000
max7200.000
mean6672.861
σ1311.529
min4887.908
max8182.041
iterations=8
operation_display=vertical_lookup_list() on indexed
rows=200000
mean11560.065
σ0.001
min11560.064
max11560.068
mean7200.000
σ0.000
min7200.000
max7200.000
mean6035.933
σ1558.222
min4365.120
max8441.402

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=pointedIndexFromKvs
rows=200000
mean172.668
σ0.011
min172.650
max172.681
mean488.125
σ0.354
min488.000
max489.000
mean392.708
σ25.736
min345.211
max423.847
iterations=8
operation_display=pointedIndexFromKvs
rows=400000
mean357.462
σ0.164
min357.321
max357.677
mean573.000
σ0.000
min573.000
max573.000
mean785.961
σ65.878
min627.648
max832.099

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.085
σ0.761
min1007.611
max1011.230
mean7200.000
σ0.000
min7200.000
max7200.000
mean1.492
σ0.105
min1.390
max1.778

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean7200.000
σ0.000
min7200.000
max7200.000
mean0.319
σ0.122
min0.246
max0.536
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean7200.000
σ0.000
min7200.000
max7200.000
mean0.884
σ0.085
min0.814
max1.023
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean7200.000
σ0.000
min7200.000
max7200.000
mean0.528
σ0.050
min0.490
max0.613
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean7200.000
σ0.000
min7200.000
max7200.000
mean0.835
σ0.036
min0.800
max0.895

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.550
σ0.022
min963.528
max963.575
mean7200.000
σ0.000
min7200.000
max7200.000
mean0.815
σ0.054
min0.729
max0.856
name=cdr_enhanced_4k_loc.art
mean884.854
σ0.007
min884.847
max884.861
mean7200.000
σ0.000
min7200.000
max7200.000
mean0.677
σ0.046
min0.642
max0.737

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean7200.000
σ0.000
min7200.000
max7200.000
mean3.524
σ0.063
min3.406
max3.767
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.660
mean7200.000
σ0.000
min7200.000
max7200.000
mean3.504
σ0.096
min3.230
max3.825
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean7200.000
σ0.000
min7200.000
max7200.000
mean0.539
σ0.021
min0.510
max0.650
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean7200.000
σ0.000
min7200.000
max7200.000
mean0.508
σ0.015
min0.478
max0.589

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.602
σ0.215
min297.484
max298.195
mean7200.000
σ0.000
min7200.000
max7200.000
mean0.542
σ0.027
min0.511
max0.591

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.725
σ0.036
min289.679
max289.777
mean7200.000
σ0.000
min7200.000
max7200.000
mean0.389
σ0.002
min0.387
max0.391
iters=5
new-facts=1
prior-facts=6402
mean1299.648
σ0.111
min1299.506
max1299.766
mean7200.000
σ0.000
min7200.000
max7200.000
mean1.831
σ0.054
min1.783
max1.911
iters=5
new-facts=6402
prior-facts=1
mean1542.634
σ4.057
min1540.552
max1549.880
mean7200.000
σ0.000
min7200.000
max7200.000
mean2.351
σ0.208
min2.087
max2.614
iters=5
new-facts=6402
prior-facts=6402
mean1861.613
σ0.083
min1861.496
max1861.716
mean7200.000
σ0.000
min7200.000
max7200.000
mean2.892
σ0.056
min2.826
max2.969

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.566
σ0.252
min1.308
max1.910

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.149
σ577.064
min157.616
max1311.745
mean96.250
σ8.500
min92.000
max109.000
mean7200.000
σ0.000
min7200.000
max7200.000
mean0.541
σ0.553
min0.261
max1.371
policies=20
mean1576.420
σ0.356
min1576.175
max1576.947
mean920.000
σ0.000
min920.000
max920.000
mean7200.000
σ0.000
min7200.000
max7200.000
mean2.634
σ0.019
min2.621
max2.660
policies=200
mean15772.207
σ0.056
min15772.142
max15772.274
mean9200.000
σ0.000
min9200.000
max9200.000
mean7200.000
σ0.000
min7200.000
max7200.000
mean26.671
σ0.301
min26.391
max26.947