fdd7e6bdfcc2db46d0d1289c49d28051d78ec3dc

Home / Branches / rebeccamurta/sol-939-add-multi-select-table-cells / fdd7e6bdfcc2db46d0d1289c49d28051d78ec3dc

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.618
σ0.350
min54.477
max55.614
mean417.000
σ0.000
min417.000
max417.000
mean0.139
σ0.004
min0.135
max0.144
cache=y
dps=1
iters=10
policies=100
mean43.787
σ0.006
min43.777
max43.795
mean417.000
σ0.000
min417.000
max417.000
mean0.122
σ0.003
min0.119
max0.127

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4277.000
σ1866.541
min2068.000
max7553.000
mean12.432
σ0.337
min11.970
max13.020
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.615
max36.619
mean4277.000
σ1866.541
min2068.000
max7553.000
mean12.032
σ0.597
min11.370
max12.775
op=table_records(), no indexes
mean41.929
σ0.000
min41.928
max41.929
mean7553.000
σ0.000
min7553.000
max7553.000
mean13.949
σ1.718
min12.113
max17.343
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4277.000
σ1866.541
min2068.000
max7553.000
mean11.574
σ1.436
min10.342
max13.859
op=vertical_lookup_list() on indexed, after table_records()
mean27.605
σ0.002
min27.603
max27.607
mean4277.000
σ1866.541
min2068.000
max7553.000
mean8.324
σ0.426
min7.835
max9.067
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.399
max26.403
mean4277.000
σ1866.541
min2068.000
max7553.000
mean6.461
σ0.284
min5.785
max6.661
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.665
max25.670
mean4277.000
σ1866.541
min2068.000
max7553.000
mean5.539
σ0.073
min5.440
max5.661
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.969
σ0.002
min25.967
max25.972
mean4277.000
σ1866.541
min2068.000
max7553.000
mean5.322
σ0.055
min5.244
max5.428

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.594
σ0.000
min2524.594
max2524.594
mean7553.000
σ0.000
min7553.000
max7553.000
mean1046.969
σ8.084
min1034.184
max1058.021
op=load_product(), with indexes
mean8744.558
σ0.033
min8744.545
max8744.639
mean3811.375
σ1582.239
min2068.000
max5951.000
mean4380.883
σ1281.784
min3526.331
max6972.436

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.077
σ0.002
min62.076
max62.080
mean4277.000
σ1866.541
min2068.000
max7553.000
mean84.684
σ10.487
min71.511
max99.159
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean7553.000
σ0.000
min7553.000
max7553.000
mean240.243
σ390.589
min88.872
max1206.732
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean7553.000
σ0.000
min7553.000
max7553.000
mean152.741
σ12.795
min139.217
max167.705

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.317
min11655.305
max11667.517
mean4277.000
σ1866.541
min2068.000
max7553.000
mean6241.229
σ1178.448
min4929.260
max8124.833
op=vertical_lookup_list() on indexed
mean11560.068
σ0.001
min11560.066
max11560.069
mean7553.000
σ0.000
min7553.000
max7553.000
mean5466.496
σ1364.610
min4360.764
max7445.373

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.588
σ0.026
min172.558
max172.618
mean2068.000
σ0.000
min2068.000
max2068.000
mean350.064
σ41.195
min313.491
max442.283
op=pointedIndexFromKvs
rows=400000
mean357.369
σ0.046
min357.321
max357.422
mean2068.000
σ0.000
min2068.000
max2068.000
mean782.418
σ22.036
min734.481
max811.699

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.188
σ0.877
min1007.691
max1011.817
mean1043.950
σ293.081
min550.000
max1440.000
mean1.534
σ0.077
min1.463
max1.777

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean1440.000
σ0.000
min1440.000
max1440.000
mean0.414
σ0.121
min0.333
max0.626
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean1440.000
σ0.000
min1440.000
max1440.000
mean0.868
σ0.079
min0.805
max1.006
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean1440.000
σ0.000
min1440.000
max1440.000
mean0.525
σ0.045
min0.493
max0.599
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean1440.000
σ0.000
min1440.000
max1440.000
mean0.832
σ0.042
min0.800
max0.905

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.548
σ0.035
min963.528
max963.611
mean1440.000
σ0.000
min1440.000
max1440.000
mean0.802
σ0.042
min0.739
max0.852
name=cdr_enhanced_4k_loc.art
mean884.853
σ0.007
min884.847
max884.864
mean1440.000
σ0.000
min1440.000
max1440.000
mean0.724
σ0.030
min0.687
max0.746

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.712
mean1440.000
σ0.000
min1440.000
max1440.000
mean4.266
σ0.091
min4.129
max4.633
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean1440.000
σ0.000
min1440.000
max1440.000
mean4.253
σ0.071
min4.104
max4.466
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean1440.000
σ0.000
min1440.000
max1440.000
mean0.749
σ0.017
min0.712
max0.848
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean1440.000
σ0.000
min1440.000
max1440.000
mean0.716
σ0.016
min0.683
max0.779

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.643
σ0.191
min297.484
max298.147
mean2068.000
σ0.000
min2068.000
max2068.000
mean0.570
σ0.037
min0.513
max0.608

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.774
σ0.035
min289.725
max289.808
mean1440.000
σ0.000
min1440.000
max1440.000
mean0.400
σ0.009
min0.395
max0.416
iters=5
new-facts=1
prior-facts=6402
mean1299.627
σ0.116
min1299.500
max1299.774
mean1440.000
σ0.000
min1440.000
max1440.000
mean1.878
σ0.096
min1.807
max2.013
iters=5
new-facts=6402
prior-facts=1
mean1542.626
σ4.048
min1540.568
max1549.861
mean1440.000
σ0.000
min1440.000
max1440.000
mean2.237
σ0.228
min2.052
max2.626
iters=5
new-facts=6402
prior-facts=6402
mean1861.635
σ0.044
min1861.577
max1861.676
mean1722.200
σ245.696
min1440.000
max2068.000
mean2.948
σ0.145
min2.820
max3.173

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.645
σ0.286
min1.178
max1.876

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.146
σ577.063
min157.615
max1311.741
mean96.250
σ8.500
min92.000
max109.000
mean1440.000
σ0.000
min1440.000
max1440.000
mean0.557
σ0.571
min0.267
max1.414
policies=20
mean1576.432
σ0.353
min1576.191
max1576.956
mean920.000
σ0.000
min920.000
max920.000
mean1440.000
σ0.000
min1440.000
max1440.000
mean2.626
σ0.009
min2.619
max2.638
policies=200
mean15772.284
σ0.403
min15771.700
max15772.624
mean9200.000
σ0.000
min9200.000
max9200.000
mean1440.000
σ0.000
min1440.000
max1440.000
mean26.419
σ0.082
min26.327
max26.492