85748013804ace644a88844cd9f8242dd7d224b6

Home / Branches / pablo/nex-165-adding-a-non-batched-targeted-replyto-request / 85748013804ace644a88844cd9f8242dd7d224b6

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.617
σ0.350
min54.481
max55.613
mean415.000
σ0.000
min415.000
max415.000
mean0.139
σ0.005
min0.135
max0.150
cache=y
dps=1
iters=10
policies=100
mean43.786
σ0.006
min43.778
max43.799
mean415.000
σ0.000
min415.000
max415.000
mean0.123
σ0.004
min0.120
max0.130

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=column_set() on indexed
rows=200000
mean36.617
σ0.002
min36.616
max36.619
mean4281.875
σ1977.280
min1547.000
max7207.000
mean81.837
σ194.853
min12.717
max564.074
iterations=8
operation_display=column_set() on indexed, repeat
rows=200000
mean36.617
σ0.002
min36.616
max36.620
mean4281.875
σ1977.280
min1547.000
max7207.000
mean14.414
σ4.755
min11.889
max26.069
iterations=8
operation_display=table_records(), no indexes
rows=200000
mean41.930
σ0.002
min41.928
max41.932
mean7207.000
σ0.000
min7207.000
max7207.000
mean15.285
σ0.903
min13.440
max16.313
iterations=8
operation_display=table_records(), no indexes, repeat
rows=200000
mean41.929
σ0.002
min41.928
max41.932
mean7207.000
σ0.000
min7207.000
max7207.000
mean13.561
σ1.429
min11.772
max15.325
iterations=8
operation_display=table_records(), repeat
rows=200000
mean41.929
σ0.002
min41.927
max41.931
mean4165.125
σ1900.024
min1547.000
max7207.000
mean13.819
σ1.599
min11.196
max15.526
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records()
rows=200000
mean27.605
σ0.003
min27.603
max27.611
mean4165.125
σ1900.024
min1547.000
max7207.000
mean8.902
σ0.254
min8.394
max9.212
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.400
σ0.002
min26.399
max26.403
mean4165.125
σ1900.024
min1547.000
max7207.000
mean6.872
σ0.271
min6.252
max7.154
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.666
σ0.002
min25.664
max25.669
mean4281.875
σ1977.280
min1547.000
max7207.000
mean6.397
σ1.137
min5.779
max9.193
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.661
σ0.002
min25.659
max25.663
mean4281.875
σ1977.280
min1547.000
max7207.000
mean5.935
σ1.166
min5.279
max8.804
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.969
σ0.002
min25.967
max25.971
mean4281.875
σ1977.280
min1547.000
max7207.000
mean5.971
σ1.049
min5.246
max8.532
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.968
σ0.002
min25.967
max25.971
mean4281.875
σ1977.280
min1547.000
max7207.000
mean5.862
σ1.047
min5.180
max8.426

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.597
mean7207.000
σ0.000
min7207.000
max7207.000
mean1357.776
σ456.670
min1054.112
max2221.274
iterations=8
operation_display=load_product(), with indexes
rows=200000
mean8744.560
σ0.040
min8744.545
max8744.659
mean3587.875
σ1813.883
min1068.000
max5813.000
mean4990.605
σ1560.449
min3572.880
max7234.244

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
mean4165.125
σ1900.024
min1547.000
max7207.000
mean81.632
σ10.288
min71.880
max100.976
iterations=8
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.077
σ0.002
min62.076
max62.080
mean4165.125
σ1900.024
min1547.000
max7207.000
mean82.171
σ9.738
min73.671
max100.299
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int
rows=200000
mean40.944
σ0.001
min40.944
max40.947
mean7207.000
σ0.000
min7207.000
max7207.000
mean103.246
σ8.826
min85.227
max108.541
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int, repeat
rows=200000
mean40.946
σ0.002
min40.944
max40.947
mean7207.000
σ0.000
min7207.000
max7207.000
mean103.079
σ8.825
min84.899
max108.365
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end
rows=200000
mean40.950
σ0.002
min40.949
max40.953
mean7207.000
σ0.000
min7207.000
max7207.000
mean105.688
σ8.645
min91.137
max113.710
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat
rows=200000
mean40.951
σ0.002
min40.949
max40.953
mean7207.000
σ0.000
min7207.000
max7207.000
mean103.118
σ8.833
min85.024
max108.210
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int
rows=200000
mean66.687
σ0.002
min66.685
max66.690
mean7207.000
σ0.000
min7207.000
max7207.000
mean265.197
σ302.707
min133.429
max1013.735
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat
rows=200000
mean66.687
σ0.002
min66.685
max66.690
mean7207.000
σ0.000
min7207.000
max7207.000
mean156.041
σ14.583
min134.109
max167.020

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=table_records()
rows=200000
mean11656.833
σ4.318
min11655.305
max11667.520
mean4165.125
σ1900.024
min1547.000
max7207.000
mean6887.658
σ1129.345
min4964.049
max7991.354
iterations=8
operation_display=vertical_lookup_list() on indexed
rows=200000
mean11560.066
σ0.002
min11560.065
max11560.068
mean7207.000
σ0.000
min7207.000
max7207.000
mean5903.518
σ1547.152
min4458.178
max7869.732

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=pointedIndexFromKvs
rows=200000
mean172.660
σ0.018
min172.633
max172.681
mean486.125
σ0.354
min486.000
max487.000
mean378.599
σ32.632
min327.347
max416.220
iterations=8
operation_display=pointedIndexFromKvs
rows=400000
mean357.478
σ0.137
min357.321
max357.627
mean564.000
σ0.000
min564.000
max564.000
mean721.576
σ91.796
min566.019
max846.477

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.082
σ0.761
min1007.609
max1011.229
mean7207.000
σ0.000
min7207.000
max7207.000
mean1.532
σ0.142
min1.355
max1.965

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean7207.000
σ0.000
min7207.000
max7207.000
mean0.310
σ0.117
min0.248
max0.519
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean7207.000
σ0.000
min7207.000
max7207.000
mean0.653
σ0.075
min0.593
max0.781
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean7207.000
σ0.000
min7207.000
max7207.000
mean0.483
σ0.060
min0.391
max0.531
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean7207.000
σ0.000
min7207.000
max7207.000
mean0.854
σ0.044
min0.823
max0.930

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.551
σ0.022
min963.535
max963.588
mean7207.000
σ0.000
min7207.000
max7207.000
mean0.790
σ0.047
min0.720
max0.842
name=cdr_enhanced_4k_loc.art
mean884.854
σ0.007
min884.847
max884.863
mean7207.000
σ0.000
min7207.000
max7207.000
mean0.743
σ0.003
min0.738
max0.746

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.710
mean7207.000
σ0.000
min7207.000
max7207.000
mean4.306
σ0.105
min4.158
max4.664
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean7207.000
σ0.000
min7207.000
max7207.000
mean4.315
σ0.072
min4.171
max4.577
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean7207.000
σ0.000
min7207.000
max7207.000
mean0.746
σ0.027
min0.708
max0.869
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean7207.000
σ0.000
min7207.000
max7207.000
mean0.724
σ0.015
min0.692
max0.806

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.630
σ0.220
min297.456
max298.205
mean7207.000
σ0.000
min7207.000
max7207.000
mean0.536
σ0.042
min0.494
max0.607

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.722
σ0.050
min289.644
max289.776
mean7207.000
σ0.000
min7207.000
max7207.000
mean0.396
σ0.001
min0.395
max0.397
iters=5
new-facts=1
prior-facts=6402
mean1299.652
σ0.112
min1299.515
max1299.767
mean7207.000
σ0.000
min7207.000
max7207.000
mean1.860
σ0.072
min1.801
max1.955
iters=5
new-facts=6402
prior-facts=1
mean1542.622
σ4.023
min1540.577
max1549.809
mean7207.000
σ0.000
min7207.000
max7207.000
mean2.237
σ0.100
min2.096
max2.338
iters=5
new-facts=6402
prior-facts=6402
mean1861.614
σ0.068
min1861.526
max1861.689
mean7207.000
σ0.000
min7207.000
max7207.000
mean2.915
σ0.087
min2.844
max3.027

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.480
σ0.333
min1.026
max1.812

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.149
σ577.063
min157.616
max1311.743
mean96.250
σ8.500
min92.000
max109.000
mean7207.000
σ0.000
min7207.000
max7207.000
mean0.573
σ0.603
min0.270
max1.476
policies=20
mean1576.429
σ0.357
min1576.184
max1576.958
mean920.000
σ0.000
min920.000
max920.000
mean7207.000
σ0.000
min7207.000
max7207.000
mean2.641
σ0.025
min2.616
max2.665
policies=200
mean15772.205
σ0.162
min15772.037
max15772.426
mean9200.000
σ0.000
min9200.000
max9200.000
mean7207.000
σ0.000
min7207.000
max7207.000
mean26.513
σ0.135
min26.332
max26.659