8a99abe5ca35035dc922b0fe9adf9140a696a467

Home / Branches / sergeiwinitzki/lan-83-csv-table-cache / 8a99abe5ca35035dc922b0fe9adf9140a696a467

AST compact size (buildDeclTree)

Factorcompact size MiB
phase=buildDeclTree
mean0.203
σ0.000
min0.203
max0.203

AST compact size (macro expansion)

Factorcompact size MiB
phase=macro expansion
mean5.082
σ0.000
min5.082
max5.082

AST compact size (parser)

Factorcompact size MiB
phase=parser
mean4.988
σ0.000
min4.988
max4.988

AST compact size (processProdDef Decls)

Factorcompact size MiB
phase=processProdDef Decls
mean5.395
σ0.000
min5.395
max5.395

AST compact size (processProdDef)

Factorcompact size MiB
phase=processProdDef
mean446.633
σ0.000
min446.633
max446.633

AST compact size (renaming)

Factorcompact size MiB
phase=renaming
mean5.238
σ0.000
min5.238
max5.238

AST compact size (type checker)

Factorcompact size MiB
phase=type checker
mean6.395
σ0.000
min6.395
max6.395

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.750
σ0.364
min54.611
max55.786
mean418.000
σ0.000
min418.000
max418.000
mean0.141
σ0.003
min0.138
max0.147
cache=y
dps=1
iters=10
policies=100
mean43.809
σ0.006
min43.798
max43.820
mean418.700
σ0.483
min418.000
max419.000
mean0.122
σ0.004
min0.118
max0.130

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.604
σ0.000
min36.604
max36.605
mean4588.500
σ2248.812
min1483.000
max7385.000
mean112.155
σ281.074
min11.789
max807.759
op=column_set() on indexed, repeat
mean36.604
σ0.000
min36.604
max36.605
mean4588.500
σ2248.812
min1483.000
max7385.000
mean13.587
σ3.355
min11.344
max20.459
op=table_records(), no indexes
mean41.939
σ0.002
min41.938
max41.942
mean7385.000
σ0.000
min7385.000
max7385.000
mean11.147
σ0.302
min10.774
max11.823
op=table_records(), repeat
mean41.925
σ0.000
min41.924
max41.925
mean4178.625
σ1944.534
min1483.000
max7385.000
mean11.786
σ1.854
min10.857
max16.350
op=vertical_lookup_list() on indexed, after table_records()
mean27.633
σ0.137
min27.584
max27.971
mean4178.625
σ1944.534
min1483.000
max7385.000
mean9.132
σ1.214
min8.173
max12.082
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.384
σ0.000
min26.384
max26.384
mean4178.625
σ1944.534
min1483.000
max7385.000
mean7.181
σ1.024
min6.270
max9.464
op=vertical_lookup_row_list() on 2 indexed
mean25.662
σ0.004
min25.661
max25.673
mean4588.500
σ2248.812
min1483.000
max7385.000
mean6.379
σ0.789
min5.833
max8.024
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.961
σ0.001
min25.961
max25.962
mean4588.500
σ2248.812
min1483.000
max7385.000
mean6.173
σ0.610
min5.786
max7.212

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean1021.613
σ0.002
min1021.611
max1021.616
mean7385.000
σ0.000
min7385.000
max7385.000
mean448.480
σ84.306
min415.043
max657.076
op=load_product(), with indexes
mean3495.860
σ0.454
min3495.699
max3496.982
mean3755.375
σ2298.825
min720.000
max7385.000
mean1861.348
σ671.690
min1465.955
max3031.268

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense, minor warmup
mean107.841
σ0.000
min107.841
max107.842
mean4408.500
σ2218.651
min1483.000
max7385.000
mean293.894
σ447.558
min124.947
max1400.798
op=column_set() on unindexed, dense, repeat
mean62.068
σ0.001
min62.065
max62.068
mean4408.500
σ2218.651
min1483.000
max7385.000
mean45.518
σ9.678
min40.351
max69.243
op=vertical_lookup_list() repeated on unindexed missing Int
mean40.926
σ0.002
min40.925
max40.928
mean7385.000
σ0.000
min7385.000
max7385.000
mean22.422
σ2.134
min21.529
max27.680
op=vertical_lookup_row_list() on unindexed small unique Int
mean71.294
σ0.002
min71.292
max71.296
mean7385.000
σ0.000
min7385.000
max7385.000
mean255.209
σ558.800
min55.793
max1638.143

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean4646.842
σ0.013
min4646.837
max4646.875
mean4178.625
σ1944.534
min1483.000
max7385.000
mean3320.761
σ787.089
min2505.064
max4559.214
op=vertical_lookup_list() on indexed
mean1973.829
σ0.002
min1973.827
max1973.832
mean7385.000
σ0.000
min7385.000
max7385.000
mean981.797
σ130.510
min916.328
max1285.144
op=vertical_lookup_list() on unindexed missing Int, minor warmup
mean905.083
σ0.002
min905.080
max905.086
mean7385.000
σ0.000
min7385.000
max7385.000
mean393.967
σ9.026
min375.831
max409.170

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean148.144
σ0.001
min148.144
max148.148
mean477.000
σ0.000
min477.000
max477.000
mean374.218
σ29.781
min333.665
max432.743
op=pointedIndexFromKvs
rows=400000
mean308.493
σ0.001
min308.493
max308.497
mean563.000
σ0.000
min563.000
max563.000
mean760.315
σ49.939
min698.619
max840.094

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean964.570
σ1.881
min963.850
max972.527
mean1043.500
σ310.840
min593.000
max1518.000
mean1.275
σ0.139
min1.172
max1.807

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.390
σ0.501
min0.134
max1.283
name=error_case.art
mean2.346
σ0.012
min2.340
max2.368
mean402.000
σ0.000
min402.000
max402.000
mean0.476
σ0.326
min0.323
max1.059
name=heavy_item.art
mean1.523
σ0.002
min1.522
max1.526
mean402.000
σ0.000
min402.000
max402.000
mean0.218
σ0.021
min0.198
max0.252
name=nested_use.art
mean2.364
σ0.002
min2.363
max2.367
mean402.000
σ0.000
min402.000
max402.000
mean0.336
σ0.013
min0.326
max0.359

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.979
σ0.009
min964.974
max964.996
mean431.000
σ0.000
min431.000
max431.000
mean0.521
σ0.050
min0.480
max0.604
name=cdr_enhanced_4k_loc.art
mean886.001
σ0.002
min886.000
max886.004
mean431.000
σ0.000
min431.000
max431.000
mean0.461
σ0.049
min0.393
max0.523

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.719
σ0.002
min7.718
max7.722
mean431.000
σ0.000
min431.000
max431.000
mean1.960
σ0.064
min1.860
max2.206
name=record_render_large_syntax_err.art
mean7.667
σ0.002
min7.666
max7.670
mean431.000
σ0.000
min431.000
max431.000
mean1.946
σ0.060
min1.844
max2.146
name=record_render_success.art
mean2.290
σ0.002
min2.290
max2.294
mean431.000
σ0.000
min431.000
max431.000
mean0.304
σ0.008
min0.290
max0.351
name=record_render_syntax_err.art
mean2.166
σ0.002
min2.165
max2.169
mean431.000
σ0.000
min431.000
max431.000
mean0.291
σ0.009
min0.279
max0.341

Revision Creation

Factorallocated MiBpeak allocated MiBtime_s
number of threads=8
revision count=1000
mean11.864
σ11.432
min0.574
max88.730
mean465.735
σ17.856
min408.000
max479.000
mean0.027
σ0.028
min0.001
max0.208

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean279.109
σ1.100
min278.677
max282.233
mean442.900
σ15.538
min414.000
max467.000
mean0.580
σ0.018
min0.544
max0.593

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean169.257
σ0.000
min169.257
max169.257
mean851.000
σ0.000
min851.000
max851.000
mean186.818
σ18.348
min142.664
max198.320
phase=macro expansion
mean5.896
σ0.000
min5.896
max5.896
mean851.000
σ0.000
min851.000
max851.000
mean8.142
σ1.075
min6.844
max9.132
phase=parser
mean1042.131
σ0.000
min1042.131
max1042.131
mean851.000
σ0.000
min851.000
max851.000
mean541.639
σ88.465
min420.078
max611.624
phase=processProdDef
mean2243.746
σ0.000
min2243.746
max2243.746
mean851.000
σ0.000
min851.000
max851.000
mean2993.538
σ198.565
min2647.497
max3153.135
phase=renaming
mean21.440
σ0.000
min21.440
max21.440
mean851.000
σ0.000
min851.000
max851.000
mean45.177
σ4.441
min36.305
max48.245
phase=type checker
mean958.596
σ0.047
min958.573
max958.698
mean851.000
σ0.000
min851.000
max851.000
mean661.335
σ15.732
min640.375
max683.178

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean282.865
σ0.036
min282.814
max282.900
mean443.000
σ0.000
min443.000
max443.000
mean0.382
σ0.010
min0.373
max0.394
iters=5
new-facts=1
prior-facts=6402
mean1268.076
σ0.106
min1267.987
max1268.253
mean1086.400
σ171.711
min885.000
max1315.000
mean1.969
σ0.092
min1.855
max2.086
iters=5
new-facts=6402
prior-facts=1
mean1507.037
σ2.982
min1505.476
max1512.359
mean623.600
σ86.071
min495.000
max723.000
mean2.213
σ0.200
min2.076
max2.562
iters=5
new-facts=6402
prior-facts=6402
mean1830.077
σ0.048
min1830.004
max1830.121
mean1728.400
σ180.452
min1472.000
max1895.000
mean2.999
σ0.246
min2.848
max3.435

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.747
σ0.099
min1.629
max1.877

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean404.771
σ506.921
min151.308
max1165.154
mean101.750
σ7.500
min98.000
max113.000
mean440.000
σ0.000
min440.000
max440.000
mean0.500
σ0.502
min0.246
max1.252
policies=20
mean1513.244
σ0.269
min1513.069
max1513.643
mean980.000
σ0.000
min980.000
max980.000
mean443.500
σ4.041
min440.000
max447.000
mean2.503
σ0.017
min2.483
max2.517
policies=200
mean15140.945
σ0.072
min15140.839
max15140.999
mean9800.000
σ0.000
min9800.000
max9800.000
mean498.500
σ4.796
min493.000
max503.000
mean25.100
σ0.115
min24.954
max25.217