f36b1dcd896981de3749864e397ec278d9d807a8

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

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.616
σ0.352
min54.478
max55.616
mean418.000
σ0.000
min418.000
max418.000
mean0.138
σ0.006
min0.130
max0.147
cache=y
dps=1
iters=10
policies=100
mean43.785
σ0.006
min43.776
max43.798
mean418.000
σ0.000
min418.000
max418.000
mean0.123
σ0.003
min0.120
max0.128

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.003
min36.615
max36.623
mean4107.250
σ1571.951
min1973.000
max6051.000
mean12.417
σ0.177
min12.116
max12.612
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.615
max36.619
mean4107.250
σ1571.951
min1973.000
max6051.000
mean12.192
σ0.641
min11.372
max13.094
op=table_records(), no indexes
mean41.928
σ0.000
min41.928
max41.929
mean6051.000
σ0.000
min6051.000
max6051.000
mean13.366
σ1.117
min11.252
max14.925
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4107.250
σ1571.951
min1973.000
max6051.000
mean12.747
σ2.055
min10.311
max15.230
op=vertical_lookup_list() on indexed, after table_records()
mean27.605
σ0.002
min27.603
max27.607
mean4107.250
σ1571.951
min1973.000
max6051.000
mean8.846
σ1.280
min7.805
max11.875
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4107.250
σ1571.951
min1973.000
max6051.000
mean6.933
σ1.027
min6.235
max9.413
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.670
mean4107.250
σ1571.951
min1973.000
max6051.000
mean5.519
σ0.066
min5.381
max5.582
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.971
mean4107.250
σ1571.951
min1973.000
max6051.000
mean5.294
σ0.236
min4.725
max5.458

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.594
σ0.001
min2524.593
max2524.597
mean6051.000
σ0.000
min6051.000
max6051.000
mean1472.355
σ675.656
min1028.058
max2607.703
op=load_product(), with indexes
mean8744.559
σ0.033
min8744.544
max8744.641
mean3824.375
σ1653.325
min1973.000
max6051.000
mean4394.566
σ1215.926
min3518.673
max6739.720

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.080
mean4107.250
σ1571.951
min1973.000
max6051.000
mean83.394
σ17.512
min70.615
max121.708
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean6051.000
σ0.000
min6051.000
max6051.000
mean94.048
σ10.976
min73.697
max106.777
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean6051.000
σ0.000
min6051.000
max6051.000
mean227.037
σ241.336
min110.584
max822.790

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.318
min11655.305
max11667.521
mean4107.250
σ1571.951
min1973.000
max6051.000
mean6187.664
σ1293.909
min4904.547
max7861.776
op=vertical_lookup_list() on indexed
mean11560.069
σ0.001
min11560.066
max11560.069
mean6051.000
σ0.000
min6051.000
max6051.000
mean6429.007
σ1168.088
min4398.251
max7804.055

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.583
σ0.024
min172.558
max172.619
mean1973.000
σ0.000
min1973.000
max1973.000
mean352.560
σ52.832
min261.727
max409.684
op=pointedIndexFromKvs
rows=400000
mean357.362
σ0.040
min357.321
max357.405
mean1973.000
σ0.000
min1973.000
max1973.000
mean783.061
σ24.291
min732.768
max806.227

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.185
σ0.886
min1007.685
max1011.865
mean1052.650
σ313.439
min568.000
max1515.000
mean1.551
σ0.083
min1.419
max1.770

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean1515.000
σ0.000
min1515.000
max1515.000
mean0.440
σ0.174
min0.336
max0.750
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean1515.000
σ0.000
min1515.000
max1515.000
mean0.929
σ0.175
min0.819
max1.238
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean1515.000
σ0.000
min1515.000
max1515.000
mean0.540
σ0.049
min0.502
max0.623
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean1515.000
σ0.000
min1515.000
max1515.000
mean0.841
σ0.044
min0.798
max0.904

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.549
σ0.030
min963.528
max963.602
mean1515.000
σ0.000
min1515.000
max1515.000
mean0.759
σ0.083
min0.656
max0.853
name=cdr_enhanced_4k_loc.art
mean884.854
σ0.007
min884.847
max884.863
mean1515.000
σ0.000
min1515.000
max1515.000
mean0.717
σ0.037
min0.658
max0.743

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean1515.000
σ0.000
min1515.000
max1515.000
mean4.276
σ0.099
min4.138
max4.706
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.659
mean1515.000
σ0.000
min1515.000
max1515.000
mean4.259
σ0.085
min4.084
max4.496
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean1515.000
σ0.000
min1515.000
max1515.000
mean0.750
σ0.018
min0.717
max0.841
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean1515.000
σ0.000
min1515.000
max1515.000
mean0.717
σ0.019
min0.628
max0.810

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.479
σ0.188
min297.342
max297.993
mean1973.000
σ0.000
min1973.000
max1973.000
mean0.588
σ0.026
min0.548
max0.633

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.767
σ0.040
min289.722
max289.810
mean1515.000
σ0.000
min1515.000
max1515.000
mean0.400
σ0.011
min0.394
max0.419
iters=5
new-facts=1
prior-facts=6402
mean1299.647
σ0.075
min1299.555
max1299.720
mean1515.000
σ0.000
min1515.000
max1515.000
mean2.089
σ0.062
min2.012
max2.162
iters=5
new-facts=6402
prior-facts=1
mean1542.630
σ4.015
min1540.597
max1549.804
mean1515.000
σ0.000
min1515.000
max1515.000
mean2.279
σ0.200
min2.099
max2.597
iters=5
new-facts=6402
prior-facts=6402
mean1861.632
σ0.077
min1861.515
max1861.715
mean1773.800
σ206.478
min1515.000
max1973.000
mean3.272
σ0.413
min2.850
max3.752

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.643
σ0.201
min1.338
max1.830

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.185
σ577.139
min157.613
max1311.894
mean96.250
σ8.500
min92.000
max109.000
mean1515.000
σ0.000
min1515.000
max1515.000
mean0.540
σ0.553
min0.262
max1.369
policies=20
mean1576.414
σ0.350
min1576.175
max1576.934
mean920.000
σ0.000
min920.000
max920.000
mean1515.000
σ0.000
min1515.000
max1515.000
mean2.616
σ0.022
min2.587
max2.640
policies=200
mean15772.219
σ0.078
min15772.121
max15772.313
mean9200.000
σ0.000
min9200.000
max9200.000
mean1515.000
σ0.000
min1515.000
max1515.000
mean26.482
σ0.038
min26.440
max26.528