Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	53.703
σ	0.368
min	53.562
max	54.751

*mean*	414.000
σ	0.000
min	414.000
max	414.000

*mean*	0.136
σ	0.005
min	0.130
max	0.146

cache=y

dps=1

iters=10

policies=100

*mean*	43.058
σ	0.007
min	43.050
max	43.069

*mean*	414.000
σ	0.000
min	414.000
max	414.000

*mean*	0.121
σ	0.004
min	0.117
max	0.128

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=column_set() on indexed

rows=200000

*mean*	36.618
σ	0.002
min	36.615
max	36.620

*mean*	4285.125
σ	1980.080
min	1550.000
max	7209.000

*mean*	101.379
σ	250.861
min	12.443
max	722.229

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4285.125
σ	1980.080
min	1550.000
max	7209.000

*mean*	13.984
σ	2.747
min	12.188
max	20.721

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.933

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	14.816
σ	0.949
min	12.893
max	15.594

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	13.565
σ	0.913
min	12.119
max	14.415

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.931

*mean*	4168.625
σ	1902.642
min	1550.000
max	7209.000

*mean*	13.955
σ	1.419
min	11.274
max	15.545

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*	4168.625
σ	1902.642
min	1550.000
max	7209.000

*mean*	9.252
σ	0.498
min	8.777
max	10.246

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.625
σ	1902.642
min	1550.000
max	7209.000

*mean*	6.646
σ	0.136
min	6.462
max	6.871

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.667
σ	0.002
min	25.664
max	25.670

*mean*	4285.125
σ	1980.080
min	1550.000
max	7209.000

*mean*	6.347
σ	0.969
min	5.795
max	8.730

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*	4285.125
σ	1980.080
min	1550.000
max	7209.000

*mean*	5.798
σ	0.448
min	5.548
max	6.888

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*	4285.125
σ	1980.080
min	1550.000
max	7209.000

*mean*	5.941
σ	0.487
min	5.649
max	7.122

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*	4285.125
σ	1980.080
min	1550.000
max	7209.000

*mean*	5.805
σ	0.367
min	5.542
max	6.656

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

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	1354.714
σ	482.119
min	1032.212
max	2221.758

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.560
σ	0.042
min	8744.545
max	8744.663

*mean*	3590.000
σ	1818.552
min	1070.000
max	5822.000

*mean*	5024.140
σ	1657.491
min	3527.548
max	7333.502

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

*mean*	4168.625
σ	1902.642
min	1550.000
max	7209.000

*mean*	81.330
σ	10.856
min	71.806
max	101.102

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.078
σ	0.003
min	62.076
max	62.084

*mean*	4168.625
σ	1902.642
min	1550.000
max	7209.000

*mean*	82.167
σ	10.984
min	72.408
max	102.297

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.944
σ	0.001
min	40.944
max	40.947

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	103.527
σ	9.016
min	84.323
max	109.071

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.946
σ	0.002
min	40.944
max	40.948

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	103.554
σ	9.071
min	84.076
max	109.142

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*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	105.699
σ	7.330
min	90.692
max	111.583

iterations=8

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

rows=200000

*mean*	40.951
σ	0.002
min	40.948
max	40.954

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	103.775
σ	8.944
min	84.790
max	108.901

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.686
σ	0.001
min	66.685
max	66.689

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	234.681
σ	214.832
min	132.946
max	765.491

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*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	156.202
σ	14.819
min	132.903
max	168.438

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

*mean*	4168.625
σ	1902.642
min	1550.000
max	7209.000

*mean*	6916.482
σ	1084.054
min	4862.294
max	8036.077

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.065
σ	0.001
min	11560.064
max	11560.068

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	5660.182
σ	1097.140
min	4406.855
max	7161.962

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.669
σ	0.009
min	172.657
max	172.681

*mean*	486.000
σ	0.000
min	486.000
max	486.000

*mean*	404.962
σ	20.674
min	363.220
max	420.636

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.472
σ	0.168
min	357.321
max	357.695

*mean*	568.000
σ	0.000
min	568.000
max	568.000

*mean*	795.262
σ	48.233
min	723.628
max	886.182

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1005.003
σ	0.751
min	1004.531
max	1008.106

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	1.594
σ	0.133
min	1.396
max	1.901

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*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.317
σ	0.116
min	0.249
max	0.522

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.646
σ	0.091
min	0.591
max	0.809

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.545
σ	0.031
min	0.525
max	0.599

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.873
σ	0.060
min	0.825
max	0.962

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.548
σ	0.024
min	963.523
max	963.578

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.815
σ	0.031
min	0.777
max	0.848

name=cdr_enhanced_4k_loc.art

*mean*	884.854
σ	0.006
min	884.847
max	884.861

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.712
σ	0.028
min	0.678
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.711

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	4.229
σ	0.070
min	4.097
max	4.488

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	4.231
σ	0.077
min	4.070
max	4.469

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.750
σ	0.018
min	0.719
max	0.864

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.714
σ	0.016
min	0.687
max	0.812

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	294.459
σ	0.197
min	294.333
max	295.011

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.529
σ	0.032
min	0.495
max	0.594

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	281.464
σ	0.041
min	281.405
max	281.504

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.385
σ	0.009
min	0.379
max	0.401

iters=5

new-facts=1

prior-facts=6402

*mean*	1291.491
σ	0.099
min	1291.366
max	1291.595

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	1.984
σ	0.095
min	1.869
max	2.116

iters=5

new-facts=6402

prior-facts=1

*mean*	1534.348
σ	4.043
min	1532.313
max	1541.569

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	2.307
σ	0.272
min	2.060
max	2.643

iters=5

new-facts=6402

prior-facts=6402

*mean*	1853.341
σ	0.086
min	1853.228
max	1853.452

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	3.223
σ	0.347
min	2.819
max	3.530

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.626
σ	0.247
min	1.361
max	1.900

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	442.429
σ	577.064
min	153.896
max	1308.025

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.542
σ	0.554
min	0.263
max	1.373

policies=20

*mean*	1539.223
σ	0.333
min	1538.993
max	1539.716

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	2.610
σ	0.015
min	2.592
max	2.629

policies=200

*mean*	15400.413
σ	0.159
min	15400.195
max	15400.569

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	26.167
σ	0.201
min	26.016
max	26.463