4bfe8117fcbaf0f16b01156fbdf60f1fd985d631

Home / Branches / tomaszwawreniuk/move-all-flat-instances-to-one-file / 4bfe8117fcbaf0f16b01156fbdf60f1fd985d631

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.618
σ0.351
min54.480
max55.615
mean416.000
σ0.000
min416.000
max416.000
mean0.143
σ0.005
min0.139
max0.151
cache=y
dps=1
iters=10
policies=100
mean43.785
σ0.007
min43.776
max43.796
mean416.000
σ0.000
min416.000
max416.000
mean0.124
σ0.004
min0.121
max0.131

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=column_set() on indexed
rows=200000
mean36.617
σ0.002
min36.615
max36.620
mean4285.750
σ1981.679
min1549.000
max7211.000
mean47.650
σ98.337
min12.600
max291.022
iterations=8
operation_display=column_set() on indexed, repeat
rows=200000
mean36.618
σ0.002
min36.616
max36.620
mean4285.750
σ1981.679
min1549.000
max7211.000
mean12.801
σ0.665
min11.957
max13.916
iterations=8
operation_display=table_records(), no indexes
rows=200000
mean41.930
σ0.002
min41.928
max41.933
mean7211.000
σ0.000
min7211.000
max7211.000
mean15.083
σ0.998
min13.064
max15.788
iterations=8
operation_display=table_records(), no indexes, repeat
rows=200000
mean41.929
σ0.002
min41.928
max41.932
mean7211.000
σ0.000
min7211.000
max7211.000
mean13.489
σ1.179
min11.077
max14.668
iterations=8
operation_display=table_records(), repeat
rows=200000
mean41.929
σ0.002
min41.927
max41.931
mean4170.375
σ1904.770
min1549.000
max7211.000
mean13.963
σ1.487
min11.039
max15.166
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records()
rows=200000
mean27.605
σ0.002
min27.603
max27.607
mean4170.375
σ1904.770
min1549.000
max7211.000
mean8.840
σ0.191
min8.498
max9.036
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.400
σ0.001
min26.399
max26.403
mean4170.375
σ1904.770
min1549.000
max7211.000
mean6.952
σ0.107
min6.822
max7.081
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.666
σ0.002
min25.665
max25.668
mean4285.750
σ1981.679
min1549.000
max7211.000
mean6.116
σ0.148
min5.888
max6.371
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.661
σ0.002
min25.659
max25.663
mean4285.750
σ1981.679
min1549.000
max7211.000
mean5.645
σ0.048
min5.592
max5.750
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.969
σ0.002
min25.967
max25.971
mean4285.750
σ1981.679
min1549.000
max7211.000
mean5.690
σ0.087
min5.580
max5.829
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.968
σ0.002
min25.967
max25.971
mean4285.750
σ1981.679
min1549.000
max7211.000
mean5.611
σ0.109
min5.475
max5.791

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=load_product(), no indexes
rows=200000
mean2524.596
σ0.002
min2524.594
max2524.599
mean7211.000
σ0.000
min7211.000
max7211.000
mean1362.446
σ462.288
min1056.680
max2246.825
iterations=8
operation_display=load_product(), with indexes
rows=200000
mean8744.560
σ0.041
min8744.545
max8744.662
mean3591.250
σ1818.604
min1075.000
max5823.000
mean4776.904
σ1475.362
min3558.518
max7156.218

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=column_set() on unindexed, dense
rows=200000
mean62.077
σ0.003
min62.076
max62.084
mean4170.375
σ1904.770
min1549.000
max7211.000
mean79.830
σ8.548
min71.247
max94.942
iterations=8
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.077
σ0.002
min62.076
max62.080
mean4170.375
σ1904.770
min1549.000
max7211.000
mean80.195
σ8.980
min71.337
max95.603
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int
rows=200000
mean40.945
σ0.002
min40.943
max40.949
mean7211.000
σ0.000
min7211.000
max7211.000
mean104.883
σ7.295
min90.614
max109.838
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int, repeat
rows=200000
mean40.945
σ0.002
min40.944
max40.947
mean7211.000
σ0.000
min7211.000
max7211.000
mean104.866
σ7.353
min90.412
max109.619
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end
rows=200000
mean40.950
σ0.002
min40.948
max40.954
mean7211.000
σ0.000
min7211.000
max7211.000
mean106.512
σ6.359
min96.008
max111.505
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat
rows=200000
mean40.950
σ0.002
min40.949
max40.953
mean7211.000
σ0.000
min7211.000
max7211.000
mean104.799
σ7.365
min90.415
max109.546
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int
rows=200000
mean66.687
σ0.003
min66.685
max66.694
mean7211.000
σ0.000
min7211.000
max7211.000
mean233.431
σ205.179
min142.033
max740.640
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat
rows=200000
mean66.686
σ0.001
min66.685
max66.689
mean7211.000
σ0.000
min7211.000
max7211.000
mean157.434
σ14.414
min129.969
max169.107

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=table_records()
rows=200000
mean11656.833
σ4.319
min11655.305
max11667.523
mean4170.375
σ1904.770
min1549.000
max7211.000
mean6840.666
σ1283.146
min4923.493
max8265.047
iterations=8
operation_display=vertical_lookup_list() on indexed
rows=200000
mean11560.065
σ0.002
min11560.064
max11560.069
mean7211.000
σ0.000
min7211.000
max7211.000
mean5483.549
σ1100.880
min4391.371
max6995.437

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=pointedIndexFromKvs
rows=200000
mean172.661
σ0.012
min172.640
max172.675
mean487.250
σ0.707
min487.000
max489.000
mean384.616
σ46.680
min275.536
max418.077
iterations=8
operation_display=pointedIndexFromKvs
rows=400000
mean357.457
σ0.147
min357.321
max357.642
mean571.000
σ0.000
min571.000
max571.000
mean776.673
σ68.763
min652.354
max873.685

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.083
σ0.762
min1007.608
max1011.231
mean7211.000
σ0.000
min7211.000
max7211.000
mean1.505
σ0.154
min1.386
max2.030

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.318
σ0.131
min0.246
max0.552
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.649
σ0.092
min0.590
max0.810
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.501
σ0.032
min0.448
max0.534
name=nested_use.art
mean2.356
σ0.002
min2.355
max2.358
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.860
σ0.030
min0.837
max0.911

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.553
σ0.031
min963.535
max963.607
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.806
σ0.034
min0.765
max0.857
name=cdr_enhanced_4k_loc.art
mean884.854
σ0.009
min884.847
max884.868
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.721
σ0.067
min0.602
max0.761

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean7211.000
σ0.000
min7211.000
max7211.000
mean4.304
σ0.076
min4.185
max4.610
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean7211.000
σ0.000
min7211.000
max7211.000
mean4.327
σ0.082
min4.223
max4.604
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.597
σ0.103
min0.515
max0.885
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.509
σ0.013
min0.485
max0.589

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.468
σ0.171
min297.289
max297.900
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.561
σ0.031
min0.510
max0.590

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.731
σ0.032
min289.684
max289.772
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.390
σ0.001
min0.390
max0.392
iters=5
new-facts=1
prior-facts=6402
mean1299.646
σ0.105
min1299.519
max1299.770
mean7211.000
σ0.000
min7211.000
max7211.000
mean1.916
σ0.056
min1.829
max1.978
iters=5
new-facts=6402
prior-facts=1
mean1542.620
σ4.057
min1540.564
max1549.869
mean7211.000
σ0.000
min7211.000
max7211.000
mean2.324
σ0.190
min2.094
max2.552
iters=5
new-facts=6402
prior-facts=6402
mean1861.598
σ0.066
min1861.507
max1861.649
mean7211.000
σ0.000
min7211.000
max7211.000
mean2.964
σ0.094
min2.879
max3.069

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.483
σ0.249
min1.282
max1.801

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.148
σ577.064
min157.612
max1311.744
mean96.250
σ8.500
min92.000
max109.000
mean7211.000
σ0.000
min7211.000
max7211.000
mean0.559
σ0.581
min0.267
max1.430
policies=20
mean1576.419
σ0.346
min1576.177
max1576.931
mean920.000
σ0.000
min920.000
max920.000
mean7211.000
σ0.000
min7211.000
max7211.000
mean2.621
σ0.022
min2.598
max2.641
policies=200
mean15772.310
σ0.075
min15772.218
max15772.403
mean9200.000
σ0.000
min9200.000
max9200.000
mean7211.000
σ0.000
min7211.000
max7211.000
mean26.625
σ0.133
min26.474
max26.774