e0ef0663af98a145a63cfe4a38df46669c887189

Home / Branches / federicoroffi/exp-1530-frontend-support-for-inviting-users-in-bulk / e0ef0663af98a145a63cfe4a38df46669c887189

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.618
σ0.351
min54.483
max55.616
mean415.000
σ0.000
min415.000
max415.000
mean0.138
σ0.005
min0.132
max0.146
cache=y
dps=1
iters=10
policies=100
mean43.785
σ0.006
min43.779
max43.798
mean415.000
σ0.000
min415.000
max415.000
mean0.122
σ0.004
min0.119
max0.130

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4089.375
σ1586.689
min1890.000
max6041.000
mean12.019
σ0.399
min11.613
max12.741
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.615
max36.619
mean4089.375
σ1586.689
min1890.000
max6041.000
mean11.217
σ0.150
min10.996
max11.485
op=table_records(), no indexes
mean41.928
σ0.000
min41.928
max41.929
mean6041.000
σ0.000
min6041.000
max6041.000
mean13.234
σ1.130
min11.060
max14.906
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.932
mean4089.375
σ1586.689
min1890.000
max6041.000
mean12.236
σ1.859
min10.271
max14.411
op=vertical_lookup_list() on indexed, after table_records()
mean27.604
σ0.002
min27.603
max27.607
mean4089.375
σ1586.689
min1890.000
max6041.000
mean8.114
σ0.281
min7.760
max8.557
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4089.375
σ1586.689
min1890.000
max6041.000
mean6.051
σ0.358
min5.537
max6.653
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.670
mean4089.375
σ1586.689
min1890.000
max6041.000
mean5.187
σ0.177
min4.974
max5.481
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.971
mean4089.375
σ1586.689
min1890.000
max6041.000
mean4.987
σ0.153
min4.760
max5.213

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.593
σ0.000
min2524.593
max2524.594
mean6041.000
σ0.000
min6041.000
max6041.000
mean1440.812
σ625.391
min1045.781
max2704.363
op=load_product(), with indexes
mean8744.559
σ0.033
min8744.544
max8744.641
mean3797.750
σ1676.607
min1890.000
max6041.000
mean4624.437
σ1476.191
min3555.135
max7280.586

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.080
mean4089.375
σ1586.689
min1890.000
max6041.000
mean80.618
σ11.292
min69.711
max101.029
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.002
min40.943
max40.949
mean6041.000
σ0.000
min6041.000
max6041.000
mean97.087
σ9.054
min84.252
max108.390
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.686
mean6041.000
σ0.000
min6041.000
max6041.000
mean228.993
σ235.166
min127.583
max810.060

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.318
min11655.305
max11667.521
mean4089.375
σ1586.689
min1890.000
max6041.000
mean6349.986
σ1228.679
min4965.952
max8421.462
op=vertical_lookup_list() on indexed
mean11560.069
σ0.001
min11560.066
max11560.069
mean6041.000
σ0.000
min6041.000
max6041.000
mean6734.869
σ1478.364
min4431.636
max8227.745

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.585
σ0.022
min172.558
max172.621
mean1890.000
σ0.000
min1890.000
max1890.000
mean353.839
σ29.934
min291.427
max391.767
op=pointedIndexFromKvs
rows=400000
mean357.358
σ0.035
min357.321
max357.406
mean1890.000
σ0.000
min1890.000
max1890.000
mean755.574
σ58.611
min620.056
max796.550

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.181
σ0.923
min1007.716
max1012.019
mean1038.750
σ307.942
min542.000
max1471.000
mean1.592
σ0.146
min1.427
max1.926

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean1471.000
σ0.000
min1471.000
max1471.000
mean0.439
σ0.184
min0.333
max0.767
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean1471.000
σ0.000
min1471.000
max1471.000
mean0.924
σ0.163
min0.838
max1.214
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean1471.000
σ0.000
min1471.000
max1471.000
mean0.542
σ0.049
min0.499
max0.625
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean1471.000
σ0.000
min1471.000
max1471.000
mean0.834
σ0.041
min0.790
max0.898

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.551
σ0.037
min963.527
max963.617
mean1471.000
σ0.000
min1471.000
max1471.000
mean0.809
σ0.054
min0.728
max0.863
name=cdr_enhanced_4k_loc.art
mean884.853
σ0.009
min884.847
max884.867
mean1471.000
σ0.000
min1471.000
max1471.000
mean0.728
σ0.021
min0.706
max0.747

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.711
mean1471.000
σ0.000
min1471.000
max1471.000
mean3.565
σ0.118
min3.410
max4.028
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean1471.000
σ0.000
min1471.000
max1471.000
mean3.509
σ0.066
min3.419
max3.747
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean1471.000
σ0.000
min1471.000
max1471.000
mean0.753
σ0.017
min0.721
max0.858
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean1471.000
σ0.000
min1471.000
max1471.000
mean0.715
σ0.015
min0.692
max0.802

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.494
σ0.203
min297.320
max298.021
mean1890.000
σ0.000
min1890.000
max1890.000
mean0.599
σ0.018
min0.574
max0.625

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.769
σ0.032
min289.728
max289.803
mean1471.000
σ0.000
min1471.000
max1471.000
mean0.398
σ0.015
min0.378
max0.421
iters=5
new-facts=1
prior-facts=6402
mean1299.664
σ0.087
min1299.560
max1299.779
mean1471.000
σ0.000
min1471.000
max1471.000
mean2.078
σ0.068
min2.003
max2.161
iters=5
new-facts=6402
prior-facts=1
mean1542.610
σ4.040
min1540.603
max1549.828
mean1471.000
σ0.000
min1471.000
max1471.000
mean2.233
σ0.123
min2.119
max2.415
iters=5
new-facts=6402
prior-facts=6402
mean1861.623
σ0.082
min1861.495
max1861.701
mean1735.200
σ165.380
min1501.000
max1890.000
mean3.077
σ0.246
min2.866
max3.478

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.578
σ0.140
min1.428
max1.742

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.186
σ577.140
min157.615
max1311.896
mean96.250
σ8.500
min92.000
max109.000
mean1471.000
σ0.000
min1471.000
max1471.000
mean0.536
σ0.539
min0.263
max1.346
policies=20
mean1576.417
σ0.345
min1576.186
max1576.930
mean920.000
σ0.000
min920.000
max920.000
mean1471.000
σ0.000
min1471.000
max1471.000
mean2.621
σ0.004
min2.618
max2.626
policies=200
mean15772.208
σ0.120
min15772.088
max15772.346
mean9200.000
σ0.000
min9200.000
max9200.000
mean1471.000
σ0.000
min1471.000
max1471.000
mean26.499
σ0.078
min26.406
max26.597