105f28dad11b83349c62b9436db653e4fb1aa045

Home / Branches / ville/reduce-memory-usage-of-view-evaluation / 105f28dad11b83349c62b9436db653e4fb1aa045

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.677
σ0.358
min54.542
max55.696
mean417.000
σ0.000
min417.000
max417.000
mean0.146
σ0.011
min0.136
max0.169
cache=y
dps=1
iters=10
policies=100
mean43.705
σ0.005
min43.697
max43.715
mean417.000
σ0.000
min417.000
max417.000
mean0.124
σ0.005
min0.119
max0.132

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.616
max36.620
mean4147.125
σ1888.814
min1557.000
max7266.000
mean12.555
σ0.347
min12.050
max13.141
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.620
mean4147.125
σ1888.814
min1557.000
max7266.000
mean12.304
σ0.468
min11.677
max13.065
op=table_records(), no indexes
mean41.932
σ0.001
min41.929
max41.933
mean7266.000
σ0.000
min7266.000
max7266.000
mean15.429
σ0.496
min14.449
max16.150
op=table_records(), repeat
mean41.929
σ0.002
min41.927
max41.932
mean4147.125
σ1888.814
min1557.000
max7266.000
mean13.131
σ1.671
min11.396
max15.369
op=vertical_lookup_list() on indexed, after table_records()
mean27.654
σ0.136
min27.604
max27.991
mean4147.125
σ1888.814
min1557.000
max7266.000
mean9.099
σ0.551
min8.270
max9.725
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.400
max26.404
mean4147.125
σ1888.814
min1557.000
max7266.000
mean6.709
σ0.385
min6.112
max7.358
op=vertical_lookup_row_list() on 2 indexed
mean25.668
σ0.003
min25.666
max25.674
mean4147.125
σ1888.814
min1557.000
max7266.000
mean5.970
σ0.138
min5.683
max6.116
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.970
σ0.002
min25.968
max25.974
mean4147.125
σ1888.814
min1557.000
max7266.000
mean5.621
σ0.156
min5.406
max5.933

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606
σ0.000
min2524.606
max2524.607
mean7266.000
σ0.000
min7266.000
max7266.000
mean1575.151
σ977.348
min1044.836
max3856.101
op=load_product(), with indexes
mean8744.722
σ0.469
min8744.553
max8745.882
mean3569.750
σ1789.919
min1044.000
max5776.000
mean4647.774
σ1546.721
min3519.305
max7251.868

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.080
mean4147.125
σ1888.814
min1557.000
max7266.000
mean76.797
σ7.812
min69.052
max92.025
op=vertical_lookup_list() on unindexed missing Int
mean40.945
σ0.001
min40.945
max40.946
mean7266.000
σ0.000
min7266.000
max7266.000
mean107.722
σ3.761
min102.074
max113.379
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.686
max66.687
mean7266.000
σ0.000
min7266.000
max7266.000
mean163.489
σ4.708
min153.219
max167.404

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.900
σ4.304
min11655.306
max11667.552
mean4147.125
σ1888.814
min1557.000
max7266.000
mean6653.890
σ1204.151
min4929.666
max7998.137
op=vertical_lookup_list() on indexed
mean11560.066
σ0.001
min11560.065
max11560.067
mean7266.000
σ0.000
min7266.000
max7266.000
mean5736.810
σ1451.596
min4377.293
max7916.599

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.559
σ0.001
min172.558
max172.562
mean478.000
σ0.000
min478.000
max478.000
mean353.923
σ31.071
min296.812
max393.721
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean560.000
σ0.000
min560.000
max560.000
mean766.794
σ45.662
min658.378
max800.475

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1024.325
σ0.759
min1023.852
max1027.465
mean1053.300
σ316.243
min592.000
max1524.000
mean1.556
σ0.084
min1.481
max1.747

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.913
σ0.020
min0.903
max0.949
mean401.000
σ0.000
min401.000
max401.000
mean0.414
σ0.529
min0.146
max1.358
name=error_case.art
mean2.339
σ0.012
min2.333
max2.361
mean401.000
σ0.000
min401.000
max401.000
mean0.425
σ0.193
min0.327
max0.769
name=heavy_item.art
mean1.522
σ0.002
min1.521
max1.525
mean401.000
σ0.000
min401.000
max401.000
mean0.224
σ0.025
min0.204
max0.268
name=nested_use.art
mean2.357
σ0.002
min2.356
max2.360
mean401.000
σ0.000
min401.000
max401.000
mean0.343
σ0.016
min0.331
max0.371

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.840
σ0.011
min964.835
max964.859
mean441.200
σ4.025
min434.000
max443.000
mean0.565
σ0.059
min0.500
max0.621
name=cdr_enhanced_4k_loc.art
mean885.820
σ0.002
min885.819
max885.823
mean443.000
σ0.000
min443.000
max443.000
mean0.510
σ0.013
min0.495
max0.527

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.709
σ0.002
min7.708
max7.712
mean443.000
σ0.000
min443.000
max443.000
mean2.616
σ0.091
min2.482
max2.857
name=record_render_large_syntax_err.art
mean7.657
σ0.002
min7.656
max7.660
mean443.000
σ0.000
min443.000
max443.000
mean2.625
σ0.099
min2.454
max2.912
name=record_render_success.art
mean2.289
σ0.002
min2.289
max2.293
mean443.000
σ0.000
min443.000
max443.000
mean0.309
σ0.033
min0.290
max0.619
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean443.000
σ0.000
min443.000
max443.000
mean0.290
σ0.008
min0.273
max0.333

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean298.855
σ1.060
min298.402
max301.864
mean444.700
σ13.334
min426.000
max465.000
mean0.614
σ0.020
min0.573
max0.654

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean239.532
σ0.000
min239.532
max239.532
mean1749.000
σ0.000
min1749.000
max1749.000
mean223.290
σ1.260
min221.527
max224.949
phase=macro expansion
mean6.130
σ0.000
min6.130
max6.130
mean1749.000
σ0.000
min1749.000
max1749.000
mean12.045
σ1.219
min9.720
max12.889
phase=parser
mean1042.363
σ0.000
min1042.363
max1042.363
mean1749.000
σ0.000
min1749.000
max1749.000
mean703.077
σ80.360
min569.146
max824.461
phase=processProdDef
mean6169.658
σ0.000
min6169.658
max6169.659
mean1749.000
σ0.000
min1749.000
max1749.000
mean5643.034
σ1286.165
min4028.081
max7815.484
phase=renaming
mean21.671
σ0.000
min21.671
max21.671
mean1749.000
σ0.000
min1749.000
max1749.000
mean45.238
σ5.149
min34.510
max49.113
phase=type checker
mean990.446
σ0.066
min990.348
max990.536
mean1749.000
σ0.000
min1749.000
max1749.000
mean830.634
σ76.924
min691.450
max911.105

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean293.916
σ0.040
min293.862
max293.958
mean441.000
σ2.739
min439.000
max444.000
mean0.398
σ0.009
min0.392
max0.414
iters=5
new-facts=1
prior-facts=6402
mean1320.222
σ0.085
min1320.110
max1320.311
mean1069.600
σ167.699
min845.000
max1277.000
mean2.035
σ0.281
min1.851
max2.527
iters=5
new-facts=6402
prior-facts=1
mean1559.735
σ4.058
min1557.725
max1566.988
mean619.400
σ82.470
min495.000
max717.000
mean2.272
σ0.139
min2.166
max2.508
iters=5
new-facts=6402
prior-facts=6402
mean1882.270
σ0.054
min1882.199
max1882.336
mean1701.800
σ246.969
min1408.000
max2034.000
mean2.972
σ0.078
min2.875
max3.060

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.646
σ0.143
min1.529
max1.881

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean453.535
σ585.528
min160.769
max1331.826
mean102.250
σ8.500
min98.000
max115.000
mean444.000
σ0.000
min444.000
max444.000
mean0.552
σ0.560
min0.271
max1.392
policies=20
mean1608.022
σ0.410
min1607.742
max1608.629
mean980.000
σ0.000
min980.000
max980.000
mean451.250
σ10.595
min444.000
max467.000
mean2.687
σ0.017
min2.674
max2.711
policies=200
mean16088.563
σ0.167
min16088.446
max16088.802
mean9800.000
σ0.000
min9800.000
max9800.000
mean499.500
σ5.196
min493.000
max505.000
mean27.372
σ0.203
min27.208
max27.663