Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617
σ	0.351
min	54.484
max	55.615

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.143
σ	0.004
min	0.139
max	0.150

cache=y

dps=1

iters=10

policies=100

*mean*	43.786
σ	0.007
min	43.776
max	43.801

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.124
σ	0.004
min	0.120
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.875
σ	1977.368
min	1548.000
max	7213.000

*mean*	56.637
σ	124.170
min	12.467
max	363.942

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.618
σ	0.002
min	36.616
max	36.620

*mean*	4285.875
σ	1977.368
min	1548.000
max	7213.000

*mean*	12.512
σ	0.559
min	12.134
max	13.824

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.933

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	15.117
σ	0.874
min	13.437
max	15.803

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	14.587
σ	0.921
min	13.108
max	15.758

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.928
σ	0.002
min	41.927
max	41.932

*mean*	4168.625
σ	1899.901
min	1548.000
max	7213.000

*mean*	13.877
σ	1.645
min	11.081
max	15.428

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*	4168.625
σ	1899.901
min	1548.000
max	7213.000

*mean*	9.396
σ	0.371
min	8.812
max	9.792

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*	4168.625
σ	1899.901
min	1548.000
max	7213.000

*mean*	7.003
σ	0.367
min	6.558
max	7.610

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.875
σ	1977.368
min	1548.000
max	7213.000

*mean*	6.085
σ	0.142
min	5.827
max	6.309

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.875
σ	1977.368
min	1548.000
max	7213.000

*mean*	5.652
σ	0.211
min	5.339
max	6.014

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4285.875
σ	1977.368
min	1548.000
max	7213.000

*mean*	5.278
σ	0.222
min	5.013
max	5.648

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*	4285.875
σ	1977.368
min	1548.000
max	7213.000

*mean*	5.169
σ	0.234
min	4.927
max	5.602

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

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	1482.641
σ	687.227
min	1048.360
max	2846.299

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.560
σ	0.041
min	8744.544
max	8744.661

*mean*	3590.875
σ	1813.257
min	1073.000
max	5817.000

*mean*	4621.477
σ	1205.577
min	3560.565
max	6253.265

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.625
σ	1899.901
min	1548.000
max	7213.000

*mean*	81.471
σ	9.275
min	71.796
max	99.040

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.078
σ	0.002
min	62.076
max	62.080

*mean*	4168.625
σ	1899.901
min	1548.000
max	7213.000

*mean*	82.608
σ	9.578
min	72.754
max	101.619

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.945
σ	0.002
min	40.943
max	40.947

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	102.994
σ	6.547
min	90.775
max	107.069

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

*mean*	103.272
σ	6.649
min	91.292
max	107.503

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

*mean*	104.696
σ	5.931
min	94.293
max	109.153

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

*mean*	103.433
σ	6.711
min	91.034
max	107.850

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

*mean*	225.617
σ	186.164
min	141.991
max	685.751

iterations=8

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

rows=200000

*mean*	66.686
σ	0.002
min	66.685
max	66.689

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	155.532
σ	16.456
min	122.447
max	167.952

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=table_records()

rows=200000

*mean*	11656.834
σ	4.318
min	11655.305
max	11667.520

*mean*	4168.625
σ	1899.901
min	1548.000
max	7213.000

*mean*	6984.002
σ	1115.760
min	4949.293
max	8156.798

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.066
σ	0.002
min	11560.064
max	11560.068

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	5551.112
σ	1195.174
min	4451.280
max	7526.822

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.662
σ	0.018
min	172.637
max	172.684

*mean*	487.500
σ	0.926
min	487.000
max	489.000

*mean*	383.744
σ	40.466
min	315.300
max	425.758

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.461
σ	0.150
min	357.321
max	357.629

*mean*	572.000
σ	0.000
min	572.000
max	572.000

*mean*	808.899
σ	33.118
min	778.082
max	879.233

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.081
σ	0.761
min	1007.610
max	1011.227

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	1.486
σ	0.086
min	1.403
max	1.645

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

*mean*	0.337
σ	0.107
min	0.266
max	0.516

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.786
σ	0.088
min	0.632
max	0.843

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.530
σ	0.032
min	0.507
max	0.584

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.841
σ	0.038
min	0.810
max	0.905

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.550
σ	0.023
min	963.527
max	963.584

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.802
σ	0.063
min	0.696
max	0.849

name=cdr_enhanced_4k_loc.art

*mean*	884.853
σ	0.009
min	884.847
max	884.867

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.705
σ	0.030
min	0.677
max	0.739

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

*mean*	4.273
σ	0.083
min	4.117
max	4.526

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.660

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	4.234
σ	0.086
min	4.097
max	4.518

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.749
σ	0.034
min	0.565
max	0.932

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.710
σ	0.018
min	0.651
max	0.790

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.432
σ	0.220
min	297.257
max	298.038

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.597
σ	0.064
min	0.515
max	0.734

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.736
σ	0.035
min	289.680
max	289.779

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.389
σ	0.001
min	0.388
max	0.392

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.641
σ	0.093
min	1299.525
max	1299.750

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	1.888
σ	0.085
min	1.821
max	2.026

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.616
σ	4.054
min	1540.575
max	1549.861

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	2.227
σ	0.215
min	2.043
max	2.589

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.599
σ	0.050
min	1861.532
max	1861.651

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	3.041
σ	0.173
min	2.876
max	3.335

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.530
σ	0.168
min	1.299
max	1.711

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.150
σ	577.064
min	157.616
max	1311.746

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.568
σ	0.598
min	0.268
max	1.464

policies=20

*mean*	1576.418
σ	0.350
min	1576.192
max	1576.941

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	2.652
σ	0.040
min	2.627
max	2.712

policies=200

*mean*	15772.186
σ	0.170
min	15772.048
max	15772.406

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	26.588
σ	0.103
min	26.480
max	26.727