4e9cc436d839d85ae243f89c16862b7056162bd3

Home / Branches / anniecasey/sol-1041-galileo-v11-implementation / 4e9cc436d839d85ae243f89c16862b7056162bd3

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.616
σ0.351
min54.481
max55.615
mean412.000
σ0.000
min412.000
max412.000
mean0.137
σ0.007
min0.131
max0.148
cache=y
dps=1
iters=10
policies=100
mean43.786
σ0.005
min43.778
max43.795
mean412.000
σ0.000
min412.000
max412.000
mean0.121
σ0.005
min0.115
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
mean4285.000
σ1982.059
min1549.000
max7208.000
mean103.650
σ257.057
min12.532
max739.832
iterations=8
operation_display=column_set() on indexed, repeat
rows=200000
mean36.617
σ0.002
min36.616
max36.619
mean4285.000
σ1982.059
min1549.000
max7208.000
mean14.207
σ3.049
min12.158
max21.680
iterations=8
operation_display=table_records(), no indexes
rows=200000
mean41.930
σ0.002
min41.928
max41.932
mean7208.000
σ0.000
min7208.000
max7208.000
mean14.874
σ0.929
min13.022
max15.467
iterations=8
operation_display=table_records(), no indexes, repeat
rows=200000
mean41.930
σ0.002
min41.928
max41.932
mean7208.000
σ0.000
min7208.000
max7208.000
mean13.557
σ1.475
min12.117
max15.626
iterations=8
operation_display=table_records(), repeat
rows=200000
mean41.929
σ0.002
min41.927
max41.932
mean4168.750
σ1904.522
min1549.000
max7208.000
mean13.607
σ1.687
min11.094
max15.172
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records()
rows=200000
mean27.605
σ0.002
min27.603
max27.607
mean4168.750
σ1904.522
min1549.000
max7208.000
mean9.207
σ0.434
min8.772
max9.739
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.401
σ0.002
min26.399
max26.403
mean4168.750
σ1904.522
min1549.000
max7208.000
mean6.590
σ0.330
min5.933
max6.927
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.666
σ0.002
min25.664
max25.670
mean4285.000
σ1982.059
min1549.000
max7208.000
mean6.268
σ0.657
min5.793
max7.862
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.661
σ0.002
min25.659
max25.663
mean4285.000
σ1982.059
min1549.000
max7208.000
mean5.740
σ0.696
min5.097
max7.333
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.970
σ0.002
min25.967
max25.972
mean4285.000
σ1982.059
min1549.000
max7208.000
mean5.796
σ0.702
min5.319
max7.488
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.968
σ0.002
min25.967
max25.971
mean4285.000
σ1982.059
min1549.000
max7208.000
mean5.681
σ0.694
min5.122
max7.323

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
mean7208.000
σ0.000
min7208.000
max7208.000
mean1349.135
σ460.339
min1034.231
max2183.596
iterations=8
operation_display=load_product(), with indexes
rows=200000
mean8744.560
σ0.040
min8744.545
max8744.660
mean3590.250
σ1820.787
min1068.000
max5826.000
mean4783.252
σ1616.506
min3512.005
max7058.220

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
mean4168.750
σ1904.522
min1549.000
max7208.000
mean81.111
σ9.806
min71.868
max100.623
iterations=8
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.077
σ0.002
min62.076
max62.080
mean4168.750
σ1904.522
min1549.000
max7208.000
mean81.524
σ9.506
min72.004
max98.766
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int
rows=200000
mean40.945
σ0.002
min40.943
max40.947
mean7208.000
σ0.000
min7208.000
max7208.000
mean103.675
σ6.956
min89.729
max108.269
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int, repeat
rows=200000
mean40.945
σ0.002
min40.944
max40.948
mean7208.000
σ0.000
min7208.000
max7208.000
mean103.584
σ6.997
min89.258
max108.128
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end
rows=200000
mean40.951
σ0.002
min40.949
max40.953
mean7208.000
σ0.000
min7208.000
max7208.000
mean105.455
σ7.392
min92.100
max112.716
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat
rows=200000
mean40.950
σ0.002
min40.949
max40.954
mean7208.000
σ0.000
min7208.000
max7208.000
mean103.853
σ7.148
min89.490
max108.592
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int
rows=200000
mean66.686
σ0.001
min66.686
max66.689
mean7208.000
σ0.000
min7208.000
max7208.000
mean229.247
σ196.457
min141.095
max714.874
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat
rows=200000
mean66.687
σ0.002
min66.685
max66.690
mean7208.000
σ0.000
min7208.000
max7208.000
mean155.847
σ14.548
min128.312
max167.041

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=table_records()
rows=200000
mean11656.833
σ4.318
min11655.305
max11667.520
mean4168.750
σ1904.522
min1549.000
max7208.000
mean6715.784
σ1276.509
min4889.397
max8043.558
iterations=8
operation_display=vertical_lookup_list() on indexed
rows=200000
mean11560.066
σ0.002
min11560.064
max11560.069
mean7208.000
σ0.000
min7208.000
max7208.000
mean5532.651
σ1287.370
min4358.810
max7780.410

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=pointedIndexFromKvs
rows=200000
mean172.664
σ0.009
min172.644
max172.671
mean485.000
σ0.000
min485.000
max485.000
mean398.145
σ18.812
min366.808
max418.444
iterations=8
operation_display=pointedIndexFromKvs
rows=400000
mean357.462
σ0.150
min357.321
max357.634
mean561.000
σ0.000
min561.000
max561.000
mean766.032
σ71.356
min623.944
max809.927

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.084
σ0.761
min1007.611
max1011.229
mean7208.000
σ0.000
min7208.000
max7208.000
mean1.513
σ0.122
min1.392
max1.800

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.417
σ0.119
min0.347
max0.628
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.887
σ0.103
min0.806
max1.062
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.547
σ0.073
min0.488
max0.660
name=nested_use.art
mean2.356
σ0.002
min2.355
max2.358
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.826
σ0.044
min0.789
max0.895

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.549
σ0.033
min963.523
max963.605
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.745
σ0.073
min0.641
max0.806
name=cdr_enhanced_4k_loc.art
mean884.856
σ0.007
min884.847
max884.863
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.700
σ0.057
min0.606
max0.749

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean7208.000
σ0.000
min7208.000
max7208.000
mean4.280
σ0.094
min4.146
max4.862
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.661
mean7208.000
σ0.000
min7208.000
max7208.000
mean4.272
σ0.070
min4.148
max4.521
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.756
σ0.024
min0.712
max0.892
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.708
σ0.017
min0.669
max0.807

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.539
σ0.221
min297.384
max298.128
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.552
σ0.043
min0.498
max0.610

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.725
σ0.032
min289.683
max289.769
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.390
σ0.001
min0.389
max0.391
iters=5
new-facts=1
prior-facts=6402
mean1299.648
σ0.113
min1299.503
max1299.773
mean7208.000
σ0.000
min7208.000
max7208.000
mean1.865
σ0.053
min1.821
max1.943
iters=5
new-facts=6402
prior-facts=1
mean1542.643
σ4.032
min1540.614
max1549.848
mean7208.000
σ0.000
min7208.000
max7208.000
mean2.364
σ0.200
min2.115
max2.607
iters=5
new-facts=6402
prior-facts=6402
mean1861.613
σ0.087
min1861.499
max1861.723
mean7208.000
σ0.000
min7208.000
max7208.000
mean2.851
σ0.025
min2.812
max2.875

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.469
σ0.237
min1.205
max1.748

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.149
σ577.063
min157.616
max1311.744
mean96.250
σ8.500
min92.000
max109.000
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.551
σ0.565
min0.267
max1.398
policies=20
mean1576.428
σ0.355
min1576.188
max1576.955
mean920.000
σ0.000
min920.000
max920.000
mean7208.000
σ0.000
min7208.000
max7208.000
mean2.642
σ0.037
min2.603
max2.690
policies=200
mean15772.307
σ0.079
min15772.230
max15772.416
mean9200.000
σ0.000
min9200.000
max9200.000
mean7208.000
σ0.000
min7208.000
max7208.000
mean26.635
σ0.132
min26.459
max26.763