Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.521
σ	0.371
min	54.375
max	55.578

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.138
σ	0.005
min	0.131
max	0.145

cache=y

dps=1

iters=10

policies=100

*mean*	43.765
σ	0.006
min	43.756
max	43.775

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.120
σ	0.005
min	0.115
max	0.129

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*	4286.875
σ	1980.829
min	1551.000
max	7212.000

*mean*	85.986
σ	209.412
min	11.790
max	604.254

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.618
σ	0.002
min	36.616
max	36.620

*mean*	4286.875
σ	1980.829
min	1551.000
max	7212.000

*mean*	13.101
σ	2.899
min	11.293
max	20.164

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	14.289
σ	0.922
min	12.326
max	14.995

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	13.121
σ	1.089
min	11.180
max	13.943

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.931

*mean*	4170.750
σ	1903.567
min	1551.000
max	7212.000

*mean*	12.689
σ	1.775
min	10.243
max	14.870

iterations=8

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

rows=200000

*mean*	27.605
σ	0.002
min	27.603
max	27.607

*mean*	4170.750
σ	1903.567
min	1551.000
max	7212.000

*mean*	8.583
σ	0.399
min	8.035
max	9.081

iterations=8

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

rows=200000

*mean*	26.400
σ	0.001
min	26.399
max	26.403

*mean*	4170.750
σ	1903.567
min	1551.000
max	7212.000

*mean*	6.542
σ	0.201
min	6.191
max	6.837

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.666
σ	0.002
min	25.665
max	25.668

*mean*	4286.875
σ	1980.829
min	1551.000
max	7212.000

*mean*	5.830
σ	0.555
min	5.456
max	7.178

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*	4286.875
σ	1980.829
min	1551.000
max	7212.000

*mean*	5.360
σ	0.606
min	5.098
max	6.858

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969
σ	0.002
min	25.967
max	25.971

*mean*	4286.875
σ	1980.829
min	1551.000
max	7212.000

*mean*	5.485
σ	0.600
min	5.158
max	6.963

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat

rows=200000

*mean*	25.969
σ	0.002
min	25.967
max	25.971

*mean*	4286.875
σ	1980.829
min	1551.000
max	7212.000

*mean*	5.345
σ	0.597
min	5.017
max	6.813

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.596
σ	0.002
min	2524.594
max	2524.598

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	1395.889
σ	620.701
min	1029.677
max	2745.486

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.560
σ	0.040
min	8744.545
max	8744.659

*mean*	3591.875
σ	1818.697
min	1071.000
max	5824.000

*mean*	5096.113
σ	1698.411
min	3529.306
max	7145.901

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.001
min	62.076
max	62.080

*mean*	4170.750
σ	1903.567
min	1551.000
max	7212.000

*mean*	76.318
σ	5.383
min	70.639
max	86.181

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.075
max	62.080

*mean*	4170.750
σ	1903.567
min	1551.000
max	7212.000

*mean*	76.707
σ	5.666
min	70.672
max	87.296

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.945
σ	0.002
min	40.944
max	40.949

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	103.306
σ	7.930
min	87.509
max	108.355

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.945
σ	0.002
min	40.943
max	40.947

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	103.169
σ	7.868
min	87.417
max	108.289

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

*mean*	105.434
σ	7.213
min	93.635
max	113.265

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat

rows=200000

*mean*	40.950
σ	0.002
min	40.949
max	40.953

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	103.439
σ	7.984
min	87.300
max	108.965

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

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	226.278
σ	187.230
min	138.884
max	688.907

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat

rows=200000

*mean*	66.686
σ	0.001
min	66.685
max	66.689

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	156.881
σ	15.881
min	128.715
max	168.691

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=table_records()

rows=200000

*mean*	11656.833
σ	4.319
min	11655.305
max	11667.523

*mean*	4170.750
σ	1903.567
min	1551.000
max	7212.000

*mean*	6679.456
σ	1331.028
min	4932.677
max	8098.121

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.066
σ	0.002
min	11560.064
max	11560.069

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	5413.819
σ	1397.137
min	4388.454
max	7783.052

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.660
σ	0.014
min	172.633
max	172.672

*mean*	488.000
σ	0.000
min	488.000
max	488.000

*mean*	383.124
σ	32.446
min	318.726
max	423.613

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.468
σ	0.158
min	357.321
max	357.641

*mean*	565.000
σ	0.000
min	565.000
max	565.000

*mean*	801.016
σ	4.972
min	793.511
max	808.137

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.079
σ	0.762
min	1007.608
max	1011.229

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	1.522
σ	0.117
min	1.414
max	1.837

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

*mean*	0.316
σ	0.116
min	0.252
max	0.523

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.651
σ	0.084
min	0.597
max	0.798

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.505
σ	0.043
min	0.440
max	0.560

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.848
σ	0.036
min	0.814
max	0.906

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.551
σ	0.027
min	963.523
max	963.584

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.817
σ	0.035
min	0.772
max	0.857

name=cdr_enhanced_4k_loc.art

*mean*	884.853
σ	0.006
min	884.847
max	884.861

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.715
σ	0.029
min	0.682
max	0.744

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

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	4.254
σ	0.081
min	4.102
max	4.569

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	4.234
σ	0.068
min	4.113
max	4.428

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.744
σ	0.024
min	0.656
max	0.849

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.716
σ	0.016
min	0.688
max	0.797

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.508
σ	0.205
min	297.304
max	298.028

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.587
σ	0.034
min	0.524
max	0.613

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.728
σ	0.036
min	289.674
max	289.776

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.388
σ	0.002
min	0.386
max	0.391

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.645
σ	0.104
min	1299.512
max	1299.761

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	1.865
σ	0.088
min	1.797
max	1.989

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.654
σ	4.040
min	1540.632
max	1549.873

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	2.387
σ	0.182
min	2.125
max	2.567

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.606
σ	0.080
min	1861.497
max	1861.702

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	2.904
σ	0.061
min	2.826
max	2.968

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.627
σ	0.307
min	1.275
max	1.869

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.146
σ	577.064
min	157.612
max	1311.741

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.532
σ	0.524
min	0.269
max	1.319

policies=20

*mean*	1576.402
σ	0.350
min	1576.165
max	1576.922

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	2.629
σ	0.021
min	2.608
max	2.650

policies=200

*mean*	15771.937
σ	0.086
min	15771.851
max	15772.013

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	26.529
σ	0.065
min	26.471
max	26.585