8f9359cfccc47b5710077ab039051482d80bf0cd

Home / Branches / jaak/migration-units-in-move / 8f9359cfccc47b5710077ab039051482d80bf0cd

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean53.705
σ0.370
min53.565
max54.756
mean417.000
σ0.000
min417.000
max417.000
mean0.138
σ0.004
min0.136
max0.145
cache=y
dps=1
iters=10
policies=100
mean43.058
σ0.006
min43.050
max43.069
mean417.000
σ0.000
min417.000
max417.000
mean0.122
σ0.004
min0.118
max0.129

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
mean4284.875
σ1976.157
min1551.000
max7206.000
mean71.472
σ166.443
min12.300
max483.397
iterations=8
operation_display=column_set() on indexed, repeat
rows=200000
mean36.618
σ0.002
min36.616
max36.620
mean4284.875
σ1976.157
min1551.000
max7206.000
mean13.235
σ1.306
min11.851
max16.175
iterations=8
operation_display=table_records(), no indexes
rows=200000
mean41.930
σ0.002
min41.928
max41.932
mean7206.000
σ0.000
min7206.000
max7206.000
mean14.816
σ1.200
min12.178
max15.594
iterations=8
operation_display=table_records(), no indexes, repeat
rows=200000
mean41.929
σ0.002
min41.928
max41.932
mean7206.000
σ0.000
min7206.000
max7206.000
mean13.460
σ1.392
min11.717
max15.349
iterations=8
operation_display=table_records(), repeat
rows=200000
mean41.929
σ0.002
min41.927
max41.931
mean4168.125
σ1898.854
min1551.000
max7206.000
mean13.645
σ1.758
min11.195
max15.401
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records()
rows=200000
mean27.605
σ0.002
min27.603
max27.607
mean4168.125
σ1898.854
min1551.000
max7206.000
mean9.300
σ0.326
min8.896
max9.700
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.400
σ0.001
min26.399
max26.403
mean4168.125
σ1898.854
min1551.000
max7206.000
mean6.608
σ0.315
min6.067
max7.104
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.666
σ0.002
min25.664
max25.668
mean4284.875
σ1976.157
min1551.000
max7206.000
mean6.050
σ0.169
min5.704
max6.245
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.661
σ0.002
min25.659
max25.663
mean4284.875
σ1976.157
min1551.000
max7206.000
mean5.593
σ0.246
min5.228
max5.817
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.969
σ0.002
min25.967
max25.971
mean4284.875
σ1976.157
min1551.000
max7206.000
mean5.713
σ0.155
min5.497
max5.934
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.968
σ0.002
min25.967
max25.971
mean4284.875
σ1976.157
min1551.000
max7206.000
mean5.550
σ0.205
min5.141
max5.722

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
mean7206.000
σ0.000
min7206.000
max7206.000
mean1171.197
σ408.514
min1011.729
max2181.954
iterations=8
operation_display=load_product(), with indexes
rows=200000
mean8744.560
σ0.040
min8744.544
max8744.659
mean3590.375
σ1815.011
min1068.000
max5816.000
mean4724.038
σ1476.853
min3508.086
max7232.626

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=column_set() on unindexed, dense
rows=200000
mean62.077
σ0.001
min62.076
max62.080
mean4168.125
σ1898.854
min1551.000
max7206.000
mean79.376
σ9.404
min70.970
max100.844
iterations=8
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.078
σ0.002
min62.076
max62.080
mean4168.125
σ1898.854
min1551.000
max7206.000
mean80.809
σ9.393
min72.979
max102.274
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int
rows=200000
mean40.945
σ0.002
min40.943
max40.949
mean7206.000
σ0.000
min7206.000
max7206.000
mean101.391
σ8.969
min81.869
max106.765
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int, repeat
rows=200000
mean40.945
σ0.002
min40.944
max40.947
mean7206.000
σ0.000
min7206.000
max7206.000
mean101.149
σ8.960
min81.571
max106.904
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end
rows=200000
mean40.950
σ0.002
min40.949
max40.954
mean7206.000
σ0.000
min7206.000
max7206.000
mean103.927
σ9.054
min84.457
max110.762
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat
rows=200000
mean40.950
σ0.002
min40.949
max40.953
mean7206.000
σ0.000
min7206.000
max7206.000
mean101.570
σ9.267
min81.277
max107.569
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int
rows=200000
mean66.687
σ0.002
min66.686
max66.690
mean7206.000
σ0.000
min7206.000
max7206.000
mean234.420
σ217.722
min129.583
max772.297
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat
rows=200000
mean66.687
σ0.002
min66.685
max66.689
mean7206.000
σ0.000
min7206.000
max7206.000
mean154.499
σ15.550
min130.515
max166.363

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=table_records()
rows=200000
mean11656.833
σ4.319
min11655.305
max11667.523
mean4168.125
σ1898.854
min1551.000
max7206.000
mean6466.436
σ1309.953
min4831.442
max8239.276
iterations=8
operation_display=vertical_lookup_list() on indexed
rows=200000
mean11560.066
σ0.002
min11560.064
max11560.069
mean7206.000
σ0.000
min7206.000
max7206.000
mean5912.149
σ1565.197
min4364.633
max8589.285

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=pointedIndexFromKvs
rows=200000
mean172.666
σ0.008
min172.655
max172.679
mean489.250
σ0.707
min489.000
max491.000
mean392.450
σ18.842
min350.556
max411.510
iterations=8
operation_display=pointedIndexFromKvs
rows=400000
mean357.472
σ0.163
min357.321
max357.658
mean574.000
σ0.000
min574.000
max574.000
mean799.525
σ35.950
min744.990
max862.407

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1005.001
σ0.751
min1004.528
max1008.107
mean7206.000
σ0.000
min7206.000
max7206.000
mean1.583
σ0.123
min1.414
max1.846

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.317
σ0.118
min0.257
max0.527
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.819
σ0.122
min0.655
max0.992
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.542
σ0.052
min0.493
max0.627
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.847
σ0.042
min0.821
max0.921

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.551
σ0.024
min963.523
max963.581
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.743
σ0.037
min0.708
max0.801
name=cdr_enhanced_4k_loc.art
mean884.856
σ0.006
min884.848
max884.863
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.713
σ0.044
min0.635
max0.737

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.711
mean7206.000
σ0.000
min7206.000
max7206.000
mean4.209
σ0.097
min4.067
max4.648
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.659
mean7206.000
σ0.000
min7206.000
max7206.000
mean4.232
σ0.095
min4.074
max4.642
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.750
σ0.024
min0.584
max0.851
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.709
σ0.014
min0.678
max0.784

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean294.340
σ0.238
min294.122
max294.976
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.565
σ0.029
min0.507
max0.592

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean281.451
σ0.031
min281.402
max281.489
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.386
σ0.007
min0.380
max0.394
iters=5
new-facts=1
prior-facts=6402
mean1291.509
σ0.107
min1291.375
max1291.628
mean7206.000
σ0.000
min7206.000
max7206.000
mean1.917
σ0.073
min1.801
max2.000
iters=5
new-facts=6402
prior-facts=1
mean1534.350
σ3.974
min1532.329
max1541.453
mean7206.000
σ0.000
min7206.000
max7206.000
mean2.268
σ0.211
min2.104
max2.587
iters=5
new-facts=6402
prior-facts=6402
mean1853.324
σ0.056
min1853.241
max1853.368
mean7206.000
σ0.000
min7206.000
max7206.000
mean2.924
σ0.092
min2.845
max3.051

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.403
σ0.315
min1.123
max1.942

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean442.428
σ577.064
min153.892
max1308.024
mean96.250
σ8.500
min92.000
max109.000
mean7206.000
σ0.000
min7206.000
max7206.000
mean0.518
σ0.504
min0.265
max1.274
policies=20
mean1539.211
σ0.318
min1538.990
max1539.681
mean920.000
σ0.000
min920.000
max920.000
mean7206.000
σ0.000
min7206.000
max7206.000
mean2.592
σ0.028
min2.562
max2.623
policies=200
mean15400.391
σ0.109
min15400.277
max15400.511
mean9200.000
σ0.000
min9200.000
max9200.000
mean7206.000
σ0.000
min7206.000
max7206.000
mean26.284
σ0.124
min26.150
max26.415