Compare commits

Home / Compare b1ee90ab .. 3a9f75bf

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.055-54.055=-0.000
σ0.369-0.369=0.000
min53.912-53.906=0.006
max55.104-55.103=0.001
mean416.000-414.000=2.000
σ0.000
min416.000-414.000=2.000
max416.000-414.000=2.000
mean0.140-0.138=0.002
σ0.004-0.005=-0.001
min0.135-0.131=0.004
max0.147-0.149=-0.002
cache=y
dps=1
iters=10
policies=100
mean43.394-43.394=0.001
σ0.007-0.005=0.002
min43.384-43.386=-0.002
max43.407-43.400=0.007
mean416.000-414.000=2.000
σ0.000
min416.000-414.000=2.000
max416.000-414.000=2.000
mean0.124-0.122=0.002
σ0.008-0.004=0.003
min0.115-0.116=-0.001
max0.142-0.128=0.014

CSV - column_set() on unindexed

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.080-62.074=0.006
σ0.000-0.000=-0.000
min62.080-62.073=0.007
max62.081-62.075=0.006
mean5114.900-5165.200=-50.300
σ2616.049-2657.716=-41.667
min1350.000
max8551.000-8665.000=-114.000
mean102.873-102.290=0.583
σ15.516-13.069=2.448
min75.830-79.759=-3.929
max118.174-116.928=1.247

CSV - column_set(), warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=column_set() on unindexed, dense
rows=200000
mean15109.635-15109.632=0.003
σ3.862-3.862=0.000
min15108.413-15108.410=0.003
max15120.627-15120.623=0.004
mean5114.900-5165.200=-50.300
σ2616.049-2657.716=-41.667
min1350.000
max8551.000-8665.000=-114.000
mean10447.323-9995.046=452.277
σ1835.501-2183.084=-347.584
min6632.425-6708.088=-75.663
max12392.998-11928.234=464.765

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=load_product(), with indexes
rows=200000
mean8744.542-8744.545=-0.003
σ0.036-0.035=0.001
min8744.530-8744.534=-0.004
max8744.645-8744.645=0.000
mean4711.900-4750.600=-38.700
σ2577.744-2616.392=-38.648
min1074.000-1070.000=4.000
max8551.000-8665.000=-114.000
mean4945.191-4623.202=321.990
σ1383.309-1014.644=368.665
min3512.280-3509.756=2.524
max7377.984-6255.217=1122.767
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
mean8576.700-8701.200=-124.500
σ81.271-114.474=-33.204
min8551.000-8665.000=-114.000
max8808.000-9027.000=-219.000
mean4668.441-4586.556=81.885
σ1523.843-1063.259=460.584
min3486.977-3503.572=-16.595
max6923.415-6373.361=550.054

CSV - table_records()

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=table_records(), repeat
rows=200000
mean41.930-41.901=0.029
σ0.002-0.002=0.000
min41.928-41.899=0.029
max41.932-41.904=0.029
mean8576.700-8701.200=-124.500
σ81.271-114.474=-33.204
min8551.000-8665.000=-114.000
max8808.000-9027.000=-219.000
mean14.419-14.311=0.108
σ1.408-1.655=-0.248
min11.656-11.485=0.171
max15.742-16.046=-0.304

CSV - table_records(), warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=table_records()
rows=200000
mean15088.267-15088.238=0.029
σ0.002-0.002=-0.000
min15088.265-15088.236=0.029
max15088.270-15088.242=0.028
mean8576.700-8701.200=-124.500
σ81.271-114.474=-33.204
min8551.000-8665.000=-114.000
max8808.000-9027.000=-219.000
mean10350.873-10079.189=271.683
σ1860.762-2135.831=-275.070
min6566.293-6510.671=55.622
max12408.742-12577.149=-168.407

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.400-26.398=0.002
σ0.000-0.001=-0.001
min26.400-26.397=0.003
max26.400-26.401=-0.001
mean5114.900-5165.200=-50.300
σ2616.049-2657.716=-41.667
min1350.000
max8551.000-8665.000=-114.000
mean6.932-7.426=-0.493
σ0.612-0.425=0.187
min6.041-6.698=-0.657
max7.735-7.924=-0.189
iterations=10
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.401-26.398=0.002
σ0.002-0.002=0.000
min26.400-26.397=0.002
max26.404-26.401=0.002
mean8576.700-8701.200=-124.500
σ81.271-114.474=-33.204
min8551.000-8665.000=-114.000
max8808.000-9027.000=-219.000
mean7.198-7.170=0.028
σ0.269-0.308=-0.039
min6.501-6.698=-0.197
max7.432-7.466=-0.034

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.586-25.633=-0.047
σ0.003-0.002=0.000
min25.584-25.631=-0.048
max25.591-25.637=-0.046
mean8576.700-8701.200=-124.500
σ81.271-114.474=-33.204
min8551.000-8665.000=-114.000
max8808.000-9027.000=-219.000
mean5.352-5.424=-0.071
σ0.085-0.127=-0.042
min5.239-5.191=0.048
max5.486-5.658=-0.171
iterations=10
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.580-25.628=-0.048
σ0.002-0.002=0.000
min25.578-25.626=-0.048
max25.583-25.630=-0.048
mean8576.700-8701.200=-124.500
σ81.271-114.474=-33.204
min8551.000-8665.000=-114.000
max8808.000-9027.000=-219.000
mean5.312-5.305=0.007
σ0.078-0.159=-0.081
min5.207-5.037=0.170
max5.433-5.513=-0.081
iterations=10
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.883-25.932=-0.049
σ0.002-0.002=0.000
min25.881-25.930=-0.049
max25.886-25.935=-0.049
mean8576.700-8701.200=-124.500
σ81.271-114.474=-33.204
min8551.000-8665.000=-114.000
max8808.000-9027.000=-219.000
mean5.353-5.303=0.050
σ0.070-0.160=-0.090
min5.249-4.913=0.336
max5.482-5.442=0.040
iterations=10
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.882-25.931=-0.049
σ0.002-0.002=-0.000
min25.881-25.930=-0.049
max25.885-25.934=-0.049
mean8576.700-8701.200=-124.500
σ81.271-114.474=-33.204
min8551.000-8665.000=-114.000
max8808.000-9027.000=-219.000
mean5.321-5.312=0.008
σ0.082-0.123=-0.041
min5.228-5.056=0.172
max5.468-5.440=0.029

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=pointedIndexFromKvs
rows=200000
mean172.655-172.666=-0.011
σ0.012-0.012=0.000
min172.640-172.644=-0.004
max172.675-172.675=-0.000
mean487.000-484.000=3.000
σ0.000
min487.000-484.000=3.000
max487.000-484.000=3.000
mean356.895-388.116=-31.221
σ44.997-43.627=1.369
min269.287-270.590=-1.303
max403.356-419.654=-16.297
iterations=10
operation_display=pointedIndexFromKvs
rows=400000
mean357.424-357.406=0.018
σ0.134-0.140=-0.006
min357.321
max357.632-357.654=-0.022
mean566.000-560.000=6.000
σ0.000
min566.000-560.000=6.000
max566.000-560.000=6.000
mean693.645-786.213=-92.568
σ63.518-34.104=29.414
min613.121-701.573=-88.451
max781.684-815.177=-33.492

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1006.872-1006.876=-0.004
σ0.751-0.751=-0.000
min1006.406-1006.406=-0.001
max1009.977-1009.979=-0.002
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean1.552-1.509=0.043
σ0.131-0.116=0.015
min1.381-1.460=-0.079
max2.006-1.998=0.008

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.003
min0.882
max0.887
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean0.295-0.419=-0.124
σ0.093-0.133=-0.040
min0.239-0.339=-0.100
max0.460-0.656=-0.196
name=error_case.art
mean2.339-2.339=0.001
σ0.003-0.003=0.001
min2.337
max2.343-2.342=0.001
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean0.624-0.878=-0.255
σ0.047-0.089=-0.042
min0.590-0.818=-0.228
max0.700-1.034=-0.333
name=heavy_item.art
mean1.524
σ0.002
min1.522
max1.526
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean0.392-0.530=-0.139
σ0.040-0.038=0.002
min0.367-0.501=-0.134
max0.463-0.594=-0.131
name=nested_use.art
mean2.361-2.361=-0.000
σ0.002-0.002=0.000
min2.360
max2.364
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean0.603-0.856=-0.254
σ0.027-0.039=-0.011
min0.576-0.814=-0.238
max0.644-0.916=-0.271

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.831-964.830=0.001
σ0.033-0.028=0.005
min964.806-964.802=0.004
max964.887-964.864=0.023
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean0.780-0.819=-0.039
σ0.037-0.024=0.012
min0.746-0.792=-0.046
max0.833-0.843=-0.010
name=cdr_enhanced_4k_loc.art
mean885.514-885.510=0.003
σ0.006-0.005=0.001
min885.504
max885.518-885.516=0.002
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean0.694-0.710=-0.015
σ0.045-0.037=0.008
min0.619-0.644=-0.025
max0.726-0.728=-0.002

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.719-7.721=-0.001
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean4.219-4.292=-0.073
σ0.101-0.099=0.002
min3.706-4.132=-0.425
max4.510-4.617=-0.107
name=record_render_large_syntax_err.art
mean7.665-7.665=0.000
σ0.002-0.002=0.000
min7.664
max7.669-7.668=0.001
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean4.214-4.237=-0.023
σ0.063-0.106=-0.043
min4.084-4.077=0.007
max4.391-5.082=-0.690
name=record_render_success.art
mean2.291
σ0.002
min2.290
max2.294
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean0.734-0.743=-0.009
σ0.017-0.017=-0.000
min0.692-0.707=-0.015
max0.841-0.849=-0.008
name=record_render_syntax_err.art
mean2.166
σ0.002
min2.165
max2.169
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean0.693-0.699=-0.006
σ0.013-0.032=-0.018
min0.663-0.496=0.167
max0.767-0.753=0.014

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean295.701-295.497=0.205
σ0.186-0.218=-0.032
min295.502-295.344=0.159
max296.172-296.090=0.082
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean0.559-0.554=0.005
σ0.038-0.028=0.009
min0.504-0.513=-0.009
max0.606-0.582=0.024

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean285.389-285.382=0.007
σ0.033-0.036=-0.003
min285.351-285.334=0.017
max285.427-285.422=0.004
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean0.392-0.395=-0.002
σ0.008-0.009=-0.001
min0.387-0.386=0.001
max0.407-0.407=0.001
iters=5
new-facts=1
prior-facts=6402
mean1295.858-1295.892=-0.034
σ0.081-0.067=0.014
min1295.794-1295.828=-0.034
max1295.993-1295.982=0.011
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean2.185-2.312=-0.127
σ0.194-0.121=0.073
min1.969-2.162=-0.193
max2.460-2.456=0.005
iters=5
new-facts=6402
prior-facts=1
mean1539.969-1539.963=0.006
σ6.903-6.897=0.006
min1536.701-1536.689=0.011
max1552.314-1552.298=0.016
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean2.315-2.304=0.011
σ0.185-0.210=-0.025
min2.133-2.144=-0.011
max2.604-2.671=-0.067
iters=5
new-facts=6402
prior-facts=6402
mean1857.694-1857.685=0.009
σ0.046-0.051=-0.005
min1857.636-1857.611=0.025
max1857.736-1857.730=0.006
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean2.969-3.142=-0.173
σ0.124-0.271=-0.147
min2.832-2.852=-0.019
max3.109-3.453=-0.344

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.397-1.623=-0.226
σ0.133-0.189=-0.057
min1.267-1.322=-0.055
max1.587-1.847=-0.260

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean445.742-445.740=0.003
σ580.934-580.933=0.001
min155.273-155.269=0.004
max1317.143-1317.140=0.003
mean96.250
σ8.500
min92.000
max109.000
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean0.551-0.541=0.010
σ0.574-0.540=0.034
min0.258-0.267=-0.009
max1.411-1.351=0.061
policies=20
mean1553.000-1552.974=0.026
σ0.343-0.325=0.018
min1552.770-1552.748=0.022
max1553.509-1553.456=0.053
mean920.000
σ0.000
min920.000
max920.000
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean2.622-2.593=0.028
σ0.025-0.031=-0.006
min2.591-2.561=0.030
max2.646-2.622=0.024
policies=200
mean15537.923-15537.971=-0.048
σ0.111-0.107=0.005
min15537.807-15537.830=-0.023
max15538.066-15538.063=0.003
mean9200.000
σ0.000
min9200.000
max9200.000
mean8808.000-9027.000=-219.000
σ0.000
min8808.000-9027.000=-219.000
max8808.000-9027.000=-219.000
mean26.305-26.196=0.109
σ0.085-0.082=0.003
min26.190-26.128=0.062
max26.393-26.292=0.101