Compare commits

Home / Compare 034558e6 .. 54ae1d05

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.056-54.055=0.000
σ0.370-0.370=0.000
min53.914-53.904=0.010
max55.109-55.108=0.001
mean421.000-418.000=3.000
σ0.000
min421.000-418.000=3.000
max421.000-418.000=3.000
mean0.140-0.140=0.000
σ0.003-0.007=-0.004
min0.137-0.131=0.006
max0.147-0.150=-0.003
cache=y
dps=1
iters=10
policies=100
mean43.393-43.398=-0.005
σ0.006-0.007=-0.001
min43.382-43.385=-0.002
max43.403-43.408=-0.005
mean421.000-418.000=3.000
σ0.000
min421.000-418.000=3.000
max421.000-418.000=3.000
mean0.121-0.141=-0.020
σ0.002-0.006=-0.004
min0.119-0.128=-0.009
max0.128-0.149=-0.021

CSV - column_set() on unindexed

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.078-62.074=0.004
σ0.000-0.000=-0.000
min62.077-62.073=0.004
max62.078-62.074=0.004
mean5061.300-5112.000=-50.700
σ2522.200-2617.258=-95.058
min1351.000
max8558.000-8547.000=11.000
mean102.779-101.303=1.476
σ11.525-14.002=-2.477
min84.424-78.867=5.557
max115.975-113.803=2.171

CSV - column_set(), warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=column_set() on unindexed, dense
rows=200000
mean15109.632-15109.632=-0.000
σ3.863-3.862=0.000
min15108.410-15108.410=-0.000
max15120.625-15120.625=0.000
mean5061.300-5112.000=-50.700
σ2522.200-2617.258=-95.058
min1351.000
max8558.000-8547.000=11.000
mean10457.631-10222.631=235.000
σ1869.933-1954.329=-84.396
min6692.107-6573.262=118.845
max12544.884-12579.581=-34.697

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=load_product(), with indexes
rows=200000
mean8744.542-8744.542=-0.000
σ0.036-0.036=-0.000
min8744.530-8744.530=-0.000
max8744.644-8744.646=-0.001
mean4760.600-4713.700=46.900
σ2538.158-2574.192=-36.034
min1075.000-1077.000=-2.000
max8558.000-8547.000=11.000
mean5124.386-4554.640=569.747
σ1448.553-1210.447=238.106
min3531.828-3484.837=46.991
max7660.100-6928.180=731.919
iterations=10
operation_display=load_product()with indexes
rows=200000
mean8744.532-8744.532=0.000
σ0.002-0.002=0.000
min8744.530-8744.530=-0.000
max8744.535-8744.535=-0.000
mean8558.000-8604.000=-46.000
σ0.000-180.250=-180.250
min8558.000-8547.000=11.000
max8558.000-9117.000=-559.000
mean4199.033-4398.292=-199.258
σ1071.097-1259.196=-188.099
min3506.357-3464.513=41.843
max6461.268-6516.847=-55.578

CSV - table_records()

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=table_records(), repeat
rows=200000
mean41.901-41.901=0.000
σ0.002-0.002=0.000
min41.899-41.899=-0.000
max41.904-41.903=0.000
mean8558.000-8604.000=-46.000
σ0.000-180.250=-180.250
min8558.000-8547.000=11.000
max8558.000-9117.000=-559.000
mean12.410-13.551=-1.140
σ1.841-1.629=0.212
min10.529-10.743=-0.214
max14.739-15.054=-0.315

CSV - table_records(), warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=table_records()
rows=200000
mean15088.238-15088.238=0.000
σ0.002-0.001=0.000
min15088.236-15088.236=0.000
max15088.241
mean8558.000-8604.000=-46.000
σ0.000-180.250=-180.250
min8558.000-8547.000=11.000
max8558.000-9117.000=-559.000
mean9369.417-10097.210=-727.793
σ2024.262-2011.994=12.269
min6564.246-6535.143=29.103
max11685.514-12032.608=-347.094

CSV - vertical_lookup_list() on indexed

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=vertical_lookup_list() on indexed, after column_set(), repeat
rows=200000
mean26.398-26.397=0.000
σ0.000-0.000=-0.000
min26.398-26.397=0.000
max26.398-26.398=0.000
mean5061.300-5112.000=-50.700
σ2522.200-2617.258=-95.058
min1351.000
max8558.000-8547.000=11.000
mean6.649-6.260=0.389
σ0.499-0.638=-0.138
min5.504-5.484=0.020
max7.354-7.052=0.302
iterations=10
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.399-26.399=-0.000
σ0.002-0.002=0.000
min26.397-26.397=-0.000
max26.402-26.401=0.000
mean8558.000-8604.000=-46.000
σ0.000-180.250=-180.250
min8558.000-8547.000=11.000
max8558.000-9117.000=-559.000
mean6.038-6.536=-0.498
σ0.344-0.248=0.097
min5.507-6.152=-0.646
max6.556-6.804=-0.249

CSV - vertical_lookup_row_list() on indexed

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.633-25.633=-0.000
σ0.002-0.003=-0.001
min25.631-25.631=-0.000
max25.635-25.639=-0.004
mean8558.000-8604.000=-46.000
σ0.000-180.250=-180.250
min8558.000-8547.000=11.000
max8558.000-9117.000=-559.000
mean4.730-4.839=-0.109
σ0.151-0.087=0.064
min4.515-4.636=-0.121
max4.974-4.917=0.057
iterations=10
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.628-25.628=-0.000
σ0.002-0.002=0.000
min25.626-25.626=0.000
max25.630
mean8558.000-8604.000=-46.000
σ0.000-180.250=-180.250
min8558.000-8547.000=11.000
max8558.000-9117.000=-559.000
mean4.668-4.906=-0.239
σ0.182-0.235=-0.053
min4.473-4.560=-0.087
max4.929-5.474=-0.545
iterations=10
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.932-25.932=0.000
σ0.002-0.002=0.000
min25.930-25.930=-0.000
max25.935-25.934=0.001
mean8558.000-8604.000=-46.000
σ0.000-180.250=-180.250
min8558.000-8547.000=11.000
max8558.000-9117.000=-559.000
mean4.608-4.819=-0.211
σ0.117-0.129=-0.012
min4.504-4.472=0.033
max4.867-4.921=-0.053
iterations=10
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.931-25.931=-0.000
σ0.002-0.002=-0.000
min25.930-25.930=0.000
max25.934-25.934=-0.000
mean8558.000-8604.000=-46.000
σ0.000-180.250=-180.250
min8558.000-8547.000=11.000
max8558.000-9117.000=-559.000
mean4.645-4.832=-0.187
σ0.188-0.113=0.074
min4.470-4.554=-0.085
max5.098-4.964=0.134

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=pointedIndexFromKvs
rows=200000
mean172.664-172.662=0.002
σ0.010-0.014=-0.004
min172.643-172.638=0.006
max172.677-172.678=-0.001
mean491.000-490.000=1.000
σ0.000
min491.000-490.000=1.000
max491.000-490.000=1.000
mean396.817-382.848=13.968
σ21.156-49.847=-28.690
min354.761-269.230=85.531
max418.579-422.960=-4.381
iterations=10
operation_display=pointedIndexFromKvs
rows=400000
mean357.406-357.400=0.005
σ0.121-0.129=-0.007
min357.321
max357.618-357.628=-0.010
mean567.000-565.000=2.000
σ0.000
min567.000-565.000=2.000
max567.000-565.000=2.000
mean727.259-800.184=-72.926
σ98.191-27.803=70.389
min584.080-726.418=-142.338
max810.932-822.731=-11.799

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1006.875-1006.878=-0.003
σ0.748-0.750=-0.002
min1006.405-1006.406=-0.001
max1009.967-1009.975=-0.007
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean1.599-1.525=0.074
σ0.126-0.131=-0.005
min1.476-1.464=0.012
max1.924-2.078=-0.154

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883-0.883=0.001
σ0.003-0.002=0.000
min0.882
max0.887
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean0.313-0.320=-0.007
σ0.129-0.116=0.013
min0.246-0.260=-0.014
max0.543-0.527=0.017
name=error_case.art
mean2.339-2.339=-0.001
σ0.003-0.003=0.000
min2.337
max2.342
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean0.637-0.637=-0.001
σ0.086-0.086=0.000
min0.585-0.581=0.004
max0.788-0.788=-0.000
name=heavy_item.art
mean1.524-1.523=0.001
σ0.002-0.001=0.001
min1.522
max1.526-1.525=0.001
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean0.538-0.540=-0.002
σ0.056-0.039=0.017
min0.497-0.502=-0.004
max0.636-0.604=0.032
name=nested_use.art
mean2.361-2.362=-0.001
σ0.002-0.002=-0.000
min2.360
max2.364
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean0.849-0.846=0.003
σ0.039-0.043=-0.004
min0.825-0.816=0.010
max0.917-0.919=-0.003

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.831-964.830=0.001
σ0.022-0.026=-0.003
min964.807-964.802=0.005
max964.859-964.869=-0.010
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean0.819-0.814=0.005
σ0.025-0.038=-0.014
min0.785-0.753=0.032
max0.841-0.843=-0.002
name=cdr_enhanced_4k_loc.art
mean885.511-885.512=-0.001
σ0.006-0.008=-0.002
min885.504
max885.519-885.524=-0.006
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean0.714-0.683=0.032
σ0.023-0.074=-0.052
min0.675-0.599=0.077
max0.732-0.742=-0.010

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.716-7.716=0.000
σ0.002-0.002=0.000
min7.715
max7.721-7.719=0.001
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean4.226-4.264=-0.038
σ0.098-0.101=-0.003
min4.071-4.112=-0.041
max4.777-4.586=0.191
name=record_render_large_syntax_err.art
mean7.665-7.665=-0.000
σ0.002-0.002=-0.000
min7.664
max7.668-7.670=-0.003
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean4.273-4.242=0.032
σ0.081-0.083=-0.002
min4.125-4.116=0.010
max4.548-4.518=0.031
name=record_render_success.art
mean2.291
σ0.002
min2.290
max2.294
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean0.740-0.745=-0.006
σ0.025-0.017=0.008
min0.544-0.716=-0.172
max0.828-0.861=-0.033
name=record_render_syntax_err.art
mean2.166
σ0.002
min2.165
max2.169
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean0.705-0.704=0.001
σ0.017-0.016=0.001
min0.671-0.675=-0.004
max0.796-0.789=0.007

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean295.606-295.328=0.278
σ0.207-0.241=-0.035
min295.466-295.173=0.293
max296.179-295.976=0.202
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean0.575-0.551=0.023
σ0.074-0.031=0.042
min0.505-0.513=-0.008
max0.730-0.587=0.144

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean285.371-285.385=-0.014
σ0.030-0.038=-0.008
min285.343-285.339=0.004
max285.419-285.434=-0.015
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean0.400-0.393=0.007
σ0.014-0.007=0.006
min0.390-0.388=0.001
max0.416-0.406=0.010
iters=5
new-facts=1
prior-facts=6402
mean1295.883-1295.883=-0.001
σ0.076-0.066=0.010
min1295.781-1295.809=-0.028
max1295.968-1295.951=0.017
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean2.252-2.248=0.003
σ0.194-0.173=0.021
min1.956-2.016=-0.059
max2.496-2.451=0.045
iters=5
new-facts=6402
prior-facts=1
mean1540.011-1539.969=0.042
σ6.885-6.899=-0.014
min1536.798-1536.699=0.099
max1552.325-1552.306=0.019
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean2.455-2.303=0.151
σ0.234-0.185=0.048
min2.115-2.121=-0.006
max2.688-2.581=0.106
iters=5
new-facts=6402
prior-facts=6402
mean1857.707-1857.685=0.022
σ0.031-0.049=-0.018
min1857.654-1857.607=0.047
max1857.729-1857.725=0.003
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean3.083-3.086=-0.003
σ0.206-0.217=-0.011
min2.869-2.839=0.030
max3.407-3.303=0.103

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.565-1.512=0.053
σ0.251-0.274=-0.024
min1.308-1.268=0.040
max1.885-1.943=-0.058

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean445.740-445.739=0.002
σ580.934-580.934=-0.000
min155.270-155.267=0.002
max1317.141-1317.140=0.001
mean96.250
σ8.500
min92.000
max109.000
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean0.566-0.539=0.026
σ0.582-0.542=0.040
min0.271-0.263=0.007
max1.438-1.351=0.086
policies=20
mean1552.982-1552.975=0.007
σ0.341-0.346=-0.005
min1552.747-1552.736=0.011
max1553.488-1553.488=-0.000
mean920.000
σ0.000
min920.000
max920.000
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean2.616-2.621=-0.005
σ0.027-0.023=0.004
min2.581-2.589=-0.008
max2.638-2.642=-0.003
policies=200
mean15537.984-15537.981=0.004
σ0.083-0.181=-0.098
min15537.865-15537.800=0.065
max15538.051-15538.232=-0.180
mean9200.000
σ0.000
min9200.000
max9200.000
mean8558.000-9117.000=-559.000
σ0.000
min8558.000-9117.000=-559.000
max8558.000-9117.000=-559.000
mean26.376-26.291=0.085
σ0.064-0.151=-0.087
min26.295-26.172=0.122
max26.439-26.496=-0.057