Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.616
σ	0.348
min	54.481
max	55.606

*mean*	418.700
σ	0.483
min	418.000
max	419.000

*mean*	0.138
σ	0.005
min	0.131
max	0.147

cache=y

dps=1

iters=10

policies=100

*mean*	43.787
σ	0.007
min	43.779
max	43.804

*mean*	419.000
σ	0.000
min	419.000
max	419.000

*mean*	0.120
σ	0.005
min	0.115
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*	4264.125
σ	1876.550
min	1983.000
max	7537.000

*mean*	12.772
σ	1.642
min	11.703
max	16.747

op=column_set() on indexed, repeat

*mean*	36.617
σ	0.002
min	36.615
max	36.619

*mean*	4264.125
σ	1876.550
min	1983.000
max	7537.000

*mean*	12.629
σ	1.506
min	11.326
max	16.094

op=table_records(), no indexes

*mean*	41.928
σ	0.000
min	41.928
max	41.929

*mean*	7537.000
σ	0.000
min	7537.000
max	7537.000

*mean*	13.454
σ	0.906
min	12.567
max	14.590

op=table_records(), repeat

*mean*	41.928
σ	0.002
min	41.927
max	41.931

*mean*	4264.125
σ	1876.550
min	1983.000
max	7537.000

*mean*	12.012
σ	1.981
min	10.163
max	15.646

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

*mean*	27.605
σ	0.002
min	27.603
max	27.607

*mean*	4264.125
σ	1876.550
min	1983.000
max	7537.000

*mean*	8.719
σ	1.201
min	7.889
max	11.627

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

*mean*	26.400
σ	0.002
min	26.399
max	26.403

*mean*	4264.125
σ	1876.550
min	1983.000
max	7537.000

*mean*	6.914
σ	1.099
min	6.331
max	9.624

op=vertical_lookup_row_list() on 2 indexed

*mean*	25.666
σ	0.002
min	25.664
max	25.670

*mean*	4264.125
σ	1876.550
min	1983.000
max	7537.000

*mean*	5.637
σ	0.464
min	5.251
max	6.733

op=vertical_lookup_row_list() on 3 (1 unindexed)

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4264.125
σ	1876.550
min	1983.000
max	7537.000

*mean*	5.423
σ	0.491
min	5.141
max	6.630

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

*mean*	1043.540
σ	3.816
min	1037.759
max	1049.724

op=load_product(), with indexes

*mean*	8744.558
σ	0.033
min	8744.544
max	8744.639

*mean*	3788.750
σ	1608.136
min	1983.000
max	5947.000

*mean*	4424.494
σ	1402.825
min	3532.944
max	7446.625

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

*mean*	62.078
σ	0.002
min	62.075
max	62.080

*mean*	4264.125
σ	1876.550
min	1983.000
max	7537.000

*mean*	85.249
σ	13.627
min	70.604
max	106.412

op=vertical_lookup_list() on unindexed missing Int

*mean*	40.944
σ	0.001
min	40.944
max	40.945

*mean*	7537.000
σ	0.000
min	7537.000
max	7537.000

*mean*	100.582
σ	7.556
min	88.174
max	109.085

op=vertical_lookup_row_list() on unindexed small unique Int

*mean*	66.686
σ	0.000
min	66.685
max	66.686

*mean*	7537.000
σ	0.000
min	7537.000
max	7537.000

*mean*	150.563
σ	14.496
min	127.225
max	167.190

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*	4264.125
σ	1876.550
min	1983.000
max	7537.000

*mean*	6366.729
σ	1161.803
min	4965.166
max	8148.390

op=vertical_lookup_list() on indexed

*mean*	11560.068
σ	0.001
min	11560.066
max	11560.069

*mean*	7537.000
σ	0.000
min	7537.000
max	7537.000

*mean*	5428.145
σ	1341.750
min	4382.067
max	7486.002

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.581
σ	0.025
min	172.558
max	172.623

*mean*	1983.000
σ	0.000
min	1983.000
max	1983.000

*mean*	347.469
σ	38.746
min	264.971
max	390.621

op=pointedIndexFromKvs

rows=400000

*mean*	357.366
σ	0.046
min	357.321
max	357.445

*mean*	1983.000
σ	0.000
min	1983.000
max	1983.000

*mean*	735.782
σ	60.627
min	642.528
max	802.805

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.190
σ	0.868
min	1007.688
max	1011.774

*mean*	1043.450
σ	301.157
min	548.000
max	1469.000

*mean*	1.521
σ	0.068
min	1.454
max	1.757

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

*mean*	0.427
σ	0.136
min	0.341
max	0.668

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	1469.000
σ	0.000
min	1469.000
max	1469.000

*mean*	0.898
σ	0.095
min	0.841
max	1.066

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1469.000
σ	0.000
min	1469.000
max	1469.000

*mean*	0.556
σ	0.047
min	0.524
max	0.637

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1469.000
σ	0.000
min	1469.000
max	1469.000

*mean*	0.855
σ	0.043
min	0.819
max	0.928

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.542
σ	0.029
min	963.523
max	963.593

*mean*	1469.000
σ	0.000
min	1469.000
max	1469.000

*mean*	0.790
σ	0.059
min	0.727
max	0.866

name=cdr_enhanced_4k_loc.art

*mean*	884.853
σ	0.006
min	884.847
max	884.860

*mean*	1469.000
σ	0.000
min	1469.000
max	1469.000

*mean*	0.741
σ	0.005
min	0.737
max	0.748

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

*mean*	4.294
σ	0.084
min	4.143
max	4.580

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	1469.000
σ	0.000
min	1469.000
max	1469.000

*mean*	4.272
σ	0.077
min	4.143
max	4.584

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1469.000
σ	0.000
min	1469.000
max	1469.000

*mean*	0.758
σ	0.018
min	0.728
max	0.880

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1469.000
σ	0.000
min	1469.000
max	1469.000

*mean*	0.709
σ	0.045
min	0.502
max	0.802

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.443
σ	0.238
min	297.223
max	298.069

*mean*	1983.000
σ	0.000
min	1983.000
max	1983.000

*mean*	0.555
σ	0.032
min	0.504
max	0.599

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.770
σ	0.032
min	289.727
max	289.804

*mean*	1469.000
σ	0.000
min	1469.000
max	1469.000

*mean*	0.397
σ	0.015
min	0.377
max	0.421

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.648
σ	0.067
min	1299.572
max	1299.708

*mean*	1469.000
σ	0.000
min	1469.000
max	1469.000

*mean*	2.095
σ	0.064
min	1.997
max	2.146

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.625
σ	4.032
min	1540.591
max	1549.828

*mean*	1469.000
σ	0.000
min	1469.000
max	1469.000

*mean*	2.260
σ	0.164
min	2.128
max	2.448

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.632
σ	0.057
min	1861.559
max	1861.700

*mean*	1768.200
σ	226.466
min	1470.000
max	1983.000

*mean*	3.222
σ	0.313
min	2.879
max	3.550

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.772
σ	0.102
min	1.606
max	1.866

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.186
σ	577.139
min	157.615
max	1311.895

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1469.000
σ	0.000
min	1469.000
max	1469.000

*mean*	0.539
σ	0.557
min	0.260
max	1.375

policies=20

*mean*	1576.427
σ	0.358
min	1576.186
max	1576.959

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1469.000
σ	0.000
min	1469.000
max	1469.000

*mean*	2.637
σ	0.030
min	2.607
max	2.672

policies=200

*mean*	15772.201
σ	0.164
min	15772.078
max	15772.439

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1469.000
σ	0.000
min	1469.000
max	1469.000

*mean*	26.440
σ	0.062
min	26.365
max	26.513