Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617
σ	0.353
min	54.483
max	55.621

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.140
σ	0.004
min	0.135
max	0.146

cache=y

dps=1

iters=10

policies=100

*mean*	43.786
σ	0.007
min	43.778
max	43.801

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.123
σ	0.004
min	0.120
max	0.130

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on indexed

*mean*	36.618
σ	0.003
min	36.615
max	36.623

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	12.965
σ	1.845
min	11.906
max	17.485

op=column_set() on indexed, repeat

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	13.339
σ	1.704
min	12.435
max	17.532

op=table_records(), no indexes

*mean*	41.928
σ	0.000
min	41.928
max	41.928

*mean*	7535.000
σ	0.000
min	7535.000
max	7535.000

*mean*	13.764
σ	1.089
min	12.704
max	15.774

op=table_records(), repeat

*mean*	41.928
σ	0.002
min	41.927
max	41.932

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	12.288
σ	2.170
min	10.164
max	14.880

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

*mean*	27.605
σ	0.002
min	27.603
max	27.607

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	8.575
σ	1.366
min	7.635
max	11.847

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

*mean*	26.401
σ	0.002
min	26.399
max	26.403

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	6.741
σ	1.140
min	6.057
max	9.520

op=vertical_lookup_row_list() on 2 indexed

*mean*	25.666
σ	0.002
min	25.664
max	25.670

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	5.533
σ	0.566
min	5.134
max	6.903

op=vertical_lookup_row_list() on 3 (1 unindexed)

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	5.394
σ	0.483
min	5.055
max	6.567

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

*mean*	1103.878
σ	161.657
min	1038.142
max	1503.619

op=load_product(), with indexes

*mean*	8744.558
σ	0.033
min	8744.544
max	8744.640

*mean*	3793.875
σ	1596.206
min	2018.000
max	5941.000

*mean*	4426.395
σ	1217.723
min	3532.249
max	6260.544

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

*mean*	62.077
σ	0.002
min	62.075
max	62.080

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	80.679
σ	9.784
min	71.686
max	101.646

op=vertical_lookup_list() on unindexed missing Int

*mean*	40.944
σ	0.001
min	40.943
max	40.945

*mean*	7535.000
σ	0.000
min	7535.000
max	7535.000

*mean*	101.022
σ	6.468
min	90.263
max	107.541

op=vertical_lookup_row_list() on unindexed small unique Int

*mean*	66.686
σ	0.000
min	66.685
max	66.687

*mean*	7535.000
σ	0.000
min	7535.000
max	7535.000

*mean*	151.047
σ	15.168
min	125.072
max	167.824

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.833
σ	4.317
min	11655.305
max	11667.517

*mean*	4267.500
σ	1869.195
min	2018.000
max	7535.000

*mean*	6150.674
σ	1027.600
min	4966.317
max	8041.591

op=vertical_lookup_list() on indexed

*mean*	11560.068
σ	0.002
min	11560.066
max	11560.072

*mean*	7535.000
σ	0.000
min	7535.000
max	7535.000

*mean*	5466.772
σ	1386.395
min	4349.196
max	7396.168

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.588
σ	0.024
min	172.558
max	172.627

*mean*	2018.000
σ	0.000
min	2018.000
max	2018.000

*mean*	377.907
σ	39.261
min	341.882
max	457.952

op=pointedIndexFromKvs

rows=400000

*mean*	357.370
σ	0.045
min	357.321
max	357.428

*mean*	2018.000
σ	0.000
min	2018.000
max	2018.000

*mean*	762.389
σ	52.510
min	641.448
max	805.434

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.185
σ	0.886
min	1007.687
max	1011.862

*mean*	1043.000
σ	307.729
min	547.000
max	1475.000

*mean*	1.544
σ	0.082
min	1.460
max	1.778

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

*mean*	0.402
σ	0.109
min	0.329
max	0.596

name=error_case.art

*mean*	2.334
σ	0.002
min	2.332
max	2.337

*mean*	1475.000
σ	0.000
min	1475.000
max	1475.000

*mean*	0.885
σ	0.085
min	0.834
max	1.035

name=heavy_item.art

*mean*	1.522
σ	0.002
min	1.520
max	1.524

*mean*	1475.000
σ	0.000
min	1475.000
max	1475.000

*mean*	0.537
σ	0.051
min	0.494
max	0.623

name=nested_use.art

*mean*	2.356
σ	0.002
min	2.355
max	2.358

*mean*	1475.000
σ	0.000
min	1475.000
max	1475.000

*mean*	0.848
σ	0.048
min	0.814
max	0.930

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.543
σ	0.024
min	963.523
max	963.583

*mean*	1475.000
σ	0.000
min	1475.000
max	1475.000

*mean*	0.761
σ	0.060
min	0.679
max	0.839

name=cdr_enhanced_4k_loc.art

*mean*	884.854
σ	0.007
min	884.847
max	884.864

*mean*	1475.000
σ	0.000
min	1475.000
max	1475.000

*mean*	0.712
σ	0.045
min	0.662
max	0.754

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

*mean*	4.282
σ	0.101
min	4.117
max	4.593

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.659

*mean*	1475.000
σ	0.000
min	1475.000
max	1475.000

*mean*	4.256
σ	0.095
min	4.126
max	4.546

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1475.000
σ	0.000
min	1475.000
max	1475.000

*mean*	0.747
σ	0.016
min	0.716
max	0.858

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1475.000
σ	0.000
min	1475.000
max	1475.000

*mean*	0.708
σ	0.016
min	0.682
max	0.760

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.605
σ	0.249
min	297.395
max	298.282

*mean*	2018.000
σ	0.000
min	2018.000
max	2018.000

*mean*	0.561
σ	0.035
min	0.504
max	0.604

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.775
σ	0.037
min	289.723
max	289.815

*mean*	1475.000
σ	0.000
min	1475.000
max	1475.000

*mean*	0.403
σ	0.011
min	0.396
max	0.422

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.618
σ	0.091
min	1299.506
max	1299.727

*mean*	1475.000
σ	0.000
min	1475.000
max	1475.000

*mean*	1.856
σ	0.067
min	1.767
max	1.922

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.618
σ	4.026
min	1540.591
max	1549.812

*mean*	1475.000
σ	0.000
min	1475.000
max	1475.000

*mean*	2.294
σ	0.168
min	2.065
max	2.532

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.650
σ	0.081
min	1861.549
max	1861.733

*mean*	1718.000
σ	204.666
min	1538.000
max	2018.000

*mean*	3.017
σ	0.320
min	2.822
max	3.580

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.703
σ	0.127
min	1.582
max	1.841

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.186
σ	577.140
min	157.614
max	1311.895

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1475.000
σ	0.000
min	1475.000
max	1475.000

*mean*	0.553
σ	0.577
min	0.261
max	1.418

policies=20

*mean*	1576.418
σ	0.342
min	1576.189
max	1576.926

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1475.000
σ	0.000
min	1475.000
max	1475.000

*mean*	2.616
σ	0.008
min	2.608
max	2.626

policies=200

*mean*	15772.316
σ	0.119
min	15772.229
max	15772.490

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1475.000
σ	0.000
min	1475.000
max	1475.000

*mean*	26.360
σ	0.219
min	26.034
max	26.497