3e4ae9dc08942b4dce74b096e04f082c8a8a575c

Home / Branches / gosha/exp-1520-configure-a-customer-specific-display_name-for-each / 3e4ae9dc08942b4dce74b096e04f082c8a8a575c

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean53.703
σ0.368
min53.558
max54.748
mean416.000
σ0.000
min416.000
max416.000
mean0.135
σ0.004
min0.130
max0.141
cache=y
dps=1
iters=10
policies=100
mean43.057
σ0.007
min43.049
max43.068
mean416.000
σ0.000
min416.000
max416.000
mean0.120
σ0.005
min0.114
max0.127

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.620
mean4286.125
σ1981.080
min1551.000
max7214.000
mean104.592
σ259.419
min12.517
max746.621
iterations=8
operation_display=column_set() on indexed, repeat
rows=200000
mean36.618
σ0.002
min36.616
max36.620
mean4286.125
σ1981.080
min1551.000
max7214.000
mean13.890
σ3.030
min11.900
max21.208
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
mean15.067
σ0.666
min14.034
max15.844
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.488
σ1.200
min11.741
max14.429
iterations=8
operation_display=table_records(), repeat
rows=200000
mean41.928
σ0.002
min41.927
max41.932
mean4169.375
σ1903.574
min1551.000
max7214.000
mean13.623
σ1.769
min11.030
max15.233
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records()
rows=200000
mean27.604
σ0.002
min27.603
max27.607
mean4169.375
σ1903.574
min1551.000
max7214.000
mean8.829
σ0.318
min8.294
max9.190
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.400
σ0.002
min26.399
max26.403
mean4169.375
σ1903.574
min1551.000
max7214.000
mean6.927
σ0.192
min6.549
max7.171
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.666
σ0.002
min25.664
max25.668
mean4286.125
σ1981.080
min1551.000
max7214.000
mean6.295
σ0.846
min5.731
max8.354
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.661
σ0.002
min25.659
max25.663
mean4286.125
σ1981.080
min1551.000
max7214.000
mean5.808
σ0.645
min5.462
max7.398
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.968
σ0.002
min25.967
max25.971
mean4286.125
σ1981.080
min1551.000
max7214.000
mean5.916
σ0.625
min5.631
max7.453
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.968
σ0.001
min25.967
max25.971
mean4286.125
σ1981.080
min1551.000
max7214.000
mean5.823
σ0.582
min5.497
max7.240

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.598
mean7214.000
σ0.000
min7214.000
max7214.000
mean1477.462
σ684.850
min1042.843
max2742.302
iterations=8
operation_display=load_product(), with indexes
rows=200000
mean8744.561
σ0.041
min8744.545
max8744.661
mean3591.500
σ1817.388
min1075.000
max5823.000
mean5092.815
σ1677.262
min3539.175
max7050.383

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
mean4169.375
σ1903.574
min1551.000
max7214.000
mean77.019
σ5.976
min71.599
max90.655
iterations=8
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.078
σ0.002
min62.076
max62.080
mean4169.375
σ1903.574
min1551.000
max7214.000
mean77.350
σ5.984
min71.399
max90.720
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int
rows=200000
mean40.945
σ0.002
min40.943
max40.947
mean7214.000
σ0.000
min7214.000
max7214.000
mean103.931
σ7.285
min89.791
max109.534
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int, repeat
rows=200000
mean40.945
σ0.002
min40.943
max40.947
mean7214.000
σ0.000
min7214.000
max7214.000
mean103.631
σ7.571
min88.699
max109.550
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
mean106.981
σ5.737
min96.446
max113.196
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat
rows=200000
mean40.950
σ0.002
min40.948
max40.952
mean7214.000
σ0.000
min7214.000
max7214.000
mean103.846
σ7.372
min89.402
max109.495
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
mean222.168
σ178.464
min138.376
max663.024
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat
rows=200000
mean66.686
σ0.002
min66.685
max66.689
mean7214.000
σ0.000
min7214.000
max7214.000
mean155.231
σ16.532
min125.376
max169.571

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=table_records()
rows=200000
mean11656.833
σ4.318
min11655.305
max11667.520
mean4169.375
σ1903.574
min1551.000
max7214.000
mean6717.022
σ1266.103
min4928.154
max8154.385
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
mean6058.535
σ1445.943
min4390.465
max7746.550

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=pointedIndexFromKvs
rows=200000
mean172.667
σ0.010
min172.651
max172.679
mean488.000
σ0.000
min488.000
max488.000
mean399.596
σ24.032
min357.133
max424.382
iterations=8
operation_display=pointedIndexFromKvs
rows=400000
mean357.461
σ0.158
min357.321
max357.668
mean563.375
σ3.021
min558.000
max565.000
mean810.540
σ30.830
min778.282
max872.680

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1005.002
σ0.750
min1004.531
max1008.103
mean7214.000
σ0.000
min7214.000
max7214.000
mean1.642
σ0.130
min1.449
max1.954

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.447
σ0.179
min0.344
max0.766
name=error_case.art
mean2.334
σ0.004
min2.332
max2.340
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.927
σ0.186
min0.826
max1.258
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.537
σ0.039
min0.507
max0.597
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.842
σ0.036
min0.799
max0.897

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.552
σ0.023
min963.527
max963.582
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.801
σ0.046
min0.728
max0.849
name=cdr_enhanced_4k_loc.art
mean884.856
σ0.006
min884.847
max884.862
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.683
σ0.052
min0.624
max0.750

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.290
σ0.068
min4.144
max4.615
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.659
mean7214.000
σ0.000
min7214.000
max7214.000
mean4.299
σ0.081
min4.147
max4.563
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.699
σ0.100
min0.524
max0.887
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.520
σ0.014
min0.497
max0.581

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean294.336
σ0.226
min294.098
max294.891
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.537
σ0.026
min0.501
max0.573

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean281.449
σ0.034
min281.404
max281.496
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.386
σ0.008
min0.378
max0.396
iters=5
new-facts=1
prior-facts=6402
mean1291.502
σ0.102
min1291.375
max1291.617
mean7214.000
σ0.000
min7214.000
max7214.000
mean1.930
σ0.109
min1.790
max2.080
iters=5
new-facts=6402
prior-facts=1
mean1534.374
σ4.025
min1532.314
max1541.564
mean7214.000
σ0.000
min7214.000
max7214.000
mean2.362
σ0.231
min2.021
max2.596
iters=5
new-facts=6402
prior-facts=6402
mean1853.318
σ0.055
min1853.241
max1853.372
mean7214.000
σ0.000
min7214.000
max7214.000
mean2.919
σ0.127
min2.780
max3.108

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.396
σ0.145
min1.283
max1.635

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean442.429
σ577.063
min153.895
max1308.024
mean96.250
σ8.500
min92.000
max109.000
mean7214.000
σ0.000
min7214.000
max7214.000
mean0.541
σ0.556
min0.259
max1.375
policies=20
mean1539.216
σ0.327
min1538.991
max1539.701
mean920.000
σ0.000
min920.000
max920.000
mean7214.000
σ0.000
min7214.000
max7214.000
mean2.594
σ0.018
min2.572
max2.614
policies=200
mean15400.436
σ0.116
min15400.305
max15400.584
mean9200.000
σ0.000
min9200.000
max9200.000
mean7214.000
σ0.000
min7214.000
max7214.000
mean26.167
σ0.069
min26.073
max26.236