068c0d79d745ed4e27f9d4e55142afb1692a6ef8

Home / Branches / marcelkalveram/exp-1443-implement-todo-tasks-node / 068c0d79d745ed4e27f9d4e55142afb1692a6ef8

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.617
σ0.350
min54.483
max55.613
mean420.000
σ0.000
min420.000
max420.000
mean0.140
σ0.006
min0.133
max0.149
cache=y
dps=1
iters=10
policies=100
mean43.785
σ0.005
min43.779
max43.796
mean420.000
σ0.000
min420.000
max420.000
mean0.124
σ0.005
min0.120
max0.132

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
mean4292.125
σ1980.590
min1555.000
max7214.000
mean104.475
σ259.509
min12.452
max746.727
iterations=8
operation_display=column_set() on indexed, repeat
rows=200000
mean36.618
σ0.002
min36.616
max36.620
mean4292.125
σ1980.590
min1555.000
max7214.000
mean13.937
σ2.551
min12.447
max20.194
iterations=8
operation_display=table_records(), no indexes
rows=200000
mean41.930
σ0.002
min41.928
max41.932
mean7214.000
σ0.000
min7214.000
max7214.000
mean14.931
σ0.858
min13.463
max15.711
iterations=8
operation_display=table_records(), no indexes, repeat
rows=200000
mean41.929
σ0.002
min41.928
max41.932
mean7214.000
σ0.000
min7214.000
max7214.000
mean13.955
σ0.864
min12.338
max15.088
iterations=8
operation_display=table_records(), repeat
rows=200000
mean41.928
σ0.002
min41.927
max41.931
mean4175.875
σ1903.211
min1555.000
max7214.000
mean13.702
σ1.723
min11.156
max15.417
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records()
rows=200000
mean27.604
σ0.002
min27.603
max27.607
mean4175.875
σ1903.211
min1555.000
max7214.000
mean9.219
σ0.360
min8.702
max9.859
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.400
σ0.002
min26.399
max26.403
mean4175.875
σ1903.211
min1555.000
max7214.000
mean6.691
σ0.494
min5.950
max7.429
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.666
σ0.002
min25.665
max25.668
mean4292.125
σ1980.590
min1555.000
max7214.000
mean6.336
σ0.470
min5.821
max7.354
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.661
σ0.002
min25.659
max25.663
mean4292.125
σ1980.590
min1555.000
max7214.000
mean5.742
σ0.586
min5.244
max7.118
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.968
σ0.002
min25.967
max25.971
mean4292.125
σ1980.590
min1555.000
max7214.000
mean5.798
σ0.624
min5.197
max7.239
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.968
σ0.001
min25.967
max25.971
mean4292.125
σ1980.590
min1555.000
max7214.000
mean5.704
σ0.643
min5.199
max7.220

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=load_product(), no indexes
rows=200000
mean2524.595
σ0.002
min2524.594
max2524.598
mean7214.000
σ0.000
min7214.000
max7214.000
mean1419.739
σ591.870
min1043.463
max2622.294
iterations=8
operation_display=load_product(), with indexes
rows=200000
mean8744.561
σ0.040
min8744.544
max8744.659
mean3597.250
σ1819.794
min1075.000
max5830.000
mean5086.829
σ1719.220
min3526.435
max7506.132

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
mean4175.875
σ1903.211
min1555.000
max7214.000
mean80.744
σ9.685
min71.605
max98.770
iterations=8
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.078
σ0.002
min62.076
max62.080
mean4175.875
σ1903.211
min1555.000
max7214.000
mean81.277
σ9.720
min71.857
max99.602
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int
rows=200000
mean40.945
σ0.002
min40.944
max40.947
mean7214.000
σ0.000
min7214.000
max7214.000
mean103.152
σ6.879
min90.154
max108.046
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int, repeat
rows=200000
mean40.945
σ0.002
min40.944
max40.947
mean7214.000
σ0.000
min7214.000
max7214.000
mean103.291
σ6.815
min90.487
max108.352
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end
rows=200000
mean40.951
σ0.002
min40.949
max40.954
mean7214.000
σ0.000
min7214.000
max7214.000
mean105.929
σ4.987
min96.743
max111.923
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat
rows=200000
mean40.950
σ0.002
min40.949
max40.953
mean7214.000
σ0.000
min7214.000
max7214.000
mean103.285
σ6.956
min90.444
max108.630
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int
rows=200000
mean66.687
σ0.002
min66.686
max66.689
mean7214.000
σ0.000
min7214.000
max7214.000
mean229.984
σ198.828
min142.173
max721.451
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat
rows=200000
mean66.687
σ0.002
min66.685
max66.690
mean7214.000
σ0.000
min7214.000
max7214.000
mean155.697
σ15.227
min127.364
max169.136

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=table_records()
rows=200000
mean11656.833
σ4.318
min11655.305
max11667.519
mean4175.875
σ1903.211
min1555.000
max7214.000
mean6553.575
σ990.032
min4929.627
max7999.796
iterations=8
operation_display=vertical_lookup_list() on indexed
rows=200000
mean11560.066
σ0.002
min11560.064
max11560.069
mean7214.000
σ0.000
min7214.000
max7214.000
mean6094.026
σ1432.000
min4436.528
max7816.731

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=pointedIndexFromKvs
rows=200000
mean172.654
σ0.014
min172.636
max172.671
mean491.000
σ0.000
min491.000
max491.000
mean358.329
σ53.891
min269.849
max418.216
iterations=8
operation_display=pointedIndexFromKvs
rows=400000
mean357.464
σ0.147
min357.321
max357.633
mean568.000
σ0.000
min568.000
max568.000
mean780.184
σ44.620
min717.332
max819.668

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.081
σ0.761
min1007.609
max1011.227
mean7214.000
σ0.000
min7214.000
max7214.000
mean1.561
σ0.157
min1.454
max2.109

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.394
σ0.086
min0.339
max0.545
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.875
σ0.091
min0.816
max1.032
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.536
σ0.036
min0.508
max0.595
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.839
σ0.033
min0.816
max0.895

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.552
σ0.024
min963.527
max963.583
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.770
σ0.062
min0.702
max0.845
name=cdr_enhanced_4k_loc.art
mean884.853
σ0.005
min884.847
max884.859
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.720
σ0.022
min0.685
max0.737

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean7214.000
σ0.000
min7214.000
max7214.000
mean4.035
σ0.398
min3.451
max5.232
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.661
mean7214.000
σ0.000
min7214.000
max7214.000
mean4.281
σ0.063
min4.154
max4.502
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.755
σ0.017
min0.718
max0.866
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.711
σ0.013
min0.685
max0.761

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.375
σ0.231
min297.197
max298.002
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.563
σ0.028
min0.510
max0.604

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.722
σ0.052
min289.643
max289.785
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.407
σ0.015
min0.396
max0.431
iters=5
new-facts=1
prior-facts=6402
mean1299.637
σ0.096
min1299.517
max1299.747
mean7214.000
σ0.000
min7214.000
max7214.000
mean1.955
σ0.095
min1.815
max2.045
iters=5
new-facts=6402
prior-facts=1
mean1542.645
σ4.145
min1540.587
max1550.053
mean7214.000
σ0.000
min7214.000
max7214.000
mean2.369
σ0.450
min2.071
max3.157
iters=5
new-facts=6402
prior-facts=6402
mean1861.594
σ0.064
min1861.501
max1861.662
mean7214.000
σ0.000
min7214.000
max7214.000
mean2.860
σ0.088
min2.730
max2.979

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.585
σ0.265
min1.283
max1.819

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.148
σ577.065
min157.613
max1311.745
mean96.250
σ8.500
min92.000
max109.000
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.552
σ0.562
min0.269
max1.395
policies=20
mean1576.413
σ0.345
min1576.179
max1576.925
mean920.000
σ0.000
min920.000
max920.000
mean7214.000
σ0.000
min7214.000
max7214.000
mean2.629
σ0.022
min2.607
max2.655
policies=200
mean15772.126
σ0.145
min15772.030
max15772.342
mean9200.000
σ0.000
min9200.000
max9200.000
mean7214.000
σ0.000
min7214.000
max7214.000
mean26.594
σ0.185
min26.456
max26.866