Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	53.703
σ	0.368
min	53.556
max	54.750

*mean*	415.000
σ	0.000
min	415.000
max	415.000

*mean*	0.136
σ	0.004
min	0.130
max	0.142

cache=y

dps=1

iters=10

policies=100

*mean*	43.058
σ	0.005
min	43.051
max	43.066

*mean*	415.000
σ	0.000
min	415.000
max	415.000

*mean*	0.119
σ	0.004
min	0.113
max	0.127

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=column_set() on indexed

rows=200000

*mean*	36.618
σ	0.002
min	36.615
max	36.620

*mean*	4167.000
σ	1897.389
min	1551.000
max	7198.000

*mean*	12.828
σ	0.366
min	12.412
max	13.521

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4286.750
σ	1976.947
min	1551.000
max	7198.000

*mean*	81.752
σ	195.336
min	11.882
max	565.181

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.929
σ	0.001
min	41.928
max	41.932

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	14.892
σ	1.267
min	12.151
max	15.707

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	13.960
σ	1.257
min	11.290
max	15.350

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.932

*mean*	4167.000
σ	1897.389
min	1551.000
max	7198.000

*mean*	13.649
σ	1.485
min	11.585
max	15.312

iterations=8

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

rows=200000

*mean*	27.604
σ	0.002
min	27.603
max	27.607

*mean*	4167.000
σ	1897.389
min	1551.000
max	7198.000

*mean*	9.083
σ	0.337
min	8.330
max	9.427

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*	4167.000
σ	1897.389
min	1551.000
max	7198.000

*mean*	6.505
σ	0.365
min	5.846
max	6.880

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.667
σ	0.002
min	25.665
max	25.670

*mean*	4286.750
σ	1976.947
min	1551.000
max	7198.000

*mean*	6.054
σ	0.094
min	5.920
max	6.186

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.750
σ	1976.947
min	1551.000
max	7198.000

*mean*	5.678
σ	0.226
min	5.200
max	5.964

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.750
σ	1976.947
min	1551.000
max	7198.000

*mean*	5.705
σ	0.204
min	5.274
max	5.934

iterations=8

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

rows=200000

*mean*	25.968
σ	0.001
min	25.967
max	25.971

*mean*	4286.750
σ	1976.947
min	1551.000
max	7198.000

*mean*	5.543
σ	0.233
min	5.035
max	5.839

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

*mean*	1179.823
σ	398.268
min	1033.396
max	2165.444

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.042
min	8744.545
max	8744.665

*mean*	3594.625
σ	1816.551
min	1075.000
max	5832.000

*mean*	4448.307
σ	1320.628
min	3498.189
max	6978.018

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

*mean*	4167.000
σ	1897.389
min	1551.000
max	7198.000

*mean*	80.898
σ	8.824
min	73.991
max	98.885

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4167.000
σ	1897.389
min	1551.000
max	7198.000

*mean*	82.215
σ	8.771
min	75.330
max	99.764

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.944
σ	0.001
min	40.944
max	40.947

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	102.883
σ	8.929
min	85.031
max	109.256

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.946
σ	0.002
min	40.944
max	40.947

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	103.152
σ	8.984
min	85.483
max	109.756

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

*mean*	105.614
σ	8.179
min	92.220
max	112.441

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

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	103.124
σ	8.918
min	85.414
max	109.986

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

*mean*	208.726
σ	145.962
min	133.404
max	568.690

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

*mean*	151.310
σ	20.957
min	108.493
max	167.243

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*	4167.000
σ	1897.389
min	1551.000
max	7198.000

*mean*	5984.266
σ	1009.545
min	4878.768
max	8109.332

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.065
σ	0.001
min	11560.065
max	11560.068

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	5745.796
σ	1630.646
min	4358.814
max	8499.389

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.666
σ	0.013
min	172.647
max	172.681

*mean*	486.000
σ	0.000
min	486.000
max	486.000

*mean*	396.220
σ	27.429
min	348.143
max	421.595

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.467
σ	0.155
min	357.321
max	357.642

*mean*	566.000
σ	0.000
min	566.000
max	566.000

*mean*	741.341
σ	68.953
min	622.588
max	869.523

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1005.002
σ	0.750
min	1004.525
max	1008.102

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	1.603
σ	0.120
min	1.474
max	1.979

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

*mean*	0.318
σ	0.104
min	0.258
max	0.502

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	0.638
σ	0.073
min	0.594
max	0.767

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	0.425
σ	0.062
min	0.376
max	0.521

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	0.854
σ	0.044
min	0.819
max	0.930

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.552
σ	0.024
min	963.527
max	963.582

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	0.798
σ	0.036
min	0.759
max	0.838

name=cdr_enhanced_4k_loc.art

*mean*	884.853
σ	0.007
min	884.847
max	884.863

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	0.727
σ	0.020
min	0.691
max	0.740

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

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	4.148
σ	0.307
min	2.799
max	4.645

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.660

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	3.523
σ	0.066
min	3.356
max	3.739

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	0.543
σ	0.017
min	0.515
max	0.629

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	0.512
σ	0.013
min	0.486
max	0.584

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	294.266
σ	0.282
min	294.070
max	295.036

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	0.588
σ	0.041
min	0.503
max	0.621

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	281.466
σ	0.037
min	281.409
max	281.507

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	0.391
σ	0.008
min	0.387
max	0.405

iters=5

new-facts=1

prior-facts=6402

*mean*	1291.493
σ	0.102
min	1291.365
max	1291.611

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	2.015
σ	0.215
min	1.760
max	2.313

iters=5

new-facts=6402

prior-facts=1

*mean*	1534.394
σ	4.031
min	1532.413
max	1541.601

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	2.350
σ	0.221
min	2.132
max	2.632

iters=5

new-facts=6402

prior-facts=6402

*mean*	1853.314
σ	0.053
min	1853.262
max	1853.377

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	3.072
σ	0.315
min	2.842
max	3.627

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.574
σ	0.214
min	1.295
max	1.895

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	442.430
σ	577.064
min	153.896
max	1308.027

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	0.542
σ	0.549
min	0.265
max	1.366

policies=20

*mean*	1539.228
σ	0.315
min	1539.007
max	1539.694

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	2.584
σ	0.028
min	2.558
max	2.610

policies=200

*mean*	15400.385
σ	0.066
min	15400.293
max	15400.438

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7198.000
σ	0.000
min	7198.000
max	7198.000

*mean*	26.211
σ	0.136
min	26.093
max	26.395