1479d9076ce432831f56298049aa10dbcc9c1fe9

Home / Branches / sergeiwinitzki/lang-99-use-prepared-statement-when-inserting-binary-data / 1479d9076ce432831f56298049aa10dbcc9c1fe9

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
mean4.863
σ0.000
min4.863
max4.863

AST compact size (processProdDef)

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

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.701
σ0.367
min54.563
max55.746
mean415.000
σ0.000
min415.000
max415.000
mean0.141
σ0.004
min0.136
max0.147
cache=y
dps=1
iters=10
policies=100
mean43.778
σ0.007
min43.770
max43.792
mean415.000
σ0.000
min415.000
max415.000
mean0.122
σ0.005
min0.116
max0.130

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.605
σ0.000
min36.605
max36.606
mean4590.750
σ2250.110
min1486.000
max7388.000
mean176.057
σ461.095
min11.926
max1317.199
op=column_set() on indexed, repeat
mean36.605
σ0.000
min36.605
max36.605
mean4590.750
σ2250.110
min1486.000
max7388.000
mean14.564
σ4.454
min11.593
max24.767
op=table_records(), no indexes
mean41.940
σ0.002
min41.938
max41.943
mean7388.000
σ0.000
min7388.000
max7388.000
mean11.116
σ0.212
min10.887
max11.493
op=table_records(), repeat
mean41.925
σ0.001
min41.925
max41.929
mean4180.125
σ1945.887
min1486.000
max7388.000
mean11.627
σ1.966
min10.686
max16.477
op=vertical_lookup_list() on indexed, after table_records()
mean27.634
σ0.137
min27.585
max27.972
mean4180.125
σ1945.887
min1486.000
max7388.000
mean9.119
σ1.383
min7.982
max12.470
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.385
σ0.000
min26.385
max26.385
mean4180.125
σ1945.887
min1486.000
max7388.000
mean7.087
σ0.919
min6.486
max9.313
op=vertical_lookup_row_list() on 2 indexed
mean25.663
σ0.004
min25.662
max25.674
mean4590.750
σ2250.110
min1486.000
max7388.000
mean6.566
σ1.076
min5.891
max9.017
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.962
σ0.001
min25.962
max25.964
mean4590.750
σ2250.110
min1486.000
max7388.000
mean6.408
σ1.024
min5.717
max8.591

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean1021.599
σ0.002
min1021.597
max1021.602
mean7388.000
σ0.000
min7388.000
max7388.000
mean363.523
σ42.499
min345.893
max468.657
op=load_product(), with indexes
mean3495.846
σ0.454
min3495.685
max3496.968
mean3757.250
σ2300.350
min720.000
max7388.000
mean1761.358
σ678.636
min1388.633
max2952.102

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense, minor warmup
mean107.841
σ0.000
min107.841
max107.842
mean4409.625
σ2219.794
min1486.000
max7388.000
mean247.726
σ317.137
min127.124
max1031.648
op=column_set() on unindexed, dense, repeat
mean62.069
σ0.001
min62.065
max62.069
mean4409.625
σ2219.794
min1486.000
max7388.000
mean45.898
σ7.493
min41.518
max64.096
op=vertical_lookup_list() repeated on unindexed missing Int
mean40.927
σ0.002
min40.926
max40.930
mean7388.000
σ0.000
min7388.000
max7388.000
mean22.845
σ2.865
min21.394
max29.896
op=vertical_lookup_row_list() on unindexed small unique Int
mean71.294
σ0.002
min71.293
max71.297
mean7388.000
σ0.000
min7388.000
max7388.000
mean223.293
σ468.840
min55.803
max1383.587

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean4646.842
σ0.014
min4646.837
max4646.876
mean4180.125
σ1945.887
min1486.000
max7388.000
mean3332.592
σ749.532
min2511.782
max4520.533
op=vertical_lookup_list() on indexed
mean1973.830
σ0.002
min1973.829
max1973.833
mean7388.000
σ0.000
min7388.000
max7388.000
mean1100.167
σ326.446
min928.548
max1881.733
op=vertical_lookup_list() on unindexed missing Int, minor warmup
mean905.084
σ0.002
min905.082
max905.087
mean7388.000
σ0.000
min7388.000
max7388.000
mean406.381
σ45.413
min377.466
max517.895

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean148.144
σ0.001
min148.144
max148.148
mean479.000
σ1.852
min476.000
max480.000
mean377.617
σ31.316
min327.083
max421.354
op=pointedIndexFromKvs
rows=400000
mean308.493
σ0.001
min308.493
max308.497
mean561.250
σ1.389
min559.000
max562.000
mean767.324
σ33.587
min734.121
max826.384

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean964.527
σ1.881
min963.806
max972.484
mean1053.600
σ329.097
min554.000
max1543.000
mean1.295
σ0.144
min1.183
max1.730

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.298
σ0.294
min0.143
max0.820
name=error_case.art
mean2.346
σ0.012
min2.340
max2.368
mean402.000
σ0.000
min402.000
max402.000
mean0.477
σ0.329
min0.316
max1.064
name=heavy_item.art
mean1.523
σ0.002
min1.522
max1.526
mean402.000
σ0.000
min402.000
max402.000
mean0.217
σ0.020
min0.202
max0.251
name=nested_use.art
mean2.364
σ0.002
min2.363
max2.367
mean402.000
σ0.000
min402.000
max402.000
mean0.338
σ0.021
min0.319
max0.372

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.978
σ0.009
min964.973
max964.995
mean431.000
σ0.000
min431.000
max431.000
mean0.593
σ0.015
min0.570
max0.610
name=cdr_enhanced_4k_loc.art
mean886.000
σ0.002
min885.999
max886.003
mean431.000
σ0.000
min431.000
max431.000
mean0.467
σ0.029
min0.424
max0.492

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
mean2.627
σ0.104
min2.453
max2.892
name=record_render_large_syntax_err.art
mean7.667
σ0.002
min7.666
max7.670
mean431.000
σ0.000
min431.000
max431.000
mean2.574
σ0.072
min2.444
max2.816
name=record_render_success.art
mean2.290
σ0.002
min2.290
max2.294
mean431.000
σ0.000
min431.000
max431.000
mean0.307
σ0.008
min0.292
max0.359
name=record_render_syntax_err.art
mean2.166
σ0.002
min2.165
max2.169
mean431.000
σ0.000
min431.000
max431.000
mean0.307
σ0.066
min0.281
max0.802

Revision Creation

Factorallocated MiBpeak allocated MiBtime_s
number of threads=8
revision count=1000
mean11.711
σ12.660
min0.574
max101.390
mean453.136
σ16.879
min406.000
max468.000
mean0.027
σ0.031
min0.001
max0.239

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean279.191
σ1.094
min278.682
max282.292
mean443.500
σ18.513
min413.000
max465.000
mean0.584
σ0.015
min0.559
max0.620

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean106.546
σ0.000
min106.546
max106.546
mean694.000
σ0.000
min694.000
max694.000
mean149.213
σ7.767
min141.995
max160.953
phase=macro expansion
mean5.894
σ0.000
min5.894
max5.894
mean694.000
σ0.000
min694.000
max694.000
mean8.063
σ1.103
min6.980
max9.229
phase=parser
mean1042.130
σ0.000
min1042.130
max1042.131
mean694.000
σ0.000
min694.000
max694.000
mean530.048
σ93.193
min439.199
max621.074
phase=processProdDef
mean2241.195
σ0.000
min2241.195
max2241.195
mean694.000
σ0.000
min694.000
max694.000
mean3063.255
σ134.414
min2771.220
max3193.948
phase=renaming
mean21.433
σ0.000
min21.433
max21.433
mean694.000
σ0.000
min694.000
max694.000
mean42.716
σ4.638
min36.223
max47.827
phase=type checker
mean958.462
σ0.047
min958.439
max958.564
mean694.000
σ0.000
min694.000
max694.000
mean660.145
σ14.814
min628.334
max680.711

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean282.830
σ0.038
min282.776
max282.869
mean437.800
σ5.675
min432.000
max445.000
mean0.376
σ0.006
min0.372
max0.387
iters=5
new-facts=1
prior-facts=6402
mean1268.030
σ0.111
min1267.932
max1268.212
mean1089.800
σ178.661
min862.000
max1304.000
mean1.957
σ0.137
min1.786
max2.119
iters=5
new-facts=6402
prior-facts=1
mean1507.010
σ2.912
min1505.483
max1512.204
mean632.400
σ68.901
min538.000
max717.000
mean2.237
σ0.206
min2.071
max2.587
iters=5
new-facts=6402
prior-facts=6402
mean1830.030
σ0.051
min1829.965
max1830.081
mean1727.800
σ182.238
min1469.000
max1896.000
mean3.004
σ0.279
min2.835
max3.500

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.615
σ0.133
min1.386
max1.712

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean405.896
σ509.286
min151.251
max1169.825
mean101.750
σ7.500
min98.000
max113.000
mean436.000
σ0.000
min436.000
max436.000
mean0.503
σ0.497
min0.250
max1.249
policies=20
mean1512.664
σ0.241
min1512.501
max1513.019
mean980.000
σ0.000
min980.000
max980.000
mean446.750
σ10.751
min436.000
max456.000
mean2.467
σ0.009
min2.455
max2.476
policies=200
mean15135.220
σ0.181
min15135.046
max15135.472
mean9800.000
σ0.000
min9800.000
max9800.000
mean496.750
σ3.594
min492.000
max500.000
mean24.954
σ0.114
min24.786
max25.037