1a5fad0291488b192d1fa07ab549565be5e079bf

Home / Branches / tomaszwawreniuk/product-cache-in-redis / 1a5fad0291488b192d1fa07ab549565be5e079bf

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean53.797
σ0.349
min53.659
max54.791
mean415.000
σ0.000
min415.000
max415.000
mean0.133
σ0.005
min0.129
max0.144
cache=y
dps=1
iters=10
policies=100
mean43.079
σ0.007
min43.070
max43.090
mean415.000
σ0.000
min415.000
max415.000
mean0.120
σ0.003
min0.117
max0.126

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=column_set() on indexed
rows=200000
mean36.618
σ0.002
min36.615
max36.620
mean4167.125
σ1902.163
min1547.000
max7198.000
mean12.765
σ0.279
min12.409
max13.247
iterations=8
operation_display=column_set() on indexed, repeat
rows=200000
mean36.617
σ0.002
min36.616
max36.619
mean4286.625
σ1981.919
min1547.000
max7198.000
mean96.246
σ238.126
min11.716
max685.577
iterations=8
operation_display=table_records(), no indexes
rows=200000
mean41.929
σ0.002
min41.928
max41.932
mean7198.000
σ0.000
min7198.000
max7198.000
mean14.650
σ1.159
min12.145
max15.348
iterations=8
operation_display=table_records(), no indexes, repeat
rows=200000
mean41.930
σ0.002
min41.928
max41.932
mean7198.000
σ0.000
min7198.000
max7198.000
mean13.192
σ1.306
min11.087
max14.607
iterations=8
operation_display=table_records(), repeat
rows=200000
mean41.929
σ0.002
min41.927
max41.931
mean4167.125
σ1902.163
min1547.000
max7198.000
mean13.482
σ1.669
min10.800
max15.014
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records()
rows=200000
mean27.604
σ0.002
min27.603
max27.607
mean4167.125
σ1902.163
min1547.000
max7198.000
mean8.838
σ0.274
min8.301
max9.147
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.400
σ0.001
min26.399
max26.403
mean4167.125
σ1902.163
min1547.000
max7198.000
mean6.799
σ0.466
min5.740
max7.129
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.667
σ0.002
min25.665
max25.670
mean4286.625
σ1981.919
min1547.000
max7198.000
mean6.053
σ0.630
min5.667
max7.587
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.661
σ0.002
min25.659
max25.663
mean4286.625
σ1981.919
min1547.000
max7198.000
mean5.773
σ0.563
min5.401
max7.132
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.969
σ0.002
min25.967
max25.971
mean4286.625
σ1981.919
min1547.000
max7198.000
mean5.809
σ0.603
min5.039
max7.165
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.968
σ0.001
min25.967
max25.971
mean4286.625
σ1981.919
min1547.000
max7198.000
mean5.706
σ0.610
min5.162
max7.166

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.598
mean7198.000
σ0.000
min7198.000
max7198.000
mean1180.915
σ387.895
min1035.561
max2140.782
iterations=8
operation_display=load_product(), with indexes
rows=200000
mean8744.561
σ0.042
min8744.545
max8744.664
mean3593.500
σ1823.357
min1071.000
max5839.000
mean4708.166
σ1556.281
min3521.608
max7359.405

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=column_set() on unindexed, dense
rows=200000
mean62.077
σ0.002
min62.076
max62.081
mean4167.125
σ1902.163
min1547.000
max7198.000
mean77.722
σ5.613
min71.126
max86.255
iterations=8
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.078
σ0.003
min62.075
max62.084
mean4167.125
σ1902.163
min1547.000
max7198.000
mean78.111
σ5.620
min71.122
max86.722
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int
rows=200000
mean40.944
σ0.001
min40.943
max40.947
mean7198.000
σ0.000
min7198.000
max7198.000
mean101.277
σ11.629
min75.221
max108.112
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int, repeat
rows=200000
mean40.946
σ0.002
min40.944
max40.948
mean7198.000
σ0.000
min7198.000
max7198.000
mean101.562
σ11.278
min76.280
max108.509
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end
rows=200000
mean40.950
σ0.002
min40.949
max40.953
mean7198.000
σ0.000
min7198.000
max7198.000
mean104.061
σ11.151
min81.338
max112.702
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat
rows=200000
mean40.951
σ0.002
min40.948
max40.954
mean7198.000
σ0.000
min7198.000
max7198.000
mean101.603
σ11.574
min75.857
max108.654
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int
rows=200000
mean66.686
σ0.001
min66.686
max66.689
mean7198.000
σ0.000
min7198.000
max7198.000
mean205.996
σ141.054
min120.711
max552.816
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat
rows=200000
mean66.687
σ0.002
min66.685
max66.689
mean7198.000
σ0.000
min7198.000
max7198.000
mean151.388
σ22.626
min113.203
max168.450

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=table_records()
rows=200000
mean11656.833
σ4.318
min11655.305
max11667.519
mean4167.125
σ1902.163
min1547.000
max7198.000
mean6964.718
σ1189.997
min4928.852
max7998.789
iterations=8
operation_display=vertical_lookup_list() on indexed
rows=200000
mean11560.065
σ0.001
min11560.064
max11560.068
mean7198.000
σ0.000
min7198.000
max7198.000
mean5814.967
σ1668.408
min4357.250
max8669.926

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=pointedIndexFromKvs
rows=200000
mean172.664
σ0.009
min172.646
max172.675
mean485.000
σ0.000
min485.000
max485.000
mean388.092
σ25.476
min347.392
max420.864
iterations=8
operation_display=pointedIndexFromKvs
rows=400000
mean357.469
σ0.158
min357.321
max357.642
mean561.000
σ0.000
min561.000
max561.000
mean781.075
σ34.173
min719.503
max819.952

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1005.002
σ0.751
min1004.532
max1008.107
mean7198.000
σ0.000
min7198.000
max7198.000
mean1.598
σ0.124
min1.479
max1.865

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean7198.000
σ0.000
min7198.000
max7198.000
mean0.334
σ0.171
min0.243
max0.639
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean7198.000
σ0.000
min7198.000
max7198.000
mean0.675
σ0.167
min0.574
max0.971
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean7198.000
σ0.000
min7198.000
max7198.000
mean0.387
σ0.034
min0.363
max0.445
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean7198.000
σ0.000
min7198.000
max7198.000
mean0.648
σ0.093
min0.578
max0.805

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.543
σ0.026
min963.523
max963.585
mean7198.000
σ0.000
min7198.000
max7198.000
mean0.798
σ0.059
min0.708
max0.861
name=cdr_enhanced_4k_loc.art
mean884.854
σ0.006
min884.847
max884.860
mean7198.000
σ0.000
min7198.000
max7198.000
mean0.685
σ0.067
min0.610
max0.742

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean7198.000
σ0.000
min7198.000
max7198.000
mean4.284
σ0.080
min4.114
max4.558
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean7198.000
σ0.000
min7198.000
max7198.000
mean4.285
σ0.084
min4.098
max4.529
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean7198.000
σ0.000
min7198.000
max7198.000
mean0.749
σ0.019
min0.717
max0.871
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean7198.000
σ0.000
min7198.000
max7198.000
mean0.703
σ0.014
min0.675
max0.756

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean294.275
σ0.189
min294.133
max294.788
mean7198.000
σ0.000
min7198.000
max7198.000
mean0.575
σ0.025
min0.549
max0.607

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean281.468
σ0.036
min281.415
max281.509
mean7198.000
σ0.000
min7198.000
max7198.000
mean0.397
σ0.008
min0.387
max0.402
iters=5
new-facts=1
prior-facts=6402
mean1291.512
σ0.105
min1291.395
max1291.631
mean7198.000
σ0.000
min7198.000
max7198.000
mean1.969
σ0.111
min1.806
max2.095
iters=5
new-facts=6402
prior-facts=1
mean1534.360
σ4.000
min1532.275
max1541.505
mean7198.000
σ0.000
min7198.000
max7198.000
mean2.322
σ0.325
min2.070
max2.765
iters=5
new-facts=6402
prior-facts=6402
mean1853.343
σ0.093
min1853.212
max1853.453
mean7198.000
σ0.000
min7198.000
max7198.000
mean3.039
σ0.218
min2.861
max3.392

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.769
σ0.092
min1.610
max1.848

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean442.432
σ577.064
min153.896
max1308.028
mean96.250
σ8.500
min92.000
max109.000
mean7198.000
σ0.000
min7198.000
max7198.000
mean0.530
σ0.538
min0.256
max1.337
policies=20
mean1539.249
σ0.322
min1539.024
max1539.726
mean920.000
σ0.000
min920.000
max920.000
mean7198.000
σ0.000
min7198.000
max7198.000
mean2.579
σ0.017
min2.560
max2.602
policies=200
mean15400.733
σ0.087
min15400.648
max15400.838
mean9200.000
σ0.000
min9200.000
max9200.000
mean7198.000
σ0.000
min7198.000
max7198.000
mean26.077
σ0.223
min25.857
max26.386