Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.521
σ	0.369
min	54.378
max	55.570

*mean*	415.000
σ	0.000
min	415.000
max	415.000

*mean*	0.139
σ	0.004
min	0.135
max	0.145

cache=y

dps=1

iters=10

policies=100

*mean*	43.765
σ	0.006
min	43.756
max	43.774

*mean*	415.000
σ	0.000
min	415.000
max	415.000

*mean*	0.124
σ	0.003
min	0.121
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*	4277.500
σ	1969.364
min	1550.000
max	7169.000

*mean*	12.603
σ	0.166
min	12.357
max	12.852

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4277.500
σ	1969.364
min	1550.000
max	7169.000

*mean*	12.609
σ	0.805
min	11.691
max	13.886

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	15.089
σ	0.891
min	13.651
max	16.195

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	13.566
σ	0.876
min	11.802
max	14.626

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.931

*mean*	4161.250
σ	1891.623
min	1550.000
max	7169.000

*mean*	13.575
σ	1.980
min	10.899
max	15.598

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*	4161.250
σ	1891.623
min	1550.000
max	7169.000

*mean*	9.123
σ	0.260
min	8.687
max	9.426

iterations=8

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

rows=200000

*mean*	26.401
σ	0.002
min	26.399
max	26.403

*mean*	4161.250
σ	1891.623
min	1550.000
max	7169.000

*mean*	6.860
σ	0.269
min	6.330
max	7.129

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.666
σ	0.002
min	25.664
max	25.670

*mean*	4277.500
σ	1969.364
min	1550.000
max	7169.000

*mean*	6.145
σ	0.070
min	6.046
max	6.246

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*	4277.500
σ	1969.364
min	1550.000
max	7169.000

*mean*	5.786
σ	0.170
min	5.609
max	6.052

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969
σ	0.002
min	25.967
max	25.972

*mean*	4277.500
σ	1969.364
min	1550.000
max	7169.000

*mean*	5.820
σ	0.129
min	5.668
max	6.004

iterations=8

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

rows=200000

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4277.500
σ	1969.364
min	1550.000
max	7169.000

*mean*	5.704
σ	0.108
min	5.564
max	5.828

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

*mean*	1469.329
σ	703.140
min	1034.058
max	2955.897

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.560
σ	0.040
min	8744.545
max	8744.659

*mean*	3587.625
σ	1814.809
min	1070.000
max	5814.000

*mean*	4334.979
σ	1324.480
min	3514.565
max	6961.662

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

*mean*	4161.250
σ	1891.623
min	1550.000
max	7169.000

*mean*	77.584
σ	9.762
min	70.111
max	98.163

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.078
σ	0.003
min	62.076
max	62.083

*mean*	4161.250
σ	1891.623
min	1550.000
max	7169.000

*mean*	78.491
σ	9.870
min	70.831
max	99.179

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.945
σ	0.002
min	40.944
max	40.947

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	104.173
σ	8.080
min	87.581
max	109.055

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.945
σ	0.002
min	40.943
max	40.948

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	104.114
σ	8.152
min	87.252
max	109.015

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

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	106.367
σ	7.442
min	93.517
max	114.164

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

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	104.373
σ	8.169
min	87.523
max	109.680

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.686
σ	0.001
min	66.685
max	66.689

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	226.007
σ	185.652
min	137.503
max	684.585

iterations=8

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

rows=200000

*mean*	66.687
σ	0.002
min	66.685
max	66.689

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	155.209
σ	19.504
min	115.824
max	171.124

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=table_records()

rows=200000

*mean*	11656.833
σ	4.318
min	11655.305
max	11667.520

*mean*	4161.250
σ	1891.623
min	1550.000
max	7169.000

*mean*	5906.444
σ	1233.360
min	4886.992
max	8042.867

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.065
σ	0.001
min	11560.064
max	11560.068

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	5649.305
σ	1436.890
min	4358.053
max	7660.982

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.661
σ	0.013
min	172.641
max	172.675

*mean*	485.125
σ	0.354
min	485.000
max	486.000

*mean*	375.499
σ	42.702
min	307.448
max	420.015

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.464
σ	0.151
min	357.321
max	357.668

*mean*	562.000
σ	0.000
min	562.000
max	562.000

*mean*	773.815
σ	69.164
min	614.082
max	820.317

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.080
σ	0.761
min	1007.606
max	1011.227

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	1.560
σ	0.134
min	1.398
max	1.772

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.884
σ	0.003
min	0.881
max	0.887

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	0.449
σ	0.140
min	0.336
max	0.666

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	0.890
σ	0.102
min	0.826
max	1.069

name=heavy_item.art

*mean*	1.522
σ	0.002
min	1.520
max	1.525

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	0.549
σ	0.040
min	0.521
max	0.617

name=nested_use.art

*mean*	2.356
σ	0.002
min	2.355
max	2.358

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	0.851
σ	0.037
min	0.818
max	0.914

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.548
σ	0.021
min	963.526
max	963.582

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	0.799
σ	0.036
min	0.764
max	0.845

name=cdr_enhanced_4k_loc.art

*mean*	884.856
σ	0.005
min	884.847
max	884.859

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	0.612
σ	0.058
min	0.510
max	0.651

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

*mean*	3.490
σ	0.094
min	3.277
max	3.819

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	3.523
σ	0.088
min	3.285
max	3.813

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	0.538
σ	0.022
min	0.373
max	0.623

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	0.514
σ	0.015
min	0.480
max	0.593

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.302
σ	0.217
min	297.151
max	297.905

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	0.552
σ	0.035
min	0.507
max	0.584

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.723
σ	0.056
min	289.645
max	289.796

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	0.414
σ	0.020
min	0.391
max	0.440

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.638
σ	0.093
min	1299.520
max	1299.728

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	1.913
σ	0.072
min	1.814
max	1.981

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.640
σ	4.088
min	1540.597
max	1549.946

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	2.271
σ	0.212
min	2.117
max	2.603

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.602
σ	0.062
min	1861.505
max	1861.662

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	2.881
σ	0.097
min	2.734
max	2.978

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.433
σ	0.215
min	1.267
max	1.801

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.146
σ	577.066
min	157.610
max	1311.745

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	0.549
σ	0.556
min	0.269
max	1.384

policies=20

*mean*	1576.384
σ	0.343
min	1576.153
max	1576.892

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	2.640
σ	0.041
min	2.601
max	2.677

policies=200

*mean*	15771.978
σ	0.057
min	15771.914
max	15772.049

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7169.000
σ	0.000
min	7169.000
max	7169.000

*mean*	26.500
σ	0.091
min	26.401
max	26.590