Compare commits

Home / Compare f6ed191a .. 8a446dc8

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-53.703=0.915
σ0.351-0.368=-0.017
min54.486-53.556=0.930
max55.618-54.751=0.867
mean415.000-413.000=2.000
σ0.000
min415.000-413.000=2.000
max415.000-413.000=2.000
mean0.142-0.138=0.004
σ0.004-0.005=-0.000
min0.137-0.129=0.008
max0.147-0.144=0.004
cache=y
dps=1
iters=10
policies=100
mean43.787-43.058=0.729
σ0.006-0.006=0.000
min43.780-43.049=0.731
max43.801-43.066=0.736
mean415.000-413.000=2.000
σ0.000
min415.000-413.000=2.000
max415.000-413.000=2.000
mean0.123-0.122=0.001
σ0.003-0.003=0.000
min0.121-0.118=0.003
max0.132-0.127=0.004

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=column_set() on indexed
rows=200000
mean36.617
σ0.002
min36.615
max36.619
mean4289.125
σ1984.150
min1548.000
max7212.000
mean98.897
σ244.148
min12.177
max703.133
iterations=8
operation_display=column_set() on indexed, repeat
rows=200000
mean36.618
σ0.002
min36.616
max36.620
mean4289.125
σ1984.150
min1548.000
max7212.000
mean13.320
σ0.911
min12.744
max15.504
iterations=8
operation_display=table_records(), no indexes
rows=200000
mean41.930
σ0.002
min41.928
max41.932
mean7212.000
σ0.000
min7212.000
max7212.000
mean14.962
σ0.680
min13.674
max15.724
iterations=8
operation_display=table_records(), no indexes, repeat
rows=200000
mean41.929
σ0.002
min41.928
max41.932
mean7212.000
σ0.000
min7212.000
max7212.000
mean13.056
σ0.895
min11.714
max14.169
iterations=8
operation_display=table_records(), repeat
rows=200000
mean41.929
σ0.002
min41.927
max41.932
mean4172.250
σ1906.155
min1548.000
max7212.000
mean13.546
σ1.820
min10.718
max15.642
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records()
rows=200000
mean27.605
σ0.002
min27.603
max27.607
mean4172.250
σ1906.155
min1548.000
max7212.000
mean9.001
σ0.372
min8.256
max9.414
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.400
σ0.002
min26.399
max26.403
mean4172.250
σ1906.155
min1548.000
max7212.000
mean6.794
σ0.324
min6.404
max7.327
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.666
σ0.002
min25.664
max25.668
mean4289.125
σ1984.150
min1548.000
max7212.000
mean5.996
σ0.142
min5.810
max6.236
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.661
σ0.002
min25.659
max25.663
mean4289.125
σ1984.150
min1548.000
max7212.000
mean5.566
σ0.116
min5.307
max5.685
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.969
σ0.002
min25.967
max25.971
mean4289.125
σ1984.150
min1548.000
max7212.000
mean5.682
σ0.119
min5.440
max5.828
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.968
σ0.002
min25.967
max25.971
mean4289.125
σ1984.150
min1548.000
max7212.000
mean5.497
σ0.169
min5.141
max5.740

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=load_product(), no indexes
rows=200000
mean2524.595
σ0.002
min2524.594
max2524.598
mean7212.000
σ0.000
min7212.000
max7212.000
mean1483.176
σ719.148
min1028.958
max2980.407
iterations=8
operation_display=load_product(), with indexes
rows=200000
mean8744.560
σ0.040
min8744.545
max8744.659
mean3593.500
σ1823.849
min1069.000
max5834.000
mean4462.183
σ1323.634
min3467.199
max6910.194

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=column_set() on unindexed, dense
rows=200000
mean62.076
σ0.001
min62.076
max62.080
mean4172.250
σ1906.155
min1548.000
max7212.000
mean77.014
σ4.110
min70.326
max82.794
iterations=8
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.077
σ0.002
min62.076
max62.080
mean4172.250
σ1906.155
min1548.000
max7212.000
mean77.260
σ3.805
min70.801
max82.871
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int
rows=200000
mean40.945
σ0.002
min40.944
max40.949
mean7212.000
σ0.000
min7212.000
max7212.000
mean103.144
σ7.550
min90.549
max109.428
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int, repeat
rows=200000
mean40.945
σ0.002
min40.943
max40.947
mean7212.000
σ0.000
min7212.000
max7212.000
mean103.114
σ7.394
min90.943
max108.857
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end
rows=200000
mean40.950
σ0.002
min40.949
max40.954
mean7212.000
σ0.000
min7212.000
max7212.000
mean105.480
σ6.460
min94.451
max112.057
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat
rows=200000
mean40.950
σ0.002
min40.949
max40.953
mean7212.000
σ0.000
min7212.000
max7212.000
mean103.058
σ7.117
min91.229
max107.908
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int
rows=200000
mean66.687
σ0.003
min66.685
max66.694
mean7212.000
σ0.000
min7212.000
max7212.000
mean209.357
σ141.708
min142.607
max559.121
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat
rows=200000
mean66.686
σ0.001
min66.685
max66.689
mean7212.000
σ0.000
min7212.000
max7212.000
mean152.841
σ21.522
min106.757
max168.889

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=table_records()
rows=200000
mean11656.833
σ4.319
min11655.305
max11667.522
mean4172.250
σ1906.155
min1548.000
max7212.000
mean6789.668
σ1025.080
min4856.754
max8014.381
iterations=8
operation_display=vertical_lookup_list() on indexed
rows=200000
mean11560.066
σ0.002
min11560.064
max11560.069
mean7212.000
σ0.000
min7212.000
max7212.000
mean5773.843
σ1357.794
min4346.665
max7664.151

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=pointedIndexFromKvs
rows=200000
mean172.654
σ0.012
min172.642
max172.671
mean486.000
σ0.000
min486.000
max486.000
mean359.539
σ29.101
min309.921
max394.366
iterations=8
operation_display=pointedIndexFromKvs
rows=400000
mean357.475
σ0.162
min357.321
max357.635
mean562.000
σ0.000
min562.000
max562.000
mean796.351
σ22.246
min745.815
max813.250

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.084-1005.108=2.976
σ0.761-0.875=-0.114
min1007.610-1004.620=2.990
max1011.230-1008.735=2.495
mean7212.000-1052.950=6159.050
σ0.000-321.163=-321.163
min7212.000-552.000=6660.000
max7212.000-1632.000=5580.000
mean1.524-1.621=-0.097
σ0.147-0.088=0.059
min1.383-1.478=-0.095
max1.893-1.860=0.032

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.884-0.883=0.001
σ0.003-0.002=0.000
min0.881
max0.887-0.886=0.001
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean0.323-0.498=-0.175
σ0.108-0.187=-0.079
min0.236-0.353=-0.117
max0.499-0.712=-0.213
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean0.740-0.912=-0.172
σ0.114-0.110=0.003
min0.602-0.839=-0.237
max0.839-1.108=-0.269
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean0.534-0.553=-0.019
σ0.043-0.052=-0.010
min0.498-0.514=-0.016
max0.603-0.644=-0.041
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean0.837-0.891=-0.054
σ0.041-0.054=-0.013
min0.806-0.831=-0.024
max0.908-0.973=-0.065

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.550-963.553=-0.003
σ0.026-0.035=-0.009
min963.536-963.533=0.002
max963.596-963.615=-0.019
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean0.790-0.826=-0.036
σ0.086-0.051=0.035
min0.641-0.761=-0.120
max0.847-0.865=-0.018
name=cdr_enhanced_4k_loc.art
mean884.854-884.853=0.001
σ0.010-0.008=0.001
min884.847
max884.869-884.867=0.002
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean0.640-0.736=-0.096
σ0.005-0.034=-0.029
min0.634-0.675=-0.041
max0.646-0.758=-0.112

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706-7.706=-0.000
σ0.002-0.002=-0.000
min7.705
max7.709-7.711=-0.001
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean3.494-4.285=-0.790
σ0.083-0.072=0.011
min3.286-4.146=-0.860
max3.760-4.603=-0.843
name=record_render_large_syntax_err.art
mean7.655-7.655=0.000
σ0.002-0.002=0.000
min7.654
max7.659-7.658=0.001
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean3.057-4.248=-1.191
σ0.385-0.087=0.298
min2.617-4.101=-1.485
max3.850-4.639=-0.789
name=record_render_success.art
mean2.288-2.288=0.000
σ0.002-0.002=-0.000
min2.287
max2.291
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean0.540-0.766=-0.225
σ0.038-0.022=0.015
min0.513-0.737=-0.224
max0.885-0.928=-0.043
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean0.509-0.723=-0.214
σ0.024-0.017=0.007
min0.403-0.681=-0.277
max0.690-0.796=-0.105

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.507-294.181=3.326
σ0.240-0.187=0.052
min297.342-293.987=3.355
max298.163-294.669=3.493
mean7212.000-1939.000=5273.000
σ0.000
min7212.000-1939.000=5273.000
max7212.000-1939.000=5273.000
mean0.575-0.563=0.012
σ0.055-0.052=0.003
min0.513-0.487=0.026
max0.700-0.661=0.039

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.727-281.497=8.230
σ0.031-0.040=-0.009
min289.684-281.448=8.236
max289.769-281.539=8.229
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean0.388-0.394=-0.006
σ0.001-0.006=-0.005
min0.387-0.386=0.001
max0.389-0.400=-0.011
iters=5
new-facts=1
prior-facts=6402
mean1299.631-1291.476=8.155
σ0.104-0.103=0.001
min1299.505-1291.360=8.145
max1299.773-1291.612=8.161
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean2.039-1.982=0.057
σ0.092-0.160=-0.068
min1.936-1.839=0.097
max2.174-2.249=-0.075
iters=5
new-facts=6402
prior-facts=1
mean1542.638-1534.321=8.317
σ4.052-4.013=0.039
min1540.567-1532.297=8.270
max1549.877-1541.491=8.386
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean2.336-2.222=0.114
σ0.214-0.190=0.024
min2.124-2.036=0.089
max2.595-2.462=0.133
iters=5
new-facts=6402
prior-facts=6402
mean1861.609-1853.354=8.254
σ0.056-0.049=0.007
min1861.535-1853.307=8.228
max1861.668-1853.423=8.244
mean7212.000-1792.800=5419.200
σ0.000-147.298=-147.298
min7212.000-1632.000=5580.000
max7212.000-1939.000=5273.000
mean3.010-3.137=-0.126
σ0.106-0.281=-0.175
min2.878-2.905=-0.028
max3.172-3.622=-0.449

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.470-1.487=-0.018
σ0.254-0.289=-0.035
min1.277-1.122=0.155
max1.812-1.889=-0.077

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.150-442.430=3.720
σ577.066-577.064=0.002
min157.614-153.896=3.718
max1311.749-1308.026=3.723
mean96.250
σ8.500
min92.000
max109.000
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean0.543-0.552=-0.009
σ0.552-0.590=-0.038
min0.266-0.255=0.011
max1.370-1.436=-0.066
policies=20
mean1576.426-1539.224=37.202
σ0.347-0.316=0.032
min1576.194-1539.004=37.190
max1576.942-1539.693=37.250
mean920.000
σ0.000
min920.000
max920.000
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean2.636-2.571=0.066
σ0.020-0.010=0.010
min2.617-2.560=0.057
max2.659-2.581=0.077
policies=200
mean15772.223-15400.412=371.811
σ0.074-0.053=0.020
min15772.113-15400.358=371.754
max15772.263-15400.484=371.779
mean9200.000
σ0.000
min9200.000
max9200.000
mean7212.000-1632.000=5580.000
σ0.000
min7212.000-1632.000=5580.000
max7212.000-1632.000=5580.000
mean26.517-26.049=0.468
σ0.097-0.047=0.051
min26.412-25.991=0.421
max26.612-26.102=0.509