Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617-54.617=0.000
σ	0.351-0.350=0.001
min	54.480-54.483=-0.003
max	55.616-55.613=0.003

*mean*	417.000-420.000=-3.000
σ	0.000
min	417.000-420.000=-3.000
max	417.000-420.000=-3.000

*mean*	0.141-0.140=0.001
σ	0.004-0.006=-0.001
min	0.137-0.133=0.004
max	0.148-0.149=-0.001

cache=y

dps=1

iters=10

policies=100

*mean*	43.785-43.785=-0.000
σ	0.005-0.005=0.001
min	43.778-43.779=-0.001
max	43.797-43.796=0.002

*mean*	417.000-420.000=-3.000
σ	0.000
min	417.000-420.000=-3.000
max	417.000-420.000=-3.000

*mean*	0.122-0.124=-0.002
σ	0.005-0.005=-0.000
min	0.117-0.120=-0.003
max	0.131-0.132=-0.001

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*	4292.125
σ	1980.590
min	1555.000
max	7214.000

*mean*	104.475
σ	259.509
min	12.452
max	746.727

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.618
σ	0.002
min	36.616
max	36.620

*mean*	4292.125
σ	1980.590
min	1555.000
max	7214.000

*mean*	13.937
σ	2.551
min	12.447
max	20.194

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7214.000
σ	0.000
min	7214.000
max	7214.000

*mean*	14.931
σ	0.858
min	13.463
max	15.711

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7214.000
σ	0.000
min	7214.000
max	7214.000

*mean*	13.955
σ	0.864
min	12.338
max	15.088

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.928
σ	0.002
min	41.927
max	41.931

*mean*	4175.875
σ	1903.211
min	1555.000
max	7214.000

*mean*	13.702
σ	1.723
min	11.156
max	15.417

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*	4175.875
σ	1903.211
min	1555.000
max	7214.000

*mean*	9.219
σ	0.360
min	8.702
max	9.859

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*	4175.875
σ	1903.211
min	1555.000
max	7214.000

*mean*	6.691
σ	0.494
min	5.950
max	7.429

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*	4292.125
σ	1980.590
min	1555.000
max	7214.000

*mean*	6.336
σ	0.470
min	5.821
max	7.354

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*	4292.125
σ	1980.590
min	1555.000
max	7214.000

*mean*	5.742
σ	0.586
min	5.244
max	7.118

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*	4292.125
σ	1980.590
min	1555.000
max	7214.000

*mean*	5.798
σ	0.624
min	5.197
max	7.239

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*	4292.125
σ	1980.590
min	1555.000
max	7214.000

*mean*	5.704
σ	0.643
min	5.199
max	7.220

op=column_set() on indexed

*mean*	36.618
σ	0.003
min	36.615
max	36.623

*mean*	4269.000
σ	1880.401
min	1984.000
max	7554.000

*mean*	12.760
σ	1.742
min	11.839
max	16.980

op=column_set() on indexed, repeat

*mean*	36.617
σ	0.002
min	36.616
max	36.619

*mean*	4269.000
σ	1880.401
min	1984.000
max	7554.000

*mean*	12.242
σ	2.202
min	11.110
max	17.562

op=table_records(), no indexes

*mean*	41.928
σ	0.000
min	41.928
max	41.929

*mean*	7554.000
σ	0.000
min	7554.000
max	7554.000

*mean*	13.767
σ	1.173
min	12.308
max	15.317

op=table_records(), repeat

*mean*	41.928
σ	0.002
min	41.927
max	41.932

*mean*	4269.000
σ	1880.401
min	1984.000
max	7554.000

*mean*	11.999
σ	1.982
min	9.992
max	15.135

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

*mean*	27.605
σ	0.002
min	27.603
max	27.607

*mean*	4269.000
σ	1880.401
min	1984.000
max	7554.000

*mean*	8.706
σ	1.171
min	7.829
max	11.505

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

*mean*	26.400
σ	0.002
min	26.399
max	26.403

*mean*	4269.000
σ	1880.401
min	1984.000
max	7554.000

*mean*	6.526
σ	1.168
min	5.787
max	9.374

op=vertical_lookup_row_list() on 2 indexed

*mean*	25.666
σ	0.002
min	25.664
max	25.670

*mean*	4269.000
σ	1880.401
min	1984.000
max	7554.000

*mean*	5.588
σ	0.583
min	5.099
max	6.934

op=vertical_lookup_row_list() on 3 (1 unindexed)

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4269.000
σ	1880.401
min	1984.000
max	7554.000

*mean*	5.195
σ	0.572
min	4.716
max	6.517

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

*mean*	1419.739
σ	591.870
min	1043.463
max	2622.294

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.040
min	8744.544
max	8744.659

*mean*	3597.250
σ	1819.794
min	1075.000
max	5830.000

*mean*	5086.829
σ	1719.220
min	3526.435
max	7506.132

op=load_product(), no indexes

*mean*	2524.593
σ	0.000
min	2524.593
max	2524.594

*mean*	7554.000
σ	0.000
min	7554.000
max	7554.000

*mean*	1106.087
σ	169.576
min	1040.152
max	1525.658

op=load_product(), with indexes

*mean*	8744.559
σ	0.033
min	8744.544
max	8744.641

*mean*	3791.375
σ	1610.309
min	1984.000
max	5953.000

*mean*	4655.295
σ	1479.609
min	3540.960
max	7039.120

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*	4175.875
σ	1903.211
min	1555.000
max	7214.000

*mean*	80.744
σ	9.685
min	71.605
max	98.770

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.078
σ	0.002
min	62.076
max	62.080

*mean*	4175.875
σ	1903.211
min	1555.000
max	7214.000

*mean*	81.277
σ	9.720
min	71.857
max	99.602

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

*mean*	103.152
σ	6.879
min	90.154
max	108.046

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.945
σ	0.002
min	40.944
max	40.947

*mean*	7214.000
σ	0.000
min	7214.000
max	7214.000

*mean*	103.291
σ	6.815
min	90.487
max	108.352

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

*mean*	105.929
σ	4.987
min	96.743
max	111.923

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

*mean*	103.285
σ	6.956
min	90.444
max	108.630

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.687
σ	0.002
min	66.686
max	66.689

*mean*	7214.000
σ	0.000
min	7214.000
max	7214.000

*mean*	229.984
σ	198.828
min	142.173
max	721.451

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

*mean*	155.697
σ	15.227
min	127.364
max	169.136

op=column_set() on unindexed, dense

*mean*	62.078
σ	0.002
min	62.075
max	62.080

*mean*	4269.000
σ	1880.401
min	1984.000
max	7554.000

*mean*	83.713
σ	12.712
min	69.068
max	104.720

op=vertical_lookup_list() on unindexed missing Int

*mean*	40.944
σ	0.001
min	40.944
max	40.945

*mean*	7554.000
σ	0.000
min	7554.000
max	7554.000

*mean*	233.445
σ	374.864
min	89.191
max	1160.996

op=vertical_lookup_row_list() on unindexed small unique Int

*mean*	66.686
σ	0.000
min	66.685
max	66.686

*mean*	7554.000
σ	0.000
min	7554.000
max	7554.000

*mean*	150.430
σ	13.786
min	132.158
max	169.614

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

*mean*	4175.875
σ	1903.211
min	1555.000
max	7214.000

*mean*	6553.575
σ	990.032
min	4929.627
max	7999.796

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.066
σ	0.002
min	11560.064
max	11560.069

*mean*	7214.000
σ	0.000
min	7214.000
max	7214.000

*mean*	6094.026
σ	1432.000
min	4436.528
max	7816.731

op=table_records()

*mean*	11656.833
σ	4.318
min	11655.305
max	11667.521

*mean*	4269.000
σ	1880.401
min	1984.000
max	7554.000

*mean*	6430.850
σ	1141.046
min	4954.368
max	8353.089

op=vertical_lookup_list() on indexed

*mean*	11560.069
σ	0.002
min	11560.066
max	11560.072

*mean*	7554.000
σ	0.000
min	7554.000
max	7554.000

*mean*	5562.530
σ	1297.039
min	4429.761
max	7421.386

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.654
σ	0.014
min	172.636
max	172.671

*mean*	491.000
σ	0.000
min	491.000
max	491.000

*mean*	358.329
σ	53.891
min	269.849
max	418.216

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.464
σ	0.147
min	357.321
max	357.633

*mean*	568.000
σ	0.000
min	568.000
max	568.000

*mean*	780.184
σ	44.620
min	717.332
max	819.668

op=pointedIndexFromKvs

rows=200000

*mean*	172.583
σ	0.025
min	172.558
max	172.625

*mean*	1984.000
σ	0.000
min	1984.000
max	1984.000

*mean*	366.525
σ	23.389
min	340.762
max	398.240

op=pointedIndexFromKvs

rows=400000

*mean*	357.364
σ	0.042
min	357.321
max	357.408

*mean*	1984.000
σ	0.000
min	1984.000
max	1984.000

*mean*	729.512
σ	76.289
min	602.890
max	796.626

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.188-1008.081=0.106
σ	0.880-0.761=0.119
min	1007.687-1007.609=0.078
max	1011.834-1011.227=0.607

*mean*	1038.800-7214.000=-6175.200
σ	296.897-0.000=296.897
min	547.000-7214.000=-6667.000
max	1439.000-7214.000=-5775.000

*mean*	1.575-1.561=0.015
σ	0.131-0.157=-0.026
min	1.483-1.454=0.029
max	2.057-2.109=-0.052

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*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	0.416-0.394=0.023
σ	0.127-0.086=0.041
min	0.333-0.339=-0.006
max	0.641-0.545=0.096

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	0.889-0.875=0.014
σ	0.090-0.091=-0.001
min	0.831-0.816=0.015
max	1.045-1.032=0.013

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	0.546-0.536=0.010
σ	0.050-0.036=0.015
min	0.517-0.508=0.008
max	0.636-0.595=0.040

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	0.847-0.839=0.008
σ	0.041-0.033=0.009
min	0.818-0.816=0.001
max	0.919-0.895=0.024

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.543-963.552=-0.010
σ	0.030-0.024=0.006
min	963.523-963.527=-0.004
max	963.596-963.583=0.013

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	0.808-0.770=0.038
σ	0.036-0.062=-0.025
min	0.760-0.702=0.058
max	0.858-0.845=0.012

name=cdr_enhanced_4k_loc.art

*mean*	884.854-884.853=0.001
σ	0.006-0.005=0.001
min	884.847
max	884.862-884.859=0.003

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	0.708-0.720=-0.012
σ	0.040-0.022=0.018
min	0.672-0.685=-0.013
max	0.753-0.737=0.016

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.706-7.706=0.000
σ	0.002-0.002=0.000
min	7.705
max	7.709

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	4.229-4.035=0.194
σ	0.120-0.398=-0.278
min	4.105-3.451=0.655
max	5.140-5.232=-0.092

name=record_render_large_syntax_err.art

*mean*	7.655-7.655=-0.000
σ	0.002-0.002=-0.000
min	7.654
max	7.658-7.661=-0.003

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	4.211-4.281=-0.069
σ	0.063-0.063=-0.000
min	4.086-4.154=-0.068
max	4.400-4.502=-0.101

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	0.754-0.755=-0.001
σ	0.016-0.017=-0.001
min	0.721-0.718=0.003
max	0.849-0.866=-0.016

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	0.713-0.711=0.002
σ	0.014-0.013=0.001
min	0.684-0.685=-0.001
max	0.781-0.761=0.020

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.406-297.375=0.031
σ	0.204-0.231=-0.027
min	297.207-297.197=0.010
max	297.891-298.002=-0.111

*mean*	1984.000-7214.000=-5230.000
σ	0.000
min	1984.000-7214.000=-5230.000
max	1984.000-7214.000=-5230.000

*mean*	0.566-0.563=0.003
σ	0.034-0.028=0.006
min	0.508-0.510=-0.002
max	0.593-0.604=-0.011

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.760-289.722=0.039
σ	0.044-0.052=-0.008
min	289.722-289.643=0.079
max	289.811-289.785=0.026

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	0.404-0.407=-0.003
σ	0.011-0.015=-0.004
min	0.394-0.396=-0.002
max	0.420-0.431=-0.010

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.691-1299.637=0.054
σ	0.092-0.096=-0.005
min	1299.581-1299.517=0.064
max	1299.819-1299.747=0.072

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	2.275-1.955=0.320
σ	0.094-0.095=-0.001
min	2.150-1.815=0.335
max	2.349-2.045=0.304

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.665-1542.645=0.019
σ	4.004-4.145=-0.141
min	1540.705-1540.587=0.117
max	1549.822-1550.053=-0.231

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	2.308-2.369=-0.061
σ	0.129-0.450=-0.321
min	2.177-2.071=0.106
max	2.481-3.157=-0.677

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.628-1861.594=0.034
σ	0.064-0.064=-0.000
min	1861.541-1861.501=0.039
max	1861.706-1861.662=0.043

*mean*	1771.000-7214.000=-5443.000
σ	224.690-0.000=224.690
min	1475.000-7214.000=-5739.000
max	1984.000-7214.000=-5230.000

*mean*	3.242-2.860=0.382
σ	0.343-0.088=0.254
min	2.875-2.730=0.145
max	3.667-2.979=0.688

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.788-1.585=0.203
σ	0.160-0.265=-0.105
min	1.509-1.283=0.226
max	1.906-1.819=0.087

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.185-446.148=0.037
σ	577.140-577.065=0.076
min	157.612-157.613=-0.001
max	1311.895-1311.745=0.151

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	0.534-0.552=-0.018
σ	0.539-0.562=-0.023
min	0.261-0.269=-0.007
max	1.342-1.395=-0.052

policies=20

*mean*	1576.434-1576.413=0.021
σ	0.372-0.345=0.027
min	1576.188-1576.179=0.009
max	1576.987-1576.925=0.063

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	2.666-2.629=0.037
σ	0.068-0.022=0.046
min	2.624-2.607=0.018
max	2.768-2.655=0.113

policies=200

*mean*	15772.285-15772.126=0.159
σ	0.044-0.145=-0.102
min	15772.247-15772.030=0.217
max	15772.327-15772.342=-0.015

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1439.000-7214.000=-5775.000
σ	0.000
min	1439.000-7214.000=-5775.000
max	1439.000-7214.000=-5775.000

*mean*	26.502-26.594=-0.092
σ	0.034-0.185=-0.151
min	26.464-26.456=0.008
max	26.546-26.866=-0.320