f931517cd8e19d89b7ee89fc671a126837bc39cd

Home / Branches / anniecasey/sol-1041-galileo-v11-implementation / f931517cd8e19d89b7ee89fc671a126837bc39cd

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.618
σ0.351
min54.486
max55.615
mean416.000
σ0.000
min416.000
max416.000
mean0.140
σ0.004
min0.136
max0.147
cache=y
dps=1
iters=10
policies=100
mean43.785
σ0.008
min43.775
max43.802
mean416.000
σ0.000
min416.000
max416.000
mean0.120
σ0.004
min0.115
max0.126

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4117.375
σ1556.138
min2053.000
max6047.000
mean12.561
σ0.296
min12.161
max13.065
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.620
mean4117.375
σ1556.138
min2053.000
max6047.000
mean12.957
σ0.171
min12.712
max13.269
op=table_records(), no indexes
mean41.928
σ0.000
min41.928
max41.929
mean6047.000
σ0.000
min6047.000
max6047.000
mean12.991
σ1.236
min10.398
max14.359
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4117.375
σ1556.138
min2053.000
max6047.000
mean12.564
σ1.941
min10.457
max15.197
op=vertical_lookup_list() on indexed, after table_records()
mean27.605
σ0.002
min27.603
max27.607
mean4117.375
σ1556.138
min2053.000
max6047.000
mean8.326
σ0.281
min7.819
max8.733
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4117.375
σ1556.138
min2053.000
max6047.000
mean6.321
σ0.260
min5.887
max6.619
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.668
mean4117.375
σ1556.138
min2053.000
max6047.000
mean5.511
σ0.143
min5.287
max5.700
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.971
mean4117.375
σ1556.138
min2053.000
max6047.000
mean5.272
σ0.107
min5.150
max5.480

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.594
σ0.000
min2524.593
max2524.594
mean6047.000
σ0.000
min6047.000
max6047.000
mean1542.583
σ786.045
min1048.007
max2955.877
op=load_product(), with indexes
mean8744.558
σ0.033
min8744.544
max8744.641
mean3844.000
σ1626.846
min2053.000
max6047.000
mean4724.825
σ1614.557
min3562.028
max7602.944

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.080
mean4117.375
σ1556.138
min2053.000
max6047.000
mean81.706
σ12.030
min71.118
max103.373
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.002
min40.944
max40.949
mean6047.000
σ0.000
min6047.000
max6047.000
mean97.135
σ8.667
min84.692
max108.706
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.689
σ0.000
min66.689
max66.690
mean6047.000
σ0.000
min6047.000
max6047.000
mean224.330
σ225.318
min127.569
max781.103

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.317
min11655.305
max11667.517
mean4117.375
σ1556.138
min2053.000
max6047.000
mean6108.183
σ1219.141
min4978.549
max8325.013
op=vertical_lookup_list() on indexed
mean11560.065
σ0.001
min11560.065
max11560.068
mean6047.000
σ0.000
min6047.000
max6047.000
mean6530.101
σ1157.163
min4429.586
max7705.707

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.588
σ0.027
min172.558
max172.625
mean2053.000
σ0.000
min2053.000
max2053.000
mean367.360
σ48.206
min323.582
max449.404
op=pointedIndexFromKvs
rows=400000
mean357.368
σ0.045
min357.321
max357.420
mean2053.000
σ0.000
min2053.000
max2053.000
mean771.639
σ24.143
min737.709
max797.471

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.185
σ0.883
min1007.698
max1011.847
mean1052.450
σ303.700
min547.000
max1460.000
mean1.556
σ0.086
min1.484
max1.766

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean1460.000
σ0.000
min1460.000
max1460.000
mean0.415
σ0.129
min0.339
max0.645
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean1460.000
σ0.000
min1460.000
max1460.000
mean0.881
σ0.091
min0.806
max1.035
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean1460.000
σ0.000
min1460.000
max1460.000
mean0.545
σ0.043
min0.504
max0.616
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean1460.000
σ0.000
min1460.000
max1460.000
mean0.846
σ0.039
min0.813
max0.912

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.543
σ0.025
min963.523
max963.584
mean1460.000
σ0.000
min1460.000
max1460.000
mean0.826
σ0.035
min0.781
max0.863
name=cdr_enhanced_4k_loc.art
mean884.854
σ0.006
min884.847
max884.861
mean1460.000
σ0.000
min1460.000
max1460.000
mean0.706
σ0.038
min0.667
max0.747

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean1460.000
σ0.000
min1460.000
max1460.000
mean4.304
σ0.089
min4.169
max4.599
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean1460.000
σ0.000
min1460.000
max1460.000
mean4.289
σ0.083
min4.172
max4.580
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean1460.000
σ0.000
min1460.000
max1460.000
mean0.756
σ0.018
min0.727
max0.875
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean1460.000
σ0.000
min1460.000
max1460.000
mean0.718
σ0.015
min0.684
max0.787

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.526
σ0.237
min297.384
max298.179
mean2053.000
σ0.000
min2053.000
max2053.000
mean0.569
σ0.036
min0.509
max0.610

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.759
σ0.056
min289.691
max289.819
mean1460.000
σ0.000
min1460.000
max1460.000
mean0.408
σ0.011
min0.395
max0.418
iters=5
new-facts=1
prior-facts=6402
mean1299.688
σ0.106
min1299.539
max1299.826
mean1460.000
σ0.000
min1460.000
max1460.000
mean2.231
σ0.086
min2.131
max2.361
iters=5
new-facts=6402
prior-facts=1
mean1542.704
σ4.024
min1540.747
max1549.899
mean1460.000
σ0.000
min1460.000
max1460.000
mean2.423
σ0.221
min2.143
max2.668
iters=5
new-facts=6402
prior-facts=6402
mean1861.630
σ0.060
min1861.546
max1861.697
mean1728.800
σ235.218
min1468.000
max2053.000
mean2.928
σ0.072
min2.850
max3.007

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.741
σ0.103
min1.602
max1.856

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.185
σ577.140
min157.614
max1311.895
mean96.250
σ8.500
min92.000
max109.000
mean1460.000
σ0.000
min1460.000
max1460.000
mean0.541
σ0.554
min0.262
max1.372
policies=20
mean1576.418
σ0.341
min1576.185
max1576.925
mean920.000
σ0.000
min920.000
max920.000
mean1460.000
σ0.000
min1460.000
max1460.000
mean2.606
σ0.012
min2.588
max2.616
policies=200
mean15772.225
σ0.120
min15772.110
max15772.340
mean9200.000
σ0.000
min9200.000
max9200.000
mean1460.000
σ0.000
min1460.000
max1460.000
mean26.558
σ0.093
min26.456
max26.674