Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.522
σ	0.369
min	54.386
max	55.572

*mean*	415.000
σ	0.000
min	415.000
max	415.000

*mean*	0.140
σ	0.005
min	0.135
max	0.150

cache=y

dps=1

iters=10

policies=100

*mean*	43.766
σ	0.005
min	43.762
max	43.779

*mean*	415.000
σ	0.000
min	415.000
max	415.000

*mean*	0.123
σ	0.004
min	0.119
max	0.131

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*	4285.375
σ	1975.415
min	1550.000
max	7212.000

*mean*	89.209
σ	216.713
min	12.302
max	625.546

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4285.375
σ	1975.415
min	1550.000
max	7212.000

*mean*	13.072
σ	1.472
min	11.581
max	16.330

iterations=8

operation_display=table_records(), no indexes

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*	14.897
σ	0.768
min	13.570
max	15.683

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.770
σ	0.833
min	12.533
max	14.468

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.932

*mean*	4168.500
σ	1898.275
min	1550.000
max	7212.000

*mean*	13.685
σ	1.655
min	11.469
max	15.702

iterations=8

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

rows=200000

*mean*	27.605
σ	0.003
min	27.603
max	27.611

*mean*	4168.500
σ	1898.275
min	1550.000
max	7212.000

*mean*	8.791
σ	0.348
min	8.121
max	9.092

iterations=8

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

rows=200000

*mean*	26.400
σ	0.002
min	26.399
max	26.403

*mean*	4168.500
σ	1898.275
min	1550.000
max	7212.000

*mean*	6.882
σ	0.166
min	6.630
max	7.063

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.666
σ	0.002
min	25.664
max	25.668

*mean*	4285.375
σ	1975.415
min	1550.000
max	7212.000

*mean*	6.037
σ	0.161
min	5.792
max	6.260

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*	4285.375
σ	1975.415
min	1550.000
max	7212.000

*mean*	5.678
σ	0.148
min	5.546
max	5.914

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*	4285.375
σ	1975.415
min	1550.000
max	7212.000

*mean*	5.694
σ	0.090
min	5.549
max	5.805

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*	4285.375
σ	1975.415
min	1550.000
max	7212.000

*mean*	5.569
σ	0.068
min	5.449
max	5.674

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

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	1382.551
σ	585.142
min	1033.996
max	2692.686

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.041
min	8744.545
max	8744.661

*mean*	3591.125
σ	1810.589
min	1074.000
max	5813.000

*mean*	4711.496
σ	1476.842
min	3530.895
max	7345.558

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*	4168.500
σ	1898.275
min	1550.000
max	7212.000

*mean*	80.569
σ	9.150
min	71.061
max	99.065

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.075
max	62.080

*mean*	4168.500
σ	1898.275
min	1550.000
max	7212.000

*mean*	81.059
σ	9.588
min	71.226
max	100.387

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.944
σ	0.001
min	40.943
max	40.947

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	104.167
σ	6.672
min	91.981
max	108.984

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.946
σ	0.002
min	40.943
max	40.947

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	104.102
σ	6.645
min	91.823
max	108.670

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end

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*	105.533
σ	6.481
min	95.440
max	112.136

iterations=8

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

rows=200000

*mean*	40.951
σ	0.002
min	40.948
max	40.953

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	104.059
σ	6.463
min	92.228
max	109.044

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*	231.981
σ	202.974
min	143.501
max	733.749

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

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	157.178
σ	13.836
min	132.880
max	168.797

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*	4168.500
σ	1898.275
min	1550.000
max	7212.000

*mean*	6413.541
σ	1364.381
min	4957.244
max	8147.489

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.065
σ	0.001
min	11560.064
max	11560.068

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	5442.876
σ	1406.573
min	4397.054
max	7700.400

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.666
σ	0.008
min	172.649
max	172.674

*mean*	488.000
σ	0.000
min	488.000
max	488.000

*mean*	402.852
σ	20.799
min	362.500
max	421.716

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.467
σ	0.158
min	357.321
max	357.659

*mean*	564.000
σ	0.000
min	564.000
max	564.000

*mean*	788.726
σ	26.996
min	741.335
max	825.094

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.082
σ	0.761
min	1007.608
max	1011.229

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	1.549
σ	0.190
min	1.399
max	2.182

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.311
σ	0.114
min	0.247
max	0.513

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.646
σ	0.071
min	0.605
max	0.771

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.540
σ	0.054
min	0.499
max	0.634

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.863
σ	0.031
min	0.837
max	0.916

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.552
σ	0.023
min	963.528
max	963.582

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.770
σ	0.075
min	0.694
max	0.847

name=cdr_enhanced_4k_loc.art

*mean*	884.853
σ	0.005
min	884.847
max	884.860

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.703
σ	0.044
min	0.648
max	0.738

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

*mean*	4.211
σ	0.092
min	3.850
max	4.491

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.659

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	4.190
σ	0.075
min	4.047
max	4.429

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.745
σ	0.020
min	0.712
max	0.875

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.708
σ	0.040
min	0.529
max	0.802

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.371
σ	0.274
min	297.062
max	297.908

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.581
σ	0.023
min	0.517
max	0.602

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.720
σ	0.035
min	289.673
max	289.766

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.391
σ	0.004
min	0.387
max	0.397

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.645
σ	0.112
min	1299.506
max	1299.773

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	1.891
σ	0.087
min	1.798
max	2.001

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.709
σ	4.013
min	1540.724
max	1549.882

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	2.450
σ	0.396
min	2.119
max	3.076

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.610
σ	0.071
min	1861.509
max	1861.684

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	2.883
σ	0.039
min	2.854
max	2.951

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.558
σ	0.362
min	1.001
max	1.847

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.146
σ	577.064
min	157.612
max	1311.743

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.539
σ	0.540
min	0.269
max	1.349

policies=20

*mean*	1576.398
σ	0.345
min	1576.164
max	1576.910

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	2.635
σ	0.015
min	2.617
max	2.650

policies=200

*mean*	15771.955
σ	0.129
min	15771.791
max	15772.061

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	26.585
σ	0.168
min	26.384
max	26.758