Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.616
σ	0.350
min	54.483
max	55.612

*mean*	415.000
σ	0.000
min	415.000
max	415.000

*mean*	0.140
σ	0.004
min	0.136
max	0.146

cache=y

dps=1

iters=10

policies=100

*mean*	43.786
σ	0.007
min	43.777
max	43.800

*mean*	415.000
σ	0.000
min	415.000
max	415.000

*mean*	0.124
σ	0.004
min	0.118
max	0.130

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on indexed

*mean*	36.618
σ	0.002
min	36.615
max	36.620

*mean*	4099.375
σ	1569.572
min	1978.000
max	6039.000

*mean*	12.231
σ	0.326
min	11.860
max	12.914

op=column_set() on indexed, repeat

*mean*	36.617
σ	0.002
min	36.615
max	36.620

*mean*	4099.375
σ	1569.572
min	1978.000
max	6039.000

*mean*	12.179
σ	0.608
min	11.333
max	12.867

op=table_records(), no indexes

*mean*	41.928
σ	0.000
min	41.928
max	41.929

*mean*	6039.000
σ	0.000
min	6039.000
max	6039.000

*mean*	13.103
σ	1.098
min	10.745
max	14.460

op=table_records(), repeat

*mean*	41.928
σ	0.002
min	41.927
max	41.931

*mean*	4099.375
σ	1569.572
min	1978.000
max	6039.000

*mean*	12.186
σ	1.731
min	10.240
max	14.440

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

*mean*	27.605
σ	0.002
min	27.603
max	27.607

*mean*	4099.375
σ	1569.572
min	1978.000
max	6039.000

*mean*	8.353
σ	0.301
min	7.961
max	8.690

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

*mean*	26.400
σ	0.002
min	26.399
max	26.403

*mean*	4099.375
σ	1569.572
min	1978.000
max	6039.000

*mean*	6.477
σ	0.115
min	6.324
max	6.601

op=vertical_lookup_row_list() on 2 indexed

*mean*	25.666
σ	0.002
min	25.664
max	25.670

*mean*	4099.375
σ	1569.572
min	1978.000
max	6039.000

*mean*	5.428
σ	0.069
min	5.337
max	5.552

op=vertical_lookup_row_list() on 3 (1 unindexed)

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4099.375
σ	1569.572
min	1978.000
max	6039.000

*mean*	5.236
σ	0.055
min	5.153
max	5.304

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

*mean*	2524.594
σ	0.000
min	2524.593
max	2524.594

*mean*	6039.000
σ	0.000
min	6039.000
max	6039.000

*mean*	1534.858
σ	790.614
min	1035.167
max	2960.332

op=load_product(), with indexes

*mean*	8744.559
σ	0.033
min	8744.545
max	8744.640

*mean*	3818.500
σ	1647.983
min	1978.000
max	6039.000

*mean*	4584.385
σ	1511.924
min	3516.131
max	7650.294

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

*mean*	62.078
σ	0.002
min	62.076
max	62.080

*mean*	4099.375
σ	1569.572
min	1978.000
max	6039.000

*mean*	81.226
σ	11.656
min	70.285
max	101.506

op=vertical_lookup_list() on unindexed missing Int

*mean*	40.944
σ	0.001
min	40.944
max	40.945

*mean*	6039.000
σ	0.000
min	6039.000
max	6039.000

*mean*	95.464
σ	10.293
min	77.828
max	108.228

op=vertical_lookup_row_list() on unindexed small unique Int

*mean*	66.686
σ	0.000
min	66.685
max	66.687

*mean*	6039.000
σ	0.000
min	6039.000
max	6039.000

*mean*	221.070
σ	221.026
min	117.099
max	766.842

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.833
σ	4.318
min	11655.305
max	11667.520

*mean*	4099.375
σ	1569.572
min	1978.000
max	6039.000

*mean*	6294.070
σ	1175.256
min	4968.299
max	8066.610

op=vertical_lookup_list() on indexed

*mean*	11560.068
σ	0.001
min	11560.066
max	11560.069

*mean*	6039.000
σ	0.000
min	6039.000
max	6039.000

*mean*	6628.126
σ	1460.821
min	4392.891
max	7956.863

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

*mean*	1978.000
σ	0.000
min	1978.000
max	1978.000

*mean*	355.878
σ	46.370
min	266.143
max	401.865

op=pointedIndexFromKvs

rows=400000

*mean*	357.360
σ	0.042
min	357.321
max	357.409

*mean*	1978.000
σ	0.000
min	1978.000
max	1978.000

*mean*	776.186
σ	62.682
min	624.708
max	825.016

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.184
σ	0.882
min	1007.690
max	1011.840

*mean*	1035.050
σ	296.524
min	543.000
max	1433.000

*mean*	1.538
σ	0.082
min	1.472
max	1.756

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

*mean*	0.416
σ	0.139
min	0.329
max	0.660

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	1433.000
σ	0.000
min	1433.000
max	1433.000

*mean*	0.886
σ	0.086
min	0.828
max	1.035

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1433.000
σ	0.000
min	1433.000
max	1433.000

*mean*	0.550
σ	0.046
min	0.519
max	0.630

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1433.000
σ	0.000
min	1433.000
max	1433.000

*mean*	0.849
σ	0.040
min	0.810
max	0.912

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.543
σ	0.026
min	963.523
max	963.585

*mean*	1433.000
σ	0.000
min	1433.000
max	1433.000

*mean*	0.825
σ	0.043
min	0.754
max	0.854

name=cdr_enhanced_4k_loc.art

*mean*	884.853
σ	0.008
min	884.847
max	884.867

*mean*	1433.000
σ	0.000
min	1433.000
max	1433.000

*mean*	0.679
σ	0.047
min	0.609
max	0.737

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

*mean*	4.250
σ	0.081
min	4.100
max	4.530

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.659

*mean*	1433.000
σ	0.000
min	1433.000
max	1433.000

*mean*	4.235
σ	0.075
min	4.117
max	4.539

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1433.000
σ	0.000
min	1433.000
max	1433.000

*mean*	0.749
σ	0.016
min	0.721
max	0.858

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1433.000
σ	0.000
min	1433.000
max	1433.000

*mean*	0.708
σ	0.014
min	0.678
max	0.781

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.529
σ	0.248
min	297.383
max	298.228

*mean*	1978.000
σ	0.000
min	1978.000
max	1978.000

*mean*	0.580
σ	0.032
min	0.505
max	0.606

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.773
σ	0.037
min	289.726
max	289.812

*mean*	1433.000
σ	0.000
min	1433.000
max	1433.000

*mean*	0.406
σ	0.010
min	0.398
max	0.422

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.646
σ	0.064
min	1299.573
max	1299.726

*mean*	1433.000
σ	0.000
min	1433.000
max	1433.000

*mean*	2.090
σ	0.092
min	1.936
max	2.176

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.680
σ	4.063
min	1540.705
max	1549.943

*mean*	1433.000
σ	0.000
min	1433.000
max	1433.000

*mean*	2.469
σ	0.280
min	2.132
max	2.901

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.638
σ	0.058
min	1861.551
max	1861.692

*mean*	1763.800
σ	226.028
min	1467.000
max	1978.000

*mean*	3.239
σ	0.245
min	2.896
max	3.493

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.754
σ	0.210
min	1.448
max	2.023

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.183
σ	577.137
min	157.613
max	1311.889

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1433.000
σ	0.000
min	1433.000
max	1433.000

*mean*	0.535
σ	0.536
min	0.264
max	1.339

policies=20

*mean*	1576.402
σ	0.339
min	1576.172
max	1576.906

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1433.000
σ	0.000
min	1433.000
max	1433.000

*mean*	2.612
σ	0.013
min	2.597
max	2.627

policies=200

*mean*	15772.288
σ	0.160
min	15772.086
max	15772.469

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1433.000
σ	0.000
min	1433.000
max	1433.000

*mean*	26.470
σ	0.049
min	26.430
max	26.538