c00af13ec8b1fefa58e5fd7c21644517ca4962e8

Home / Branches / federicoroffi/exp-1577-convert-e2e-tests-e2etesttemplated_email_composerts-to / c00af13ec8b1fefa58e5fd7c21644517ca4962e8

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.522
σ0.370
min54.378
max55.574
mean416.000
σ0.000
min416.000
max416.000
mean0.140
σ0.005
min0.136
max0.148
cache=y
dps=1
iters=10
policies=100
mean43.766
σ0.007
min43.756
max43.777
mean416.000
σ0.000
min416.000
max416.000
mean0.122
σ0.004
min0.116
max0.128

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.619
mean4169.500
σ1899.312
min1550.000
max7203.000
mean12.595
σ0.313
min12.189
max13.226
iterations=8
operation_display=column_set() on indexed, repeat
rows=200000
mean36.617
σ0.002
min36.616
max36.619
mean4289.625
σ1979.093
min1550.000
max7203.000
mean95.012
σ234.488
min11.483
max675.338
iterations=8
operation_display=table_records(), no indexes
rows=200000
mean41.930
σ0.002
min41.928
max41.932
mean7203.000
σ0.000
min7203.000
max7203.000
mean14.820
σ1.238
min12.029
max15.540
iterations=8
operation_display=table_records(), no indexes, repeat
rows=200000
mean41.930
σ0.002
min41.928
max41.932
mean7203.000
σ0.000
min7203.000
max7203.000
mean12.916
σ1.374
min11.176
max15.088
iterations=8
operation_display=table_records(), repeat
rows=200000
mean41.929
σ0.002
min41.927
max41.932
mean4169.500
σ1899.312
min1550.000
max7203.000
mean13.503
σ1.715
min10.992
max15.244
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records()
rows=200000
mean27.605
σ0.002
min27.603
max27.607
mean4169.500
σ1899.312
min1550.000
max7203.000
mean9.127
σ0.361
min8.720
max9.744
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.401
σ0.002
min26.399
max26.403
mean4169.500
σ1899.312
min1550.000
max7203.000
mean6.585
σ0.361
min6.132
max7.265
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.666
σ0.002
min25.664
max25.670
mean4289.625
σ1979.093
min1550.000
max7203.000
mean6.099
σ0.679
min5.598
max7.703
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.661
σ0.002
min25.659
max25.663
mean4289.625
σ1979.093
min1550.000
max7203.000
mean5.754
σ0.711
min5.154
max7.471
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.969
σ0.002
min25.967
max25.972
mean4289.625
σ1979.093
min1550.000
max7203.000
mean5.788
σ0.637
min5.247
max7.312
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.968
σ0.002
min25.967
max25.971
mean4289.625
σ1979.093
min1550.000
max7203.000
mean5.754
σ0.649
min5.311
max7.344

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
mean7203.000
σ0.000
min7203.000
max7203.000
mean1186.791
σ386.677
min1043.294
max2143.729
iterations=8
operation_display=load_product(), with indexes
rows=200000
mean8744.560
σ0.040
min8744.545
max8744.660
mean3596.750
σ1818.874
min1075.000
max5837.000
mean5001.306
σ1581.008
min3537.721
max7104.074

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.500
σ1899.312
min1550.000
max7203.000
mean83.720
σ10.075
min75.037
max104.081
iterations=8
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.077
σ0.002
min62.076
max62.080
mean4169.500
σ1899.312
min1550.000
max7203.000
mean84.658
σ9.986
min75.265
max104.674
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int
rows=200000
mean40.945
σ0.002
min40.943
max40.947
mean7203.000
σ0.000
min7203.000
max7203.000
mean100.741
σ12.439
min73.621
max108.046
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int, repeat
rows=200000
mean40.945
σ0.002
min40.943
max40.948
mean7203.000
σ0.000
min7203.000
max7203.000
mean100.848
σ12.675
min73.184
max108.641
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end
rows=200000
mean40.951
σ0.002
min40.948
max40.953
mean7203.000
σ0.000
min7203.000
max7203.000
mean104.104
σ10.462
min81.535
max112.764
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat
rows=200000
mean40.950
σ0.002
min40.948
max40.954
mean7203.000
σ0.000
min7203.000
max7203.000
mean101.159
σ12.358
min74.300
max108.680
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int
rows=200000
mean66.687
σ0.002
min66.686
max66.690
mean7203.000
σ0.000
min7203.000
max7203.000
mean205.856
σ145.930
min117.858
max564.526
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat
rows=200000
mean66.687
σ0.002
min66.685
max66.689
mean7203.000
σ0.000
min7203.000
max7203.000
mean149.435
σ23.319
min110.168
max168.021

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=table_records()
rows=200000
mean11656.833
σ4.318
min11655.305
max11667.520
mean4169.500
σ1899.312
min1550.000
max7203.000
mean6618.182
σ1171.136
min4856.904
max7706.888
iterations=8
operation_display=vertical_lookup_list() on indexed
rows=200000
mean11560.065
σ0.001
min11560.064
max11560.068
mean7203.000
σ0.000
min7203.000
max7203.000
mean6113.546
σ1628.342
min4400.715
max8745.435

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=pointedIndexFromKvs
rows=200000
mean172.665
σ0.011
min172.646
max172.677
mean487.250
σ0.707
min487.000
max489.000
mean392.917
σ18.687
min358.928
max412.896
iterations=8
operation_display=pointedIndexFromKvs
rows=400000
mean357.467
σ0.156
min357.321
max357.628
mean573.000
σ0.000
min573.000
max573.000
mean786.083
σ47.429
min703.068
max860.078

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.081
σ0.761
min1007.604
max1011.227
mean7203.000
σ0.000
min7203.000
max7203.000
mean1.513
σ0.132
min1.382
max1.843

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.884
σ0.002
min0.881
max0.886
mean7203.000
σ0.000
min7203.000
max7203.000
mean0.413
σ0.130
min0.330
max0.641
name=error_case.art
mean2.334
σ0.003
min2.332
max2.339
mean7203.000
σ0.000
min7203.000
max7203.000
mean0.891
σ0.088
min0.833
max1.044
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean7203.000
σ0.000
min7203.000
max7203.000
mean0.545
σ0.048
min0.511
max0.629
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean7203.000
σ0.000
min7203.000
max7203.000
mean0.849
σ0.042
min0.796
max0.910

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.551
σ0.027
min963.535
max963.598
mean7203.000
σ0.000
min7203.000
max7203.000
mean0.811
σ0.051
min0.725
max0.845
name=cdr_enhanced_4k_loc.art
mean884.854
σ0.007
min884.847
max884.862
mean7203.000
σ0.000
min7203.000
max7203.000
mean0.683
σ0.071
min0.568
max0.738

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.711
mean7203.000
σ0.000
min7203.000
max7203.000
mean3.521
σ0.086
min3.368
max3.797
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.659
mean7203.000
σ0.000
min7203.000
max7203.000
mean3.929
σ0.387
min3.385
max4.515
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean7203.000
σ0.000
min7203.000
max7203.000
mean0.753
σ0.019
min0.716
max0.864
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean7203.000
σ0.000
min7203.000
max7203.000
mean0.714
σ0.021
min0.615
max0.793

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.331
σ0.246
min297.184
max298.019
mean7203.000
σ0.000
min7203.000
max7203.000
mean0.570
σ0.028
min0.517
max0.594

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.730
σ0.040
min289.682
max289.792
mean7203.000
σ0.000
min7203.000
max7203.000
mean0.406
σ0.020
min0.386
max0.432
iters=5
new-facts=1
prior-facts=6402
mean1299.640
σ0.091
min1299.534
max1299.742
mean7203.000
σ0.000
min7203.000
max7203.000
mean1.934
σ0.083
min1.791
max2.001
iters=5
new-facts=6402
prior-facts=1
mean1542.624
σ4.086
min1540.578
max1549.926
mean7203.000
σ0.000
min7203.000
max7203.000
mean2.280
σ0.244
min2.055
max2.667
iters=5
new-facts=6402
prior-facts=6402
mean1861.597
σ0.057
min1861.512
max1861.648
mean7203.000
σ0.000
min7203.000
max7203.000
mean2.919
σ0.094
min2.813
max3.052

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.497
σ0.315
min1.007
max1.807

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.146
σ577.064
min157.612
max1311.743
mean96.250
σ8.500
min92.000
max109.000
mean7203.000
σ0.000
min7203.000
max7203.000
mean0.554
σ0.572
min0.267
max1.412
policies=20
mean1576.398
σ0.350
min1576.162
max1576.918
mean920.000
σ0.000
min920.000
max920.000
mean7203.000
σ0.000
min7203.000
max7203.000
mean2.638
σ0.017
min2.616
max2.652
policies=200
mean15771.972
σ0.056
min15771.893
max15772.019
mean9200.000
σ0.000
min9200.000
max9200.000
mean7203.000
σ0.000
min7203.000
max7203.000
mean26.507
σ0.240
min26.353
max26.864