Compare commits

Home / Compare 9cc3efca .. fb013fc1

grey: no significant change wrt stddev
red: change exceeding max stddev
purple: some change, not seemingly significant

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.618
σ0.352
min54.480
max55.618
mean417.000
σ0.000
min417.000
max417.000
mean0.138
σ0.004
min0.131
max0.145
cache=y
dps=1
iters=10
policies=100
mean43.785
σ0.007
min43.773
max43.798
mean417.000
σ0.000
min417.000
max417.000
mean0.122
σ0.005
min0.117
max0.130

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4290.625
σ1877.362
min2074.000
max7587.000
mean12.346
σ0.222
min12.082
max12.721
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.620
mean4290.625
σ1877.362
min2074.000
max7587.000
mean12.662
σ0.564
min11.712
max13.219
op=table_records(), no indexes
mean41.928
σ0.000
min41.928
max41.929
mean7587.000
σ0.000
min7587.000
max7587.000
mean14.122
σ1.197
min12.508
max15.346
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4089.125
σ1526.791
min2074.000
max5975.000
mean12.709
σ1.854
min10.897
max14.927
op=vertical_lookup_list() on indexed, after table_records()
mean27.605
σ0.002
min27.603
max27.607
mean4089.125
σ1526.791
min2074.000
max5975.000
mean8.716
σ0.538
min8.127
max9.503
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4089.125
σ1526.791
min2074.000
max5975.000
mean6.219
σ0.313
min5.667
max6.628
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.670
mean4290.625
σ1877.362
min2074.000
max7587.000
mean5.609
σ0.129
min5.442
max5.855
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.971
mean4290.625
σ1877.362
min2074.000
max7587.000
mean5.329
σ0.181
min5.012
max5.551

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.594
σ0.001
min2524.593
max2524.597
mean7587.000
σ0.000
min7587.000
max7587.000
mean1110.994
σ164.173
min1045.799
max1517.060
op=load_product(), with indexes
mean8744.559
σ0.033
min8744.545
max8744.640
mean3820.500
σ1591.957
min2074.000
max5975.000
mean4540.059
σ1348.664
min3542.116
max6691.875

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.079
σ0.002
min62.076
max62.080
mean4290.625
σ1877.362
min2074.000
max7587.000
mean135.648
σ151.212
min72.146
max508.799
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean7587.000
σ0.000
min7587.000
max7587.000
mean101.037
σ8.776
min88.570
max109.016
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean7587.000
σ0.000
min7587.000
max7587.000
mean311.908
σ448.678
min137.063
max1421.888

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.318
min11655.305
max11667.521
mean4089.125
σ1526.791
min2074.000
max5975.000
mean6427.067
σ1307.636
min4914.429
max8172.389
op=vertical_lookup_list() on indexed
mean11560.068
σ0.001
min11560.066
max11560.069
mean7587.000
σ0.000
min7587.000
max7587.000
mean5280.325
σ1169.728
min4366.582
max7201.752

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.582
σ0.021
min172.558
max172.613
mean2074.000
σ0.000
min2074.000
max2074.000
mean352.317
σ60.729
min263.430
max447.250
op=pointedIndexFromKvs
rows=400000
mean357.366
σ0.045
min357.321
max357.420
mean2074.000
σ0.000
min2074.000
max2074.000
mean783.911
σ15.354
min769.858
max813.767

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.187
σ0.875
min1007.687
max1011.805
mean1049.350
σ301.377
min547.000
max1452.000
mean1.545
σ0.076
min1.479
max1.759

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean1452.000
σ0.000
min1452.000
max1452.000
mean0.397
σ0.111
min0.326
max0.593
name=error_case.art
mean2.333
σ0.004
min2.332
max2.341
mean1452.000
σ0.000
min1452.000
max1452.000
mean0.880
σ0.083
min0.823
max1.025
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean1452.000
σ0.000
min1452.000
max1452.000
mean0.546
σ0.049
min0.501
max0.628
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.359
mean1452.000
σ0.000
min1452.000
max1452.000
mean0.850
σ0.032
min0.824
max0.902

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.544
σ0.025
min963.523
max963.585
mean1452.000
σ0.000
min1452.000
max1452.000
mean0.800
σ0.077
min0.671
max0.860
name=cdr_enhanced_4k_loc.art
mean884.853
σ0.007
min884.847
max884.863
mean1452.000
σ0.000
min1452.000
max1452.000
mean0.730
σ0.028
min0.681
max0.747

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.711
mean1452.000
σ0.000
min1452.000
max1452.000
mean3.495
σ0.083
min3.374
max3.973
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean1452.000
σ0.000
min1452.000
max1452.000
mean4.059
σ0.330
min3.406
max4.442
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean1452.000
σ0.000
min1452.000
max1452.000
mean0.745
σ0.017
min0.704
max0.849
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean1452.000
σ0.000
min1452.000
max1452.000
mean0.710
σ0.015
min0.677
max0.783

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.471
σ0.226
min297.219
max298.018
mean2074.000
σ0.000
min2074.000
max2074.000
mean0.555
σ0.034
min0.512
max0.590

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.772
σ0.038
min289.730
max289.813
mean1452.000
σ0.000
min1452.000
max1452.000
mean0.400
σ0.009
min0.394
max0.415
iters=5
new-facts=1
prior-facts=6402
mean1299.683
σ0.095
min1299.568
max1299.822
mean1452.000
σ0.000
min1452.000
max1452.000
mean2.074
σ0.105
min1.977
max2.219
iters=5
new-facts=6402
prior-facts=1
mean1542.628
σ4.043
min1540.617
max1549.854
mean1452.000
σ0.000
min1452.000
max1452.000
mean2.313
σ0.162
min2.099
max2.517
iters=5
new-facts=6402
prior-facts=6402
mean1861.635
σ0.062
min1861.550
max1861.694
mean1733.200
σ243.584
min1452.000
max2074.000
mean3.090
σ0.324
min2.831
max3.640

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.727
σ0.114
min1.593
max1.892

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.184
σ577.140
min157.611
max1311.894
mean96.250
σ8.500
min92.000
max109.000
mean1452.000
σ0.000
min1452.000
max1452.000
mean0.526
σ0.531
min0.260
max1.322
policies=20
mean1576.417
σ0.357
min1576.179
max1576.949
mean920.000
σ0.000
min920.000
max920.000
mean1452.000
σ0.000
min1452.000
max1452.000
mean2.629
σ0.041
min2.595
max2.687
policies=200
mean15772.214
σ0.087
min15772.136
max15772.338
mean9200.000
σ0.000
min9200.000
max9200.000
mean1452.000
σ0.000
min1452.000
max1452.000
mean26.529
σ0.070
min26.446
max26.608