Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.523
σ	0.372
min	54.380
max	55.581

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.140
σ	0.004
min	0.136
max	0.146

cache=y

dps=1

iters=10

policies=100

*mean*	43.766
σ	0.007
min	43.754
max	43.779

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.122
σ	0.004
min	0.116
max	0.130

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*	4280.500
σ	1967.859
min	1550.000
max	7173.000

*mean*	12.780
σ	0.359
min	12.379
max	13.412

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.618
σ	0.002
min	36.616
max	36.620

*mean*	4280.500
σ	1967.859
min	1550.000
max	7173.000

*mean*	13.562
σ	2.176
min	11.710
max	18.649

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	15.089
σ	0.775
min	13.820
max	15.827

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	13.706
σ	0.856
min	12.106
max	14.469

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.928
σ	0.002
min	41.927
max	41.931

*mean*	4163.250
σ	1889.762
min	1550.000
max	7173.000

*mean*	13.116
σ	1.144
min	10.935
max	14.275

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*	4163.250
σ	1889.762
min	1550.000
max	7173.000

*mean*	9.231
σ	0.289
min	8.779
max	9.515

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*	4163.250
σ	1889.762
min	1550.000
max	7173.000

*mean*	7.120
σ	0.090
min	6.940
max	7.219

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*	4280.500
σ	1967.859
min	1550.000
max	7173.000

*mean*	6.203
σ	0.543
min	5.782
max	7.516

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*	4280.500
σ	1967.859
min	1550.000
max	7173.000

*mean*	5.815
σ	0.537
min	5.469
max	7.127

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4280.500
σ	1967.859
min	1550.000
max	7173.000

*mean*	5.871
σ	0.591
min	5.591
max	7.329

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*	4280.500
σ	1967.859
min	1550.000
max	7173.000

*mean*	5.734
σ	0.572
min	5.413
max	7.139

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

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	1464.055
σ	646.845
min	1036.094
max	2523.491

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.040
min	8744.545
max	8744.660

*mean*	3591.000
σ	1811.429
min	1075.000
max	5815.000

*mean*	4448.717
σ	1440.519
min	3513.084
max	7349.039

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*	4163.250
σ	1889.762
min	1550.000
max	7173.000

*mean*	81.893
σ	9.540
min	71.903
max	98.712

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.078
σ	0.002
min	62.075
max	62.080

*mean*	4163.250
σ	1889.762
min	1550.000
max	7173.000

*mean*	82.310
σ	9.465
min	72.426
max	98.933

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.945
σ	0.002
min	40.943
max	40.947

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	104.700
σ	5.514
min	95.186
max	108.474

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

*mean*	104.662
σ	5.441
min	95.004
max	108.382

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

*mean*	106.850
σ	5.026
min	96.731
max	112.730

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

*mean*	104.606
σ	5.493
min	95.098
max	108.442

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

*mean*	218.545
σ	161.665
min	148.765
max	618.211

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

*mean*	156.505
σ	17.473
min	117.150
max	168.737

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*	4163.250
σ	1889.762
min	1550.000
max	7173.000

*mean*	6457.966
σ	1111.383
min	4934.790
max	7854.636

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.066
σ	0.002
min	11560.064
max	11560.068

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	5843.934
σ	1570.493
min	4408.393
max	7748.622

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.670
σ	0.008
min	172.658
max	172.677

*mean*	487.000
σ	0.000
min	487.000
max	487.000

*mean*	406.976
σ	20.206
min	369.106
max	431.051

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.457
σ	0.150
min	357.321
max	357.681

*mean*	565.000
σ	0.000
min	565.000
max	565.000

*mean*	768.050
σ	48.495
min	688.816
max	832.450

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.080
σ	0.761
min	1007.605
max	1011.227

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	1.537
σ	0.125
min	1.408
max	1.767

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

*mean*	0.416
σ	0.099
min	0.336
max	0.555

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	0.971
σ	0.154
min	0.861
max	1.232

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	0.544
σ	0.039
min	0.507
max	0.603

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	0.862
σ	0.038
min	0.832
max	0.926

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.551
σ	0.024
min	963.527
max	963.590

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	0.820
σ	0.038
min	0.765
max	0.853

name=cdr_enhanced_4k_loc.art

*mean*	884.854
σ	0.010
min	884.847
max	884.869

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	0.640
σ	0.006
min	0.632
max	0.647

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

*mean*	3.596
σ	0.075
min	3.459
max	3.906

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.662

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	3.552
σ	0.074
min	3.396
max	3.797

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	0.548
σ	0.014
min	0.523
max	0.638

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	0.516
σ	0.012
min	0.495
max	0.582

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.384
σ	0.214
min	297.247
max	297.956

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	0.561
σ	0.036
min	0.508
max	0.598

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.744
σ	0.027
min	289.717
max	289.788

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	0.388
σ	0.006
min	0.384
max	0.398

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.678
σ	0.110
min	1299.510
max	1299.780

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	1.936
σ	0.082
min	1.806
max	2.019

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.639
σ	4.060
min	1540.557
max	1549.891

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	2.229
σ	0.226
min	2.041
max	2.575

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.622
σ	0.065
min	1861.564
max	1861.710

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	2.913
σ	0.099
min	2.824
max	3.045

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.498
σ	0.278
min	1.255
max	1.865

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.145
σ	577.063
min	157.611
max	1311.739

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	0.531
σ	0.529
min	0.263
max	1.325

policies=20

*mean*	1576.389
σ	0.346
min	1576.155
max	1576.902

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	2.623
σ	0.018
min	2.602
max	2.645

policies=200

*mean*	15771.844
σ	0.163
min	15771.709
max	15772.074

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7173.000
σ	0.000
min	7173.000
max	7173.000

*mean*	26.538
σ	0.127
min	26.412
max	26.694