9f52d648b631d9bd7bf1bab9e67aa062ca2ff3cc

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.523
σ	0.371
min	54.386
max	55.579

*mean*	416.000
σ	0.000
min	416.000
max	416.000

*mean*	0.143
σ	0.007
min	0.137
max	0.160

cache=y

dps=1

iters=10

policies=100

*mean*	43.766
σ	0.008
min	43.760
max	43.784

*mean*	416.000
σ	0.000
min	416.000
max	416.000

*mean*	0.120
σ	0.004
min	0.115
max	0.127

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=column_set() on indexed

rows=200000

*mean*	36.617
σ	0.002
min	36.615
max	36.619

*mean*	4166.500
σ	1898.389
min	1550.000
max	7200.000

*mean*	12.635
σ	0.322
min	12.253
max	13.133

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.618
σ	0.002
min	36.616
max	36.620

*mean*	4287.000
σ	1978.404
min	1550.000
max	7200.000

*mean*	101.189
σ	250.322
min	11.696
max	720.702

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.933

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	14.932
σ	1.314
min	12.071
max	15.949

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	13.452
σ	1.210
min	11.401
max	14.712

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.928
σ	0.002
min	41.927
max	41.931

*mean*	4166.500
σ	1898.389
min	1550.000
max	7200.000

*mean*	13.832
σ	1.522
min	11.610
max	15.257

iterations=8

operation_display=vertical_lookup_list() on indexed, after table_records()

rows=200000

*mean*	27.604
σ	0.002
min	27.603
max	27.607

*mean*	4166.500
σ	1898.389
min	1550.000
max	7200.000

*mean*	9.109
σ	0.512
min	8.344
max	9.647

iterations=8

operation_display=vertical_lookup_list() on indexed, after table_records(), repeat

rows=200000

*mean*	26.400
σ	0.002
min	26.399
max	26.403

*mean*	4166.500
σ	1898.389
min	1550.000
max	7200.000

*mean*	6.611
σ	0.399
min	6.055
max	7.191

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.666
σ	0.002
min	25.664
max	25.668

*mean*	4287.000
σ	1978.404
min	1550.000
max	7200.000

*mean*	6.241
σ	0.640
min	5.829
max	7.797

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.661
σ	0.002
min	25.659
max	25.663

*mean*	4287.000
σ	1978.404
min	1550.000
max	7200.000

*mean*	5.924
σ	0.713
min	5.138
max	7.491

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969
σ	0.003
min	25.967
max	25.975

*mean*	4287.000
σ	1978.404
min	1550.000
max	7200.000

*mean*	5.900
σ	0.653
min	5.144
max	7.410

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat

rows=200000

*mean*	25.968
σ	0.001
min	25.967
max	25.971

*mean*	4287.000
σ	1978.404
min	1550.000
max	7200.000

*mean*	5.863
σ	0.681
min	5.119
max	7.390

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.595
σ	0.002
min	2524.594
max	2524.598

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	1186.675
σ	400.279
min	1035.892
max	2177.224

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.040
min	8744.545
max	8744.660

*mean*	3594.000
σ	1818.498
min	1073.000
max	5835.000

*mean*	4918.308
σ	1542.183
min	3558.927
max	7176.448

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=column_set() on unindexed, dense

rows=200000

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4166.500
σ	1898.389
min	1550.000
max	7200.000

*mean*	80.420
σ	9.671
min	70.550
max	98.226

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.078
σ	0.002
min	62.076
max	62.080

*mean*	4166.500
σ	1898.389
min	1550.000
max	7200.000

*mean*	81.042
σ	9.904
min	70.104
max	98.662

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.945
σ	0.002
min	40.944
max	40.947

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	102.941
σ	9.629
min	82.456
max	109.305

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.945
σ	0.002
min	40.944
max	40.947

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	102.711
σ	9.431
min	82.387
max	108.207

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.951
σ	0.002
min	40.949
max	40.954

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	106.057
σ	7.604
min	90.039
max	112.287

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat

rows=200000

*mean*	40.950
σ	0.002
min	40.949
max	40.953

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	102.835
σ	9.425
min	82.713
max	108.356

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.687
σ	0.002
min	66.686
max	66.689

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	219.508
σ	174.370
min	130.524
max	649.810

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat

rows=200000

*mean*	66.686
σ	0.002
min	66.685
max	66.689

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	153.724
σ	18.851
min	119.792
max	169.207

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=table_records()

rows=200000

*mean*	11656.834
σ	4.318
min	11655.305
max	11667.520

*mean*	4166.500
σ	1898.389
min	1550.000
max	7200.000

*mean*	6612.053
σ	1282.358
min	4938.362
max	8335.408

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.066
σ	0.002
min	11560.064
max	11560.069

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	6106.341
σ	1571.470
min	4426.556
max	8575.382

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.655
σ	0.015
min	172.634
max	172.673

*mean*	486.000
σ	0.000
min	486.000
max	486.000

*mean*	363.931
σ	51.089
min	271.276
max	419.128

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.463
σ	0.151
min	357.321
max	357.627

*mean*	563.000
σ	0.000
min	563.000
max	563.000

*mean*	795.186
σ	35.776
min	719.747
max	831.837

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.076
σ	0.762
min	1007.605
max	1011.225

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	1.516
σ	0.112
min	1.401
max	1.791

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.883
σ	0.002
min	0.881
max	0.886

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.327
σ	0.126
min	0.261
max	0.550

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.647
σ	0.075
min	0.606
max	0.780

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.387
σ	0.031
min	0.357
max	0.437

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.741
σ	0.106
min	0.599
max	0.842

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.547
σ	0.023
min	963.528
max	963.577

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.786
σ	0.059
min	0.708
max	0.847

name=cdr_enhanced_4k_loc.art

*mean*	884.853
σ	0.006
min	884.847
max	884.862

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.569
σ	0.062
min	0.515
max	0.638

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.706
σ	0.002
min	7.705
max	7.709

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	3.555
σ	0.086
min	3.406
max	3.842

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	3.519
σ	0.075
min	3.375
max	3.787

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.547
σ	0.029
min	0.522
max	0.783

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.514
σ	0.012
min	0.492
max	0.579

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.354
σ	0.259
min	297.175
max	298.071

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.568
σ	0.021
min	0.547
max	0.603

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.730
σ	0.033
min	289.678
max	289.765

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.396
σ	0.012
min	0.386
max	0.412

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.628
σ	0.095
min	1299.512
max	1299.761

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	1.956
σ	0.118
min	1.801
max	2.112

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.619
σ	4.070
min	1540.596
max	1549.890

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	2.361
σ	0.219
min	2.078
max	2.646

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.596
σ	0.060
min	1861.506
max	1861.650

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	2.944
σ	0.127
min	2.846
max	3.116

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.653
σ	0.210
min	1.374
max	1.866

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.147
σ	577.067
min	157.613
max	1311.747

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.549
σ	0.555
min	0.270
max	1.381

policies=20

*mean*	1576.398
σ	0.350
min	1576.157
max	1576.916

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	2.627
σ	0.018
min	2.605
max	2.646

policies=200

*mean*	15771.945
σ	0.056
min	15771.869
max	15771.998

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	26.444
σ	0.148
min	26.328
max	26.661