ebe39db11505c51fcd8716c66ce65616b8bce71d

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.615
σ	0.351
min	54.483
max	55.614

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.138
σ	0.004
min	0.134
max	0.146

cache=y

dps=1

iters=10

policies=100

*mean*	43.785
σ	0.008
min	43.772
max	43.800

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.119
σ	0.004
min	0.114
max	0.124

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.375
σ	1900.743
min	1547.000
max	7201.000

*mean*	12.768
σ	0.220
min	12.487
max	13.159

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.621

*mean*	4288.750
σ	1980.768
min	1547.000
max	7201.000

*mean*	97.152
σ	238.746
min	11.829
max	688.014

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	14.826
σ	1.171
min	12.193
max	15.748

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	13.765
σ	1.393
min	11.817
max	15.617

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.931

*mean*	4168.375
σ	1900.743
min	1547.000
max	7201.000

*mean*	13.620
σ	1.744
min	10.918
max	15.551

iterations=8

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

rows=200000

*mean*	27.605
σ	0.003
min	27.603
max	27.611

*mean*	4168.375
σ	1900.743
min	1547.000
max	7201.000

*mean*	9.342
σ	0.288
min	8.952
max	9.749

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*	4168.375
σ	1900.743
min	1547.000
max	7201.000

*mean*	6.805
σ	0.262
min	6.411
max	7.144

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.666
σ	0.002
min	25.664
max	25.669

*mean*	4288.750
σ	1980.768
min	1547.000
max	7201.000

*mean*	6.357
σ	1.029
min	5.723
max	8.860

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*	4288.750
σ	1980.768
min	1547.000
max	7201.000

*mean*	5.916
σ	1.076
min	5.205
max	8.552

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*	4288.750
σ	1980.768
min	1547.000
max	7201.000

*mean*	5.937
σ	1.167
min	5.216
max	8.788

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*	4288.750
σ	1980.768
min	1547.000
max	7201.000

*mean*	5.771
σ	1.042
min	5.007
max	8.275

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.596
σ	0.002
min	2524.594
max	2524.597

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	1184.660
σ	395.133
min	1039.135
max	2162.489

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.041
min	8744.545
max	8744.662

*mean*	3597.125
σ	1820.485
min	1075.000
max	5839.000

*mean*	5003.826
σ	1612.064
min	3533.942
max	7168.683

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*	4168.375
σ	1900.743
min	1547.000
max	7201.000

*mean*	79.867
σ	9.503
min	71.860
max	99.213

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.375
σ	1900.743
min	1547.000
max	7201.000

*mean*	80.614
σ	9.821
min	71.306
max	100.401

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.944
σ	0.001
min	40.943
max	40.947

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	101.729
σ	10.621
min	79.639
max	107.729

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.946
σ	0.002
min	40.944
max	40.947

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	101.867
σ	10.711
min	79.459
max	107.961

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

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	103.776
σ	9.047
min	85.830
max	110.584

iterations=8

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

rows=200000

*mean*	40.951
σ	0.002
min	40.949
max	40.953

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	102.070
σ	10.591
min	80.178
max	108.446

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

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	215.861
σ	167.636
min	127.546
max	629.183

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

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	152.469
σ	20.788
min	116.649
max	168.834

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=table_records()

rows=200000

*mean*	11656.833
σ	4.318
min	11655.305
max	11667.520

*mean*	4168.375
σ	1900.743
min	1547.000
max	7201.000

*mean*	6739.507
σ	1188.797
min	4901.190
max	8202.909

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.065
σ	0.001
min	11560.064
max	11560.069

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	5576.154
σ	1049.486
min	4399.572
max	7197.061

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.666
σ	0.012
min	172.651
max	172.686

*mean*	489.000
σ	0.000
min	489.000
max	489.000

*mean*	403.230
σ	28.146
min	354.560
max	423.542

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.464
σ	0.157
min	357.321
max	357.675

*mean*	564.000
σ	0.000
min	564.000
max	564.000

*mean*	785.250
σ	43.436
min	704.640
max	817.378

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.083
σ	0.760
min	1007.609
max	1011.227

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	1.514
σ	0.127
min	1.392
max	1.841

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.884
σ	0.003
min	0.881
max	0.887

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	0.195
σ	0.097
min	0.138
max	0.368

name=error_case.art

*mean*	2.334
σ	0.002
min	2.332
max	2.337

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	0.471
σ	0.216
min	0.333
max	0.831

name=heavy_item.art

*mean*	1.522
σ	0.003
min	1.520
max	1.525

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	0.536
σ	0.044
min	0.494
max	0.612

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	0.844
σ	0.035
min	0.823
max	0.905

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.548
σ	0.028
min	963.523
max	963.585

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	0.778
σ	0.096
min	0.646
max	0.860

name=cdr_enhanced_4k_loc.art

*mean*	884.853
σ	0.005
min	884.847
max	884.860

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	0.738
σ	0.002
min	0.736
max	0.740

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

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	4.247
σ	0.087
min	4.088
max	4.517

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	4.218
σ	0.065
min	4.104
max	4.456

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	0.745
σ	0.016
min	0.710
max	0.840

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	0.707
σ	0.015
min	0.673
max	0.788

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.419
σ	0.246
min	297.244
max	298.080

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	0.584
σ	0.050
min	0.522
max	0.702

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.728
σ	0.031
min	289.687
max	289.772

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	0.391
σ	0.003
min	0.388
max	0.395

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.637
σ	0.093
min	1299.522
max	1299.756

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	1.890
σ	0.085
min	1.807
max	2.015

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.622
σ	4.061
min	1540.596
max	1549.878

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	2.283
σ	0.225
min	2.125
max	2.644

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.594
σ	0.035
min	1861.556
max	1861.639

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	2.987
σ	0.264
min	2.667
max	3.348

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.661
σ	0.239
min	1.315
max	1.917

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.145
σ	577.064
min	157.608
max	1311.741

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	0.550
σ	0.549
min	0.269
max	1.373

policies=20

*mean*	1576.404
σ	0.357
min	1576.164
max	1576.933

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	2.648
σ	0.009
min	2.637
max	2.657

policies=200

*mean*	15772.146
σ	0.136
min	15771.984
max	15772.290

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7201.000
σ	0.000
min	7201.000
max	7201.000

*mean*	26.516
σ	0.106
min	26.395
max	26.646