d1f7da133163f36ad8915e88511fc06f9944888b

Home / Branches / dh/version-status-filter / d1f7da133163f36ad8915e88511fc06f9944888b

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.616
σ0.348
min54.485
max55.607
mean417.000
σ0.000
min417.000
max417.000
mean0.142
σ0.003
min0.138
max0.149
cache=y
dps=1
iters=10
policies=100
mean43.787
σ0.006
min43.780
max43.798
mean417.000
σ0.000
min417.000
max417.000
mean0.126
σ0.004
min0.123
max0.133

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
mean4287.000
σ1980.549
min1552.000
max7211.000
mean99.378
σ244.817
min12.509
max705.270
iterations=8
operation_display=column_set() on indexed, repeat
rows=200000
mean36.618
σ0.002
min36.616
max36.620
mean4287.000
σ1980.549
min1552.000
max7211.000
mean13.643
σ3.092
min11.871
max21.119
iterations=8
operation_display=table_records(), no indexes
rows=200000
mean41.930
σ0.002
min41.928
max41.932
mean7211.000
σ0.000
min7211.000
max7211.000
mean15.056
σ0.903
min13.320
max16.073
iterations=8
operation_display=table_records(), no indexes, repeat
rows=200000
mean41.929
σ0.002
min41.928
max41.932
mean7211.000
σ0.000
min7211.000
max7211.000
mean13.811
σ1.122
min11.123
max14.447
iterations=8
operation_display=table_records(), repeat
rows=200000
mean41.928
σ0.002
min41.927
max41.931
mean4170.625
σ1903.176
min1552.000
max7211.000
mean13.706
σ1.671
min11.317
max15.307
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records()
rows=200000
mean27.604
σ0.002
min27.603
max27.607
mean4170.625
σ1903.176
min1552.000
max7211.000
mean8.989
σ0.399
min8.172
max9.455
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.400
σ0.002
min26.399
max26.403
mean4170.625
σ1903.176
min1552.000
max7211.000
mean6.856
σ0.225
min6.519
max7.151
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.666
σ0.002
min25.664
max25.668
mean4287.000
σ1980.549
min1552.000
max7211.000
mean6.140
σ0.575
min5.728
max7.526
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.661
σ0.002
min25.659
max25.663
mean4287.000
σ1980.549
min1552.000
max7211.000
mean5.807
σ0.615
min5.337
max7.264
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.968
σ0.002
min25.967
max25.971
mean4287.000
σ1980.549
min1552.000
max7211.000
mean5.903
σ0.651
min5.456
max7.470
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.968
σ0.001
min25.967
max25.971
mean4287.000
σ1980.549
min1552.000
max7211.000
mean5.711
σ0.649
min5.137
max7.267

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
mean7211.000
σ0.000
min7211.000
max7211.000
mean1439.852
σ616.541
min1048.888
max2708.232
iterations=8
operation_display=load_product(), with indexes
rows=200000
mean8744.560
σ0.040
min8744.545
max8744.659
mean3592.500
σ1818.744
min1071.000
max5824.000
mean5071.876
σ1713.985
min3570.940
max7540.555

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
mean4170.625
σ1903.176
min1552.000
max7211.000
mean80.110
σ7.596
min72.117
max91.352
iterations=8
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.078
σ0.002
min62.076
max62.080
mean4170.625
σ1903.176
min1552.000
max7211.000
mean80.739
σ7.557
min72.966
max91.941
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int
rows=200000
mean40.945
σ0.002
min40.944
max40.947
mean7211.000
σ0.000
min7211.000
max7211.000
mean103.818
σ6.651
min91.113
max108.536
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int, repeat
rows=200000
mean40.945
σ0.002
min40.944
max40.947
mean7211.000
σ0.000
min7211.000
max7211.000
mean103.885
σ6.853
min90.528
max108.920
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end
rows=200000
mean40.951
σ0.002
min40.949
max40.954
mean7211.000
σ0.000
min7211.000
max7211.000
mean106.812
σ5.264
min96.627
max112.121
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat
rows=200000
mean40.950
σ0.002
min40.949
max40.953
mean7211.000
σ0.000
min7211.000
max7211.000
mean103.790
σ6.614
min90.948
max108.420
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int
rows=200000
mean66.687
σ0.002
min66.686
max66.689
mean7211.000
σ0.000
min7211.000
max7211.000
mean233.239
σ208.275
min142.051
max748.141
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat
rows=200000
mean66.686
σ0.002
min66.685
max66.689
mean7211.000
σ0.000
min7211.000
max7211.000
mean155.827
σ13.868
min130.359
max167.477

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=table_records()
rows=200000
mean11656.833
σ4.318
min11655.305
max11667.519
mean4170.625
σ1903.176
min1552.000
max7211.000
mean6700.613
σ1227.809
min4935.603
max7937.203
iterations=8
operation_display=vertical_lookup_list() on indexed
rows=200000
mean11560.066
σ0.002
min11560.064
max11560.069
mean7211.000
σ0.000
min7211.000
max7211.000
mean5933.960
σ1343.616
min4425.384
max7702.822

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=pointedIndexFromKvs
rows=200000
mean172.669
σ0.007
min172.657
max172.675
mean487.000
σ0.000
min487.000
max487.000
mean403.873
σ17.326
min367.075
max420.488
iterations=8
operation_display=pointedIndexFromKvs
rows=400000
mean357.457
σ0.151
min357.321
max357.693
mean564.000
σ0.000
min564.000
max564.000
mean742.519
σ71.473
min626.659
max818.958

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.084
σ0.760
min1007.608
max1011.227
mean7211.000
σ0.000
min7211.000
max7211.000
mean1.584
σ0.125
min1.472
max1.988

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.418
σ0.145
min0.335
max0.675
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.892
σ0.094
min0.828
max1.055
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.536
σ0.043
min0.492
max0.602
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.849
σ0.037
min0.819
max0.913

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.552
σ0.024
min963.528
max963.584
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.841
σ0.024
min0.801
max0.863
name=cdr_enhanced_4k_loc.art
mean884.853
σ0.005
min884.847
max884.859
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.713
σ0.055
min0.615
max0.740

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.710
mean7211.000
σ0.000
min7211.000
max7211.000
mean4.307
σ0.082
min4.183
max4.619
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean7211.000
σ0.000
min7211.000
max7211.000
mean4.299
σ0.093
min4.172
max4.651
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.757
σ0.026
min0.642
max0.881
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.638
σ0.091
min0.472
max0.863

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.243
σ0.218
min297.088
max297.821
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.552
σ0.027
min0.517
max0.592

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.729
σ0.032
min289.685
max289.773
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.390
σ0.001
min0.389
max0.391
iters=5
new-facts=1
prior-facts=6402
mean1299.655
σ0.118
min1299.508
max1299.778
mean7211.000
σ0.000
min7211.000
max7211.000
mean1.845
σ0.037
min1.806
max1.886
iters=5
new-facts=6402
prior-facts=1
mean1542.625
σ4.057
min1540.581
max1549.873
mean7211.000
σ0.000
min7211.000
max7211.000
mean2.316
σ0.183
min2.071
max2.525
iters=5
new-facts=6402
prior-facts=6402
mean1861.621
σ0.090
min1861.498
max1861.739
mean7211.000
σ0.000
min7211.000
max7211.000
mean2.837
σ0.066
min2.722
max2.888

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.565
σ0.258
min1.295
max1.887

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.147
σ577.064
min157.612
max1311.744
mean96.250
σ8.500
min92.000
max109.000
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.536
σ0.534
min0.267
max1.337
policies=20
mean1576.411
σ0.350
min1576.175
max1576.931
mean920.000
σ0.000
min920.000
max920.000
mean7211.000
σ0.000
min7211.000
max7211.000
mean2.629
σ0.016
min2.613
max2.644
policies=200
mean15772.259
σ0.091
min15772.133
max15772.343
mean9200.000
σ0.000
min9200.000
max9200.000
mean7211.000
σ0.000
min7211.000
max7211.000
mean26.480
σ0.029
min26.449
max26.517