8bef9934522d99c7c9aba03901b8d8f21c4c2a31

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.615
σ	0.349
min	54.482
max	55.607

*mean*	416.000
σ	0.000
min	416.000
max	416.000

*mean*	0.137
σ	0.005
min	0.132
max	0.146

cache=y

dps=1

iters=10

policies=100

*mean*	43.786
σ	0.006
min	43.776
max	43.798

*mean*	416.000
σ	0.000
min	416.000
max	416.000

*mean*	0.122
σ	0.004
min	0.116
max	0.129

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.620

*mean*	4168.000
σ	1901.993
min	1551.000
max	7200.000

*mean*	12.308
σ	0.209
min	11.992
max	12.646

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.618
σ	0.002
min	36.616
max	36.620

*mean*	4287.375
σ	1981.652
min	1551.000
max	7200.000

*mean*	96.617
σ	237.192
min	12.119
max	683.637

iterations=8

operation_display=table_records(), no indexes

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*	14.204
σ	1.305
min	11.368
max	15.184

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	13.116
σ	1.136
min	10.893
max	14.249

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.931

*mean*	4168.000
σ	1901.993
min	1551.000
max	7200.000

*mean*	12.530
σ	1.456
min	10.350
max	14.371

iterations=8

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

rows=200000

*mean*	27.605
σ	0.002
min	27.603
max	27.607

*mean*	4168.000
σ	1901.993
min	1551.000
max	7200.000

*mean*	8.572
σ	0.339
min	8.131
max	8.946

iterations=8

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

rows=200000

*mean*	26.400
σ	0.001
min	26.399
max	26.403

*mean*	4168.000
σ	1901.993
min	1551.000
max	7200.000

*mean*	6.561
σ	0.190
min	6.245
max	6.801

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.375
σ	1981.652
min	1551.000
max	7200.000

*mean*	5.709
σ	0.592
min	5.348
max	7.153

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.375
σ	1981.652
min	1551.000
max	7200.000

*mean*	5.419
σ	0.565
min	5.150
max	6.814

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969
σ	0.002
min	25.967
max	25.971

*mean*	4287.375
σ	1981.652
min	1551.000
max	7200.000

*mean*	5.435
σ	0.527
min	5.182
max	6.736

iterations=8

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

rows=200000

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4287.375
σ	1981.652
min	1551.000
max	7200.000

*mean*	5.356
σ	0.663
min	5.059
max	6.991

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.597

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	1184.728
σ	382.510
min	1032.187
max	2131.136

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.560
σ	0.040
min	8744.545
max	8744.659

*mean*	3594.000
σ	1823.275
min	1071.000
max	5839.000

*mean*	5087.209
σ	1673.798
min	3538.072
max	7258.132

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.003
min	62.076
max	62.083

*mean*	4168.000
σ	1901.993
min	1551.000
max	7200.000

*mean*	80.622
σ	9.147
min	70.926
max	97.716

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4168.000
σ	1901.993
min	1551.000
max	7200.000

*mean*	80.937
σ	9.387
min	70.504
max	98.229

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.945
σ	0.002
min	40.944
max	40.948

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	101.972
σ	11.990
min	74.790
max	108.610

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.099
σ	11.580
min	76.086
max	108.610

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.950
σ	0.002
min	40.949
max	40.954

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	103.963
σ	11.703
min	78.361
max	112.111

iterations=8

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

rows=200000

*mean*	40.950
σ	0.002
min	40.948
max	40.953

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	102.174
σ	11.977
min	75.033
max	108.674

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.687
σ	0.002
min	66.685
max	66.689

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	213.773
σ	159.612
min	121.538
max	606.767

iterations=8

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

rows=200000

*mean*	66.687
σ	0.002
min	66.685
max	66.689

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	152.103
σ	23.552
min	109.274
max	168.589

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=table_records()

rows=200000

*mean*	11656.833
σ	4.319
min	11655.305
max	11667.523

*mean*	4168.000
σ	1901.993
min	1551.000
max	7200.000

*mean*	6436.327
σ	1292.371
min	4925.906
max	8089.993

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*	5653.997
σ	1344.372
min	4416.758
max	7586.868

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.662
σ	0.013
min	172.643
max	172.679

*mean*	486.000
σ	0.000
min	486.000
max	486.000

*mean*	381.260
σ	37.882
min	309.033
max	422.761

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.467
σ	0.158
min	357.321
max	357.673

*mean*	563.000
σ	0.000
min	563.000
max	563.000

*mean*	778.158
σ	35.988
min	735.048
max	828.893

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.085
σ	0.761
min	1007.608
max	1011.231

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	1.501
σ	0.134
min	1.387
max	1.875

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.885
σ	0.004
min	0.881
max	0.890

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.421
σ	0.084
min	0.352
max	0.513

name=error_case.art

*mean*	2.334
σ	0.003
min	2.332
max	2.339

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.877
σ	0.100
min	0.814
max	1.052

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.535
σ	0.042
min	0.505
max	0.608

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.834
σ	0.040
min	0.792
max	0.898

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.546
σ	0.031
min	963.527
max	963.602

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.776
σ	0.053
min	0.710
max	0.834

name=cdr_enhanced_4k_loc.art

*mean*	884.852
σ	0.005
min	884.847
max	884.859

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.704
σ	0.049
min	0.623
max	0.741

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*	4.240
σ	0.073
min	4.135
max	4.526

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.659

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	4.257
σ	0.080
min	4.113
max	4.536

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.752
σ	0.034
min	0.715
max	1.004

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.708
σ	0.023
min	0.581
max	0.808

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.338
σ	0.222
min	297.169
max	297.952

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.534
σ	0.037
min	0.486
max	0.580

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.729
σ	0.035
min	289.684
max	289.781

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.399
σ	0.014
min	0.389
max	0.421

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.633
σ	0.098
min	1299.512
max	1299.770

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	1.961
σ	0.133
min	1.823
max	2.128

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.635
σ	4.060
min	1540.555
max	1549.888

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	2.385
σ	0.232
min	2.088
max	2.627

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.622
σ	0.083
min	1861.502
max	1861.718

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	2.995
σ	0.198
min	2.762
max	3.274

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.658
σ	0.171
min	1.411
max	1.810

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.148
σ	577.064
min	157.616
max	1311.744

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	0.543
σ	0.549
min	0.267
max	1.367

policies=20

*mean*	1576.420
σ	0.346
min	1576.181
max	1576.932

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	2.628
σ	0.021
min	2.608
max	2.647

policies=200

*mean*	15772.313
σ	0.081
min	15772.198
max	15772.386

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7200.000
σ	0.000
min	7200.000
max	7200.000

*mean*	26.535
σ	0.170
min	26.374
max	26.691