16336718a397175161340a4a2734b7040e138ddf

Home / Branches / anniecasey/sol-1041-galileo-v11-implementation / 16336718a397175161340a4a2734b7040e138ddf

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.616
σ0.347
min54.485
max55.605
mean416.000
σ0.000
min416.000
max416.000
mean0.140
σ0.004
min0.133
max0.147
cache=y
dps=1
iters=10
policies=100
mean43.785
σ0.007
min43.779
max43.797
mean416.000
σ0.000
min416.000
max416.000
mean0.123
σ0.003
min0.120
max0.129

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4270.500
σ1876.747
min2002.000
max7554.000
mean13.147
σ1.803
min12.302
max17.548
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.615
max36.620
mean4270.500
σ1876.747
min2002.000
max7554.000
mean13.326
σ1.498
min11.595
max16.802
op=table_records(), no indexes
mean41.928
σ0.000
min41.928
max41.929
mean7554.000
σ0.000
min7554.000
max7554.000
mean13.799
σ1.093
min12.420
max15.164
op=table_records(), repeat
mean41.929
σ0.002
min41.927
max41.932
mean4270.500
σ1876.747
min2002.000
max7554.000
mean13.074
σ1.855
min10.571
max15.407
op=vertical_lookup_list() on indexed, after table_records()
mean27.604
σ0.002
min27.603
max27.607
mean4270.500
σ1876.747
min2002.000
max7554.000
mean9.161
σ1.342
min7.960
max11.887
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.399
max26.403
mean4270.500
σ1876.747
min2002.000
max7554.000
mean6.801
σ1.375
min5.328
max9.535
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.670
mean4270.500
σ1876.747
min2002.000
max7554.000
mean5.702
σ0.465
min5.371
max6.812
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.971
mean4270.500
σ1876.747
min2002.000
max7554.000
mean5.511
σ0.503
min5.094
max6.718

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.593
σ0.000
min2524.593
max2524.594
mean7554.000
σ0.000
min7554.000
max7554.000
mean1047.108
σ8.678
min1034.240
max1059.379
op=load_product(), with indexes
mean8744.558
σ0.034
min8744.544
max8744.641
mean3795.250
σ1603.527
min2002.000
max5951.000
mean4253.167
σ1163.018
min3537.880
max6953.453

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.077
σ0.002
min62.076
max62.080
mean4270.500
σ1876.747
min2002.000
max7554.000
mean86.779
σ12.606
min73.313
max107.723
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.943
max40.947
mean7554.000
σ0.000
min7554.000
max7554.000
mean243.818
σ400.644
min90.756
max1235.189
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.686
mean7554.000
σ0.000
min7554.000
max7554.000
mean153.285
σ14.782
min134.021
max171.084

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.317
min11655.305
max11667.517
mean4270.500
σ1876.747
min2002.000
max7554.000
mean6226.486
σ1044.895
min4930.634
max8289.860
op=vertical_lookup_list() on indexed
mean11560.068
σ0.001
min11560.066
max11560.069
mean7554.000
σ0.000
min7554.000
max7554.000
mean5470.064
σ1339.330
min4387.167
max7267.444

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.587
σ0.025
min172.558
max172.615
mean2002.000
σ0.000
min2002.000
max2002.000
mean356.774
σ57.042
min272.761
max465.087
op=pointedIndexFromKvs
rows=400000
mean357.367
σ0.034
min357.321
max357.400
mean2002.000
σ0.000
min2002.000
max2002.000
mean705.083
σ71.554
min611.397
max789.822

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.185
σ0.884
min1007.697
max1011.849
mean1051.100
σ298.420
min546.000
max1488.000
mean1.565
σ0.107
min1.475
max1.829

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean1488.000
σ0.000
min1488.000
max1488.000
mean0.412
σ0.126
min0.330
max0.632
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean1488.000
σ0.000
min1488.000
max1488.000
mean0.879
σ0.095
min0.808
max1.040
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean1488.000
σ0.000
min1488.000
max1488.000
mean0.543
σ0.047
min0.500
max0.622
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean1488.000
σ0.000
min1488.000
max1488.000
mean0.841
σ0.042
min0.805
max0.911

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.552
σ0.037
min963.528
max963.617
mean1488.000
σ0.000
min1488.000
max1488.000
mean0.810
σ0.040
min0.761
max0.859
name=cdr_enhanced_4k_loc.art
mean884.854
σ0.008
min884.847
max884.865
mean1488.000
σ0.000
min1488.000
max1488.000
mean0.700
σ0.043
min0.658
max0.752

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.710
mean1488.000
σ0.000
min1488.000
max1488.000
mean4.271
σ0.077
min4.171
max4.525
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean1488.000
σ0.000
min1488.000
max1488.000
mean4.251
σ0.099
min4.047
max4.667
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean1488.000
σ0.000
min1488.000
max1488.000
mean0.752
σ0.017
min0.716
max0.861
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean1488.000
σ0.000
min1488.000
max1488.000
mean0.708
σ0.033
min0.515
max0.773

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.358
σ0.226
min297.238
max297.994
mean2002.000
σ0.000
min2002.000
max2002.000
mean0.561
σ0.034
min0.511
max0.602

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.766
σ0.042
min289.722
max289.812
mean1488.000
σ0.000
min1488.000
max1488.000
mean0.403
σ0.012
min0.397
max0.424
iters=5
new-facts=1
prior-facts=6402
mean1299.674
σ0.091
min1299.543
max1299.783
mean1488.000
σ0.000
min1488.000
max1488.000
mean2.167
σ0.051
min2.097
max2.227
iters=5
new-facts=6402
prior-facts=1
mean1542.681
σ3.996
min1540.723
max1549.825
mean1488.000
σ0.000
min1488.000
max1488.000
mean2.401
σ0.198
min2.134
max2.677
iters=5
new-facts=6402
prior-facts=6402
mean1861.638
σ0.055
min1861.579
max1861.717
mean1719.400
σ194.404
min1546.000
max2002.000
mean2.913
σ0.139
min2.729
max3.105

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.606
σ0.153
min1.421
max1.779

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.184
σ577.140
min157.613
max1311.894
mean96.250
σ8.500
min92.000
max109.000
mean1488.000
σ0.000
min1488.000
max1488.000
mean0.536
σ0.547
min0.262
max1.357
policies=20
mean1576.399
σ0.334
min1576.173
max1576.896
mean920.000
σ0.000
min920.000
max920.000
mean1488.000
σ0.000
min1488.000
max1488.000
mean2.611
σ0.006
min2.605
max2.616
policies=200
mean15772.292
σ0.136
min15772.124
max15772.456
mean9200.000
σ0.000
min9200.000
max9200.000
mean1488.000
σ0.000
min1488.000
max1488.000
mean26.498
σ0.067
min26.419
max26.571