5c99015219f19ad9ae251409e2c1b4332006a0e3

Home / Branches / sergeiwinitzki/lan-43-benchmark-csv-final / 5c99015219f19ad9ae251409e2c1b4332006a0e3

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.055
σ0.369
min53.912
max55.104
mean415.000
σ0.000
min415.000
max415.000
mean0.140
σ0.003
min0.137
max0.145
cache=y
dps=1
iters=10
policies=100
mean43.394
σ0.007
min43.384
max43.406
mean415.000
σ0.000
min415.000
max415.000
mean0.120
σ0.003
min0.115
max0.127

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.074
max62.074
mean5090.500
σ2537.543
min1350.000
max8720.000
mean106.462
σ10.347
min86.812
max118.592

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.624
mean5090.500
σ2537.543
min1350.000
max8720.000
mean10337.545
σ1791.830
min6665.147
max12334.214

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=load_product(), with indexes
rows=200000
mean8744.546
σ0.035
min8744.534
max8744.646
mean4786.100
σ2639.804
min1071.000
max8720.000
mean4689.171
σ998.950
min3535.299
max6054.907
iterations=10
operation_display=load_product()with indexes
rows=200000
mean8744.532
σ0.002
min8744.531
max8744.535
mean8720.000
σ0.000
min8720.000
max8720.000
mean4511.299
σ1240.546
min3531.234
max6819.521

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
mean8720.000
σ0.000
min8720.000
max8720.000
mean13.510
σ1.948
min11.423
max15.899

CSV - table_records(), warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=table_records()
rows=200000
mean15088.238
σ0.002
min15088.236
max15088.241
mean8720.000
σ0.000
min8720.000
max8720.000
mean9271.608
σ2417.933
min6584.099
max12218.058

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
mean5090.500
σ2537.543
min1350.000
max8720.000
mean7.292
σ0.577
min6.009
max8.024
iterations=10
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.398
σ0.002
min26.397
max26.401
mean8720.000
σ0.000
min8720.000
max8720.000
mean6.939
σ0.329
min6.233
max7.324

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.634
σ0.003
min25.631
max25.639
mean8720.000
σ0.000
min8720.000
max8720.000
mean5.282
σ0.212
min4.967
max5.577
iterations=10
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.628
σ0.002
min25.626
max25.630
mean8720.000
σ0.000
min8720.000
max8720.000
mean5.168
σ0.180
min4.921
max5.415
iterations=10
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.932
σ0.002
min25.930
max25.935
mean8720.000
σ0.000
min8720.000
max8720.000
mean5.215
σ0.205
min4.912
max5.448
iterations=10
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.931
σ0.002
min25.930
max25.934
mean8720.000
σ0.000
min8720.000
max8720.000
mean5.209
σ0.193
min4.899
max5.429

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=pointedIndexFromKvs
rows=200000
mean172.661
σ0.012
min172.643
max172.677
mean485.900
σ1.449
min485.000
max488.000
mean388.337
σ35.851
min320.105
max420.314
iterations=10
operation_display=pointedIndexFromKvs
rows=400000
mean357.411
σ0.143
min357.321
max357.627
mean562.000
σ0.000
min562.000
max562.000
mean765.476
σ55.854
min628.821
max804.955

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1006.875
σ0.751
min1006.406
max1009.979
mean8720.000
σ0.000
min8720.000
max8720.000
mean1.578
σ0.160
min1.302
max2.037

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.003
min0.882
max0.887
mean8720.000
σ0.000
min8720.000
max8720.000
mean0.310
σ0.107
min0.256
max0.501
name=error_case.art
mean2.339
σ0.003
min2.337
max2.342
mean8720.000
σ0.000
min8720.000
max8720.000
mean0.635
σ0.079
min0.591
max0.775
name=heavy_item.art
mean1.524
σ0.002
min1.522
max1.526
mean8720.000
σ0.000
min8720.000
max8720.000
mean0.527
σ0.051
min0.491
max0.615
name=nested_use.art
mean2.361
σ0.002
min2.360
max2.364
mean8720.000
σ0.000
min8720.000
max8720.000
mean0.834
σ0.043
min0.803
max0.907

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.837
σ0.033
min964.810
max964.892
mean8720.000
σ0.000
min8720.000
max8720.000
mean0.788
σ0.035
min0.733
max0.828
name=cdr_enhanced_4k_loc.art
mean885.513
σ0.008
min885.504
max885.523
mean8720.000
σ0.000
min8720.000
max8720.000
mean0.732
σ0.005
min0.725
max0.737

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.716
σ0.002
min7.715
max7.721
mean8720.000
σ0.000
min8720.000
max8720.000
mean4.214
σ0.078
min4.076
max4.468
name=record_render_large_syntax_err.art
mean7.665
σ0.002
min7.664
max7.669
mean8720.000
σ0.000
min8720.000
max8720.000
mean4.222
σ0.080
min4.060
max4.557
name=record_render_success.art
mean2.291
σ0.002
min2.290
max2.294
mean8720.000
σ0.000
min8720.000
max8720.000
mean0.739
σ0.020
min0.710
max0.880
name=record_render_syntax_err.art
mean2.166
σ0.002
min2.165
max2.169
mean8720.000
σ0.000
min8720.000
max8720.000
mean0.701
σ0.019
min0.645
max0.810

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean295.376
σ0.191
min295.242
max295.900
mean8720.000
σ0.000
min8720.000
max8720.000
mean0.595
σ0.050
min0.512
max0.688

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean285.383
σ0.028
min285.347
max285.416
mean8720.000
σ0.000
min8720.000
max8720.000
mean0.394
σ0.008
min0.388
max0.408
iters=5
new-facts=1
prior-facts=6402
mean1295.771
σ0.059
min1295.681
max1295.816
mean8720.000
σ0.000
min8720.000
max8720.000
mean1.932
σ0.083
min1.817
max1.999
iters=5
new-facts=6402
prior-facts=1
mean1539.979
σ6.904
min1536.718
max1552.326
mean8720.000
σ0.000
min8720.000
max8720.000
mean2.340
σ0.213
min2.102
max2.645
iters=5
new-facts=6402
prior-facts=6402
mean1857.694
σ0.041
min1857.651
max1857.746
mean8720.000
σ0.000
min8720.000
max8720.000
mean3.097
σ0.254
min2.850
max3.525

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.231
σ0.294
min0.933
max1.642

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean445.741
σ580.932
min155.273
max1317.139
mean96.250
σ8.500
min92.000
max109.000
mean8720.000
σ0.000
min8720.000
max8720.000
mean0.542
σ0.554
min0.263
max1.373
policies=20
mean1552.960
σ0.268
min1552.763
max1553.355
mean920.000
σ0.000
min920.000
max920.000
mean8720.000
σ0.000
min8720.000
max8720.000
mean2.609
σ0.016
min2.593
max2.632
policies=200
mean15538.035
σ0.133
min15537.869
max15538.187
mean9200.000
σ0.000
min9200.000
max9200.000
mean8720.000
σ0.000
min8720.000
max8720.000
mean26.326
σ0.091
min26.261
max26.460