Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617
σ	0.348
min	54.489
max	55.609

*mean*	418.000
σ	0.000
min	418.000
max	418.000

*mean*	0.145
σ	0.008
min	0.136
max	0.157

cache=y

dps=1

iters=10

policies=100

*mean*	43.787
σ	0.006
min	43.777
max	43.796

*mean*	418.000
σ	0.000
min	418.000
max	418.000

*mean*	0.130
σ	0.011
min	0.119
max	0.149

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on indexed

*mean*	36.618
σ	0.002
min	36.616
max	36.620

*mean*	4096.750
σ	1579.053
min	1941.000
max	6044.000

*mean*	12.563
σ	0.271
min	12.245
max	12.968

op=column_set() on indexed, repeat

*mean*	36.617
σ	0.002
min	36.616
max	36.619

*mean*	4096.750
σ	1579.053
min	1941.000
max	6044.000

*mean*	12.654
σ	0.454
min	11.772
max	13.137

op=table_records(), no indexes

*mean*	41.928
σ	0.000
min	41.928
max	41.929

*mean*	6044.000
σ	0.000
min	6044.000
max	6044.000

*mean*	13.137
σ	1.339
min	11.006
max	15.221

op=table_records(), repeat

*mean*	41.928
σ	0.002
min	41.927
max	41.931

*mean*	4096.750
σ	1579.053
min	1941.000
max	6044.000

*mean*	12.460
σ	1.823
min	10.542
max	14.723

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

*mean*	27.605
σ	0.002
min	27.603
max	27.607

*mean*	4096.750
σ	1579.053
min	1941.000
max	6044.000

*mean*	8.376
σ	0.350
min	7.794
max	8.843

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

*mean*	26.401
σ	0.002
min	26.399
max	26.403

*mean*	4096.750
σ	1579.053
min	1941.000
max	6044.000

*mean*	6.221
σ	0.404
min	5.376
max	6.719

op=vertical_lookup_row_list() on 2 indexed

*mean*	25.666
σ	0.002
min	25.664
max	25.670

*mean*	4096.750
σ	1579.053
min	1941.000
max	6044.000

*mean*	5.556
σ	0.169
min	5.321
max	5.832

op=vertical_lookup_row_list() on 3 (1 unindexed)

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4096.750
σ	1579.053
min	1941.000
max	6044.000

*mean*	5.206
σ	0.206
min	4.887
max	5.449

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

*mean*	2524.593
σ	0.000
min	2524.593
max	2524.594

*mean*	6044.000
σ	0.000
min	6044.000
max	6044.000

*mean*	1515.739
σ	732.651
min	1047.798
max	3039.490

op=load_product(), with indexes

*mean*	8744.558
σ	0.033
min	8744.544
max	8744.641

*mean*	3810.000
σ	1662.690
min	1941.000
max	6044.000

*mean*	4871.261
σ	1461.380
min	3563.534
max	7157.927

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4096.750
σ	1579.053
min	1941.000
max	6044.000

*mean*	82.466
σ	12.336
min	69.810
max	101.878

op=vertical_lookup_list() on unindexed missing Int

*mean*	40.944
σ	0.001
min	40.944
max	40.945

*mean*	6044.000
σ	0.000
min	6044.000
max	6044.000

*mean*	95.715
σ	10.823
min	78.543
max	106.834

op=vertical_lookup_row_list() on unindexed small unique Int

*mean*	66.686
σ	0.001
min	66.685
max	66.690

*mean*	6044.000
σ	0.000
min	6044.000
max	6044.000

*mean*	235.082
σ	266.736
min	115.897
max	893.991

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.832
σ	4.317
min	11655.305
max	11667.517

*mean*	4096.750
σ	1579.053
min	1941.000
max	6044.000

*mean*	6610.329
σ	1347.756
min	4971.099
max	8529.833

op=vertical_lookup_list() on indexed

*mean*	11560.069
σ	0.001
min	11560.066
max	11560.069

*mean*	6044.000
σ	0.000
min	6044.000
max	6044.000

*mean*	6649.482
σ	1437.394
min	4458.839
max	7798.860

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.583
σ	0.024
min	172.558
max	172.619

*mean*	1941.000
σ	0.000
min	1941.000
max	1941.000

*mean*	357.448
σ	43.137
min	262.879
max	401.649

op=pointedIndexFromKvs

rows=400000

*mean*	357.367
σ	0.044
min	357.321
max	357.420

*mean*	1941.000
σ	0.000
min	1941.000
max	1941.000

*mean*	779.724
σ	27.142
min	731.570
max	808.918

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.189
σ	0.895
min	1007.686
max	1011.905

*mean*	1056.550
σ	302.038
min	552.000
max	1464.000

*mean*	1.541
σ	0.066
min	1.475
max	1.748

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.882
σ	0.002
min	0.881
max	0.886

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	0.416
σ	0.121
min	0.346
max	0.630

name=error_case.art

*mean*	2.334
σ	0.003
min	2.332
max	2.337

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	0.882
σ	0.091
min	0.830
max	1.043

name=heavy_item.art

*mean*	1.521
σ	0.001
min	1.520
max	1.523

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	0.544
σ	0.050
min	0.504
max	0.631

name=nested_use.art

*mean*	2.356
σ	0.002
min	2.355
max	2.358

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	0.839
σ	0.046
min	0.802
max	0.916

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.540
σ	0.028
min	963.523
max	963.589

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	0.800
σ	0.053
min	0.745
max	0.858

name=cdr_enhanced_4k_loc.art

*mean*	884.854
σ	0.004
min	884.851
max	884.862

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	0.724
σ	0.034
min	0.670
max	0.749

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

*mean*	4.286
σ	0.071
min	4.167
max	4.533

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	4.278
σ	0.073
min	4.152
max	4.535

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	0.757
σ	0.019
min	0.722
max	0.870

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	0.716
σ	0.018
min	0.651
max	0.793

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.443
σ	0.216
min	297.291
max	298.030

*mean*	1941.000
σ	0.000
min	1941.000
max	1941.000

*mean*	0.585
σ	0.051
min	0.525
max	0.706

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.776
σ	0.032
min	289.730
max	289.807

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	0.402
σ	0.006
min	0.396
max	0.413

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.663
σ	0.054
min	1299.620
max	1299.739

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	2.168
σ	0.107
min	2.038
max	2.284

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.709
σ	3.993
min	1540.785
max	1549.849

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	2.488
σ	0.197
min	2.217
max	2.668

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.630
σ	0.074
min	1861.523
max	1861.705

*mean*	1756.200
σ	192.569
min	1511.000
max	1941.000

*mean*	3.282
σ	0.389
min	2.856
max	3.859

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.806
σ	0.188
min	1.474
max	1.936

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.182
σ	577.140
min	157.609
max	1311.893

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	0.538
σ	0.537
min	0.266
max	1.343

policies=20

*mean*	1576.397
σ	0.355
min	1576.159
max	1576.925

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	2.632
σ	0.005
min	2.628
max	2.638

policies=200

*mean*	15772.160
σ	0.109
min	15772.031
max	15772.288

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1464.000
σ	0.000
min	1464.000
max	1464.000

*mean*	26.569
σ	0.040
min	26.521
max	26.616