de0ee51d2d5853c9bbf18f0d0c9c3247e404dd7f

Home / Branches / sergeiwinitzki/lan-71-2-csv-table-optimizations / de0ee51d2d5853c9bbf18f0d0c9c3247e404dd7f

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.678
σ0.357
min54.549
max55.693
mean421.000
σ0.000
min421.000
max421.000
mean0.145
σ0.009
min0.139
max0.168
cache=y
dps=1
iters=10
policies=100
mean43.705
σ0.006
min43.694
max43.714
mean421.000
σ0.000
min421.000
max421.000
mean0.126
σ0.009
min0.116
max0.143

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.616
max36.620
mean3865.750
σ1850.535
min1275.000
max6159.000
mean12.902
σ0.247
min12.542
max13.270
op=column_set() on indexed, repeat
mean36.618
σ0.002
min36.616
max36.620
mean3865.750
σ1850.535
min1275.000
max6159.000
mean12.935
σ0.577
min11.995
max13.449
op=table_records(), no indexes
mean41.930
σ0.002
min41.928
max41.932
mean6159.000
σ0.000
min6159.000
max6159.000
mean15.181
σ0.316
min14.431
max15.413
op=table_records(), repeat
mean41.929
σ0.002
min41.927
max41.932
mean3865.750
σ1850.535
min1275.000
max6159.000
mean13.359
σ1.908
min10.912
max15.274
op=vertical_lookup_list() on indexed, after table_records()
mean27.654
σ0.136
min27.604
max27.991
mean3865.750
σ1850.535
min1275.000
max6159.000
mean9.331
σ0.389
min8.900
max9.784
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.400
max26.404
mean3865.750
σ1850.535
min1275.000
max6159.000
mean6.660
σ0.305
min5.974
max6.975
op=vertical_lookup_row_list() on 2 indexed
mean25.668
σ0.004
min25.665
max25.677
mean3865.750
σ1850.535
min1275.000
max6159.000
mean6.013
σ0.134
min5.793
max6.155
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.970
σ0.002
min25.968
max25.972
mean3865.750
σ1850.535
min1275.000
max6159.000
mean5.953
σ0.133
min5.810
max6.226

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.604
σ0.002
min2524.602
max2524.606
mean6159.000
σ0.000
min6159.000
max6159.000
mean1349.729
σ579.618
min1029.815
max2408.465
op=load_product(), with indexes
mean7917.788
σ0.469
min7917.621
max7918.950
mean3224.125
σ1839.462
min809.000
max6159.000
mean3789.602
σ1296.772
min3075.327
max6201.392

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.077
σ0.002
min62.076
max62.080
mean3865.750
σ1850.535
min1275.000
max6159.000
mean84.237
σ12.164
min71.829
max101.698
op=vertical_lookup_list() on unindexed missing Int
mean40.946
σ0.002
min40.945
max40.950
mean6159.000
σ0.000
min6159.000
max6159.000
mean63.501
σ3.710
min60.990
max70.343
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.688
σ0.002
min66.686
max66.691
mean6159.000
σ0.000
min6159.000
max6159.000
mean100.227
σ0.815
min99.254
max101.918

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11745.441
σ4.303
min11743.845
max11756.090
mean3865.750
σ1850.535
min1275.000
max6159.000
mean6193.452
σ1064.275
min4931.855
max7608.167
op=vertical_lookup_list() on indexed
mean10687.378
σ0.002
min10687.375
max10687.380
mean6159.000
σ0.000
min6159.000
max6159.000
mean4858.262
σ1594.580
min3982.244
max7560.440

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.559
σ0.001
min172.558
max172.562
mean477.000
σ0.000
min477.000
max477.000
mean371.530
σ19.836
min345.237
max393.518
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean562.000
σ0.000
min562.000
max562.000
mean772.242
σ9.295
min759.531
max785.699

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1024.326
σ0.758
min1023.853
max1027.463
mean1052.350
σ316.085
min592.000
max1523.000
mean1.580
σ0.087
min1.502
max1.788

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.913
σ0.020
min0.903
max0.949
mean402.000
σ0.000
min402.000
max402.000
mean0.301
σ0.283
min0.143
max0.803
name=error_case.art
mean2.339
σ0.012
min2.333
max2.361
mean402.000
σ0.000
min402.000
max402.000
mean0.482
σ0.318
min0.323
max1.050
name=heavy_item.art
mean1.522
σ0.002
min1.521
max1.525
mean402.000
σ0.000
min402.000
max402.000
mean0.226
σ0.023
min0.210
max0.267
name=nested_use.art
mean2.357
σ0.002
min2.356
max2.360
mean402.000
σ0.000
min402.000
max402.000
mean0.333
σ0.023
min0.316
max0.371

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.840
σ0.011
min964.835
max964.859
mean431.600
σ1.342
min431.000
max434.000
mean0.522
σ0.046
min0.464
max0.586
name=cdr_enhanced_4k_loc.art
mean885.820
σ0.002
min885.819
max885.823
mean441.000
σ0.000
min441.000
max441.000
mean0.461
σ0.054
min0.375
max0.521

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.709
σ0.002
min7.708
max7.712
mean441.000
σ0.000
min441.000
max441.000
mean2.626
σ0.107
min2.447
max3.175
name=record_render_large_syntax_err.art
mean7.657
σ0.002
min7.656
max7.660
mean441.000
σ0.000
min441.000
max441.000
mean2.616
σ0.078
min2.477
max2.821
name=record_render_success.art
mean2.289
σ0.002
min2.289
max2.293
mean441.000
σ0.000
min441.000
max441.000
mean0.308
σ0.011
min0.285
max0.369
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean441.000
σ0.000
min441.000
max441.000
mean0.292
σ0.007
min0.281
max0.330

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean298.826
σ0.994
min298.430
max301.652
mean438.500
σ17.684
min413.000
max465.000
mean0.599
σ0.024
min0.568
max0.639

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean239.532
σ0.000
min239.532
max239.532
mean1053.625
σ20.860
min1002.000
max1061.000
mean220.445
σ2.374
min216.905
max224.914
phase=macro expansion
mean6.130
σ0.000
min6.130
max6.130
mean1053.625
σ20.860
min1002.000
max1061.000
mean11.421
σ1.978
min7.386
max12.870
phase=parser
mean1042.363
σ0.000
min1042.363
max1042.363
mean1053.625
σ20.860
min1002.000
max1061.000
mean666.911
σ113.897
min400.085
max738.563
phase=processProdDef
mean4874.332
σ0.000
min4874.332
max4874.333
mean1061.000
σ0.000
min1061.000
max1061.000
mean4805.796
σ1153.404
min3319.469
max6287.066
phase=renaming
mean21.671
σ0.000
min21.671
max21.671
mean1053.625
σ20.860
min1002.000
max1061.000
mean42.477
σ8.782
min26.285
max48.811
phase=type checker
mean990.446
σ0.066
min990.348
max990.536
mean1053.625
σ20.860
min1002.000
max1061.000
mean824.527
σ93.555
min687.401
max931.739

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean293.917
σ0.041
min293.861
max293.962
mean442.200
σ1.643
min441.000
max444.000
mean0.401
σ0.002
min0.398
max0.403
iters=5
new-facts=1
prior-facts=6402
mean1320.264
σ0.063
min1320.169
max1320.340
mean1085.200
σ183.282
min866.000
max1307.000
mean2.069
σ0.190
min1.831
max2.280
iters=5
new-facts=6402
prior-facts=1
mean1559.449
σ3.369
min1557.753
max1565.466
mean626.400
σ87.251
min496.000
max732.000
mean2.327
σ0.247
min2.129
max2.643
iters=5
new-facts=6402
prior-facts=6402
mean1882.270
σ0.058
min1882.191
max1882.348
mean1721.000
σ169.179
min1475.000
max1876.000
mean3.004
σ0.197
min2.806
max3.325

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.793
σ0.178
min1.489
max1.920

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean452.904
σ584.268
min160.768
max1329.305
mean102.250
σ8.500
min98.000
max115.000
mean440.000
σ0.000
min440.000
max440.000
mean0.551
σ0.559
min0.266
max1.390
policies=20
mean1608.030
σ0.431
min1607.734
max1608.668
mean980.000
σ0.000
min980.000
max980.000
mean444.250
σ8.500
min440.000
max457.000
mean2.716
σ0.036
min2.678
max2.760
policies=200
mean16088.476
σ0.291
min16088.125
max16088.836
mean9800.000
σ0.000
min9800.000
max9800.000
mean495.250
σ3.775
min491.000
max500.000
mean27.316
σ0.205
min27.109
max27.528