b1ee90ab3586af7441c36e3ab2e40df2de558018

Home / Branches / sergeiwinitzki/lan-43-benchmark-csv-final / b1ee90ab3586af7441c36e3ab2e40df2de558018

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.055
σ0.369
min53.906
max55.103
mean414.000
σ0.000
min414.000
max414.000
mean0.138
σ0.005
min0.131
max0.149
cache=y
dps=1
iters=10
policies=100
mean43.394
σ0.005
min43.386
max43.400
mean414.000
σ0.000
min414.000
max414.000
mean0.122
σ0.004
min0.116
max0.128

CSV - column_set() on unindexed

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.074
σ0.000
min62.073
max62.075
mean5165.200
σ2657.716
min1350.000
max8665.000
mean102.290
σ13.069
min79.759
max116.928

CSV - column_set(), warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=column_set() on unindexed, dense
rows=200000
mean15109.632
σ3.862
min15108.410
max15120.623
mean5165.200
σ2657.716
min1350.000
max8665.000
mean9995.046
σ2183.084
min6708.088
max11928.234

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=load_product(), with indexes
rows=200000
mean8744.545
σ0.035
min8744.534
max8744.645
mean4750.600
σ2616.392
min1070.000
max8665.000
mean4623.202
σ1014.644
min3509.756
max6255.217
iterations=10
operation_display=load_product()with indexes
rows=200000
mean8744.532
σ0.002
min8744.530
max8744.535
mean8701.200
σ114.474
min8665.000
max9027.000
mean4586.556
σ1063.259
min3503.572
max6373.361

CSV - table_records()

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=table_records(), repeat
rows=200000
mean41.901
σ0.002
min41.899
max41.904
mean8701.200
σ114.474
min8665.000
max9027.000
mean14.311
σ1.655
min11.485
max16.046

CSV - table_records(), warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=table_records()
rows=200000
mean15088.238
σ0.002
min15088.236
max15088.242
mean8701.200
σ114.474
min8665.000
max9027.000
mean10079.189
σ2135.831
min6510.671
max12577.149

CSV - vertical_lookup_list() on indexed

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=vertical_lookup_list() on indexed, after column_set(), repeat
rows=200000
mean26.398
σ0.001
min26.397
max26.401
mean5165.200
σ2657.716
min1350.000
max8665.000
mean7.426
σ0.425
min6.698
max7.924
iterations=10
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.398
σ0.002
min26.397
max26.401
mean8701.200
σ114.474
min8665.000
max9027.000
mean7.170
σ0.308
min6.698
max7.466

CSV - vertical_lookup_row_list() on indexed

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.633
σ0.002
min25.631
max25.637
mean8701.200
σ114.474
min8665.000
max9027.000
mean5.424
σ0.127
min5.191
max5.658
iterations=10
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.628
σ0.002
min25.626
max25.630
mean8701.200
σ114.474
min8665.000
max9027.000
mean5.305
σ0.159
min5.037
max5.513
iterations=10
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.932
σ0.002
min25.930
max25.935
mean8701.200
σ114.474
min8665.000
max9027.000
mean5.303
σ0.160
min4.913
max5.442
iterations=10
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.931
σ0.002
min25.930
max25.934
mean8701.200
σ114.474
min8665.000
max9027.000
mean5.312
σ0.123
min5.056
max5.440

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=pointedIndexFromKvs
rows=200000
mean172.666
σ0.012
min172.644
max172.675
mean484.000
σ0.000
min484.000
max484.000
mean388.116
σ43.627
min270.590
max419.654
iterations=10
operation_display=pointedIndexFromKvs
rows=400000
mean357.406
σ0.140
min357.321
max357.654
mean560.000
σ0.000
min560.000
max560.000
mean786.213
σ34.104
min701.573
max815.177

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1006.876
σ0.751
min1006.406
max1009.979
mean9027.000
σ0.000
min9027.000
max9027.000
mean1.509
σ0.116
min1.460
max1.998

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.003
min0.882
max0.887
mean9027.000
σ0.000
min9027.000
max9027.000
mean0.419
σ0.133
min0.339
max0.656
name=error_case.art
mean2.339
σ0.003
min2.337
max2.342
mean9027.000
σ0.000
min9027.000
max9027.000
mean0.878
σ0.089
min0.818
max1.034
name=heavy_item.art
mean1.524
σ0.002
min1.522
max1.526
mean9027.000
σ0.000
min9027.000
max9027.000
mean0.530
σ0.038
min0.501
max0.594
name=nested_use.art
mean2.361
σ0.002
min2.360
max2.364
mean9027.000
σ0.000
min9027.000
max9027.000
mean0.856
σ0.039
min0.814
max0.916

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.830
σ0.028
min964.802
max964.864
mean9027.000
σ0.000
min9027.000
max9027.000
mean0.819
σ0.024
min0.792
max0.843
name=cdr_enhanced_4k_loc.art
mean885.510
σ0.005
min885.504
max885.516
mean9027.000
σ0.000
min9027.000
max9027.000
mean0.710
σ0.037
min0.644
max0.728

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.716
σ0.002
min7.715
max7.721
mean9027.000
σ0.000
min9027.000
max9027.000
mean4.292
σ0.099
min4.132
max4.617
name=record_render_large_syntax_err.art
mean7.665
σ0.002
min7.664
max7.668
mean9027.000
σ0.000
min9027.000
max9027.000
mean4.237
σ0.106
min4.077
max5.082
name=record_render_success.art
mean2.291
σ0.002
min2.290
max2.294
mean9027.000
σ0.000
min9027.000
max9027.000
mean0.743
σ0.017
min0.707
max0.849
name=record_render_syntax_err.art
mean2.166
σ0.002
min2.165
max2.169
mean9027.000
σ0.000
min9027.000
max9027.000
mean0.699
σ0.032
min0.496
max0.753

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean295.497
σ0.218
min295.344
max296.090
mean9027.000
σ0.000
min9027.000
max9027.000
mean0.554
σ0.028
min0.513
max0.582

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean285.382
σ0.036
min285.334
max285.422
mean9027.000
σ0.000
min9027.000
max9027.000
mean0.395
σ0.009
min0.386
max0.407
iters=5
new-facts=1
prior-facts=6402
mean1295.892
σ0.067
min1295.828
max1295.982
mean9027.000
σ0.000
min9027.000
max9027.000
mean2.312
σ0.121
min2.162
max2.456
iters=5
new-facts=6402
prior-facts=1
mean1539.963
σ6.897
min1536.689
max1552.298
mean9027.000
σ0.000
min9027.000
max9027.000
mean2.304
σ0.210
min2.144
max2.671
iters=5
new-facts=6402
prior-facts=6402
mean1857.685
σ0.051
min1857.611
max1857.730
mean9027.000
σ0.000
min9027.000
max9027.000
mean3.142
σ0.271
min2.852
max3.453

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.623
σ0.189
min1.322
max1.847

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean445.740
σ580.933
min155.269
max1317.140
mean96.250
σ8.500
min92.000
max109.000
mean9027.000
σ0.000
min9027.000
max9027.000
mean0.541
σ0.540
min0.267
max1.351
policies=20
mean1552.974
σ0.325
min1552.748
max1553.456
mean920.000
σ0.000
min920.000
max920.000
mean9027.000
σ0.000
min9027.000
max9027.000
mean2.593
σ0.031
min2.561
max2.622
policies=200
mean15537.971
σ0.107
min15537.830
max15538.063
mean9200.000
σ0.000
min9200.000
max9200.000
mean9027.000
σ0.000
min9027.000
max9027.000
mean26.196
σ0.082
min26.128
max26.292