Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617-54.616=0.000
σ	0.351-0.351=0.000
min	54.480-54.481=-0.002
max	55.616-55.615=0.001

*mean*	417.000-412.000=5.000
σ	0.000
min	417.000-412.000=5.000
max	417.000-412.000=5.000

*mean*	0.141-0.137=0.003
σ	0.004-0.007=-0.002
min	0.137-0.131=0.006
max	0.148-0.148=0.000

cache=y

dps=1

iters=10

policies=100

*mean*	43.785-43.786=-0.000
σ	0.005-0.005=0.000
min	43.778-43.778=-0.000
max	43.797-43.795=0.002

*mean*	417.000-412.000=5.000
σ	0.000
min	417.000-412.000=5.000
max	417.000-412.000=5.000

*mean*	0.122-0.121=0.001
σ	0.005-0.005=0.000
min	0.117-0.115=0.002
max	0.131-0.129=0.002

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

*mean*	4285.000
σ	1982.059
min	1549.000
max	7208.000

*mean*	103.650
σ	257.057
min	12.532
max	739.832

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.619

*mean*	4285.000
σ	1982.059
min	1549.000
max	7208.000

*mean*	14.207
σ	3.049
min	12.158
max	21.680

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7208.000
σ	0.000
min	7208.000
max	7208.000

*mean*	14.874
σ	0.929
min	13.022
max	15.467

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7208.000
σ	0.000
min	7208.000
max	7208.000

*mean*	13.557
σ	1.475
min	12.117
max	15.626

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.932

*mean*	4168.750
σ	1904.522
min	1549.000
max	7208.000

*mean*	13.607
σ	1.687
min	11.094
max	15.172

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*	4168.750
σ	1904.522
min	1549.000
max	7208.000

*mean*	9.207
σ	0.434
min	8.772
max	9.739

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.750
σ	1904.522
min	1549.000
max	7208.000

*mean*	6.590
σ	0.330
min	5.933
max	6.927

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*	4285.000
σ	1982.059
min	1549.000
max	7208.000

*mean*	6.268
σ	0.657
min	5.793
max	7.862

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.000
σ	1982.059
min	1549.000
max	7208.000

*mean*	5.740
σ	0.696
min	5.097
max	7.333

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.970
σ	0.002
min	25.967
max	25.972

*mean*	4285.000
σ	1982.059
min	1549.000
max	7208.000

*mean*	5.796
σ	0.702
min	5.319
max	7.488

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.000
σ	1982.059
min	1549.000
max	7208.000

*mean*	5.681
σ	0.694
min	5.122
max	7.323

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

*mean*	7208.000
σ	0.000
min	7208.000
max	7208.000

*mean*	1349.135
σ	460.339
min	1034.231
max	2183.596

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.560
σ	0.040
min	8744.545
max	8744.660

*mean*	3590.250
σ	1820.787
min	1068.000
max	5826.000

*mean*	4783.252
σ	1616.506
min	3512.005
max	7058.220

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*	4168.750
σ	1904.522
min	1549.000
max	7208.000

*mean*	81.111
σ	9.806
min	71.868
max	100.623

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4168.750
σ	1904.522
min	1549.000
max	7208.000

*mean*	81.524
σ	9.506
min	72.004
max	98.766

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

*mean*	103.675
σ	6.956
min	89.729
max	108.269

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.945
σ	0.002
min	40.944
max	40.948

*mean*	7208.000
σ	0.000
min	7208.000
max	7208.000

*mean*	103.584
σ	6.997
min	89.258
max	108.128

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

*mean*	105.455
σ	7.392
min	92.100
max	112.716

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

*mean*	103.853
σ	7.148
min	89.490
max	108.592

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.686
σ	0.001
min	66.686
max	66.689

*mean*	7208.000
σ	0.000
min	7208.000
max	7208.000

*mean*	229.247
σ	196.457
min	141.095
max	714.874

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

*mean*	155.847
σ	14.548
min	128.312
max	167.041

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

*mean*	4168.750
σ	1904.522
min	1549.000
max	7208.000

*mean*	6715.784
σ	1276.509
min	4889.397
max	8043.558

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.066
σ	0.002
min	11560.064
max	11560.069

*mean*	7208.000
σ	0.000
min	7208.000
max	7208.000

*mean*	5532.651
σ	1287.370
min	4358.810
max	7780.410

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.664
σ	0.009
min	172.644
max	172.671

*mean*	485.000
σ	0.000
min	485.000
max	485.000

*mean*	398.145
σ	18.812
min	366.808
max	418.444

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.462
σ	0.150
min	357.321
max	357.634

*mean*	561.000
σ	0.000
min	561.000
max	561.000

*mean*	766.032
σ	71.356
min	623.944
max	809.927

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.084=0.103
σ	0.880-0.761=0.119
min	1007.687-1007.611=0.076
max	1011.834-1011.229=0.604

*mean*	1038.800-7208.000=-6169.200
σ	296.897-0.000=296.897
min	547.000-7208.000=-6661.000
max	1439.000-7208.000=-5769.000

*mean*	1.575-1.513=0.062
σ	0.131-0.122=0.009
min	1.483-1.392=0.091
max	2.057-1.800=0.257

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-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	0.416-0.417=-0.000
σ	0.127-0.119=0.008
min	0.333-0.347=-0.013
max	0.641-0.628=0.013

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	1439.000-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	0.889-0.887=0.002
σ	0.090-0.103=-0.013
min	0.831-0.806=0.025
max	1.045-1.062=-0.017

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1439.000-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	0.546-0.547=-0.000
σ	0.050-0.073=-0.022
min	0.517-0.488=0.028
max	0.636-0.660=-0.024

name=nested_use.art

*mean*	2.355-2.356=-0.000
σ	0.002-0.002=0.000
min	2.355
max	2.358

*mean*	1439.000-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	0.847-0.826=0.022
σ	0.041-0.044=-0.003
min	0.818-0.789=0.029
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.549=-0.007
σ	0.030-0.033=-0.003
min	963.523
max	963.596-963.605=-0.009

*mean*	1439.000-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	0.808-0.745=0.063
σ	0.036-0.073=-0.037
min	0.760-0.641=0.118
max	0.858-0.806=0.051

name=cdr_enhanced_4k_loc.art

*mean*	884.854-884.856=-0.002
σ	0.006-0.007=-0.001
min	884.847
max	884.862-884.863=-0.002

*mean*	1439.000-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	0.708-0.700=0.008
σ	0.040-0.057=-0.018
min	0.672-0.606=0.066
max	0.753-0.749=0.003

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-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	4.229-4.280=-0.051
σ	0.120-0.094=0.026
min	4.105-4.146=-0.041
max	5.140-4.862=0.278

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-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	4.211-4.272=-0.061
σ	0.063-0.070=-0.007
min	4.086-4.148=-0.062
max	4.400-4.521=-0.121

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1439.000-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	0.754-0.756=-0.003
σ	0.016-0.024=-0.008
min	0.721-0.712=0.009
max	0.849-0.892=-0.043

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1439.000-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	0.713-0.708=0.005
σ	0.014-0.017=-0.004
min	0.684-0.669=0.015
max	0.781-0.807=-0.027

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.406-297.539=-0.133
σ	0.204-0.221=-0.017
min	297.207-297.384=-0.177
max	297.891-298.128=-0.237

*mean*	1984.000-7208.000=-5224.000
σ	0.000
min	1984.000-7208.000=-5224.000
max	1984.000-7208.000=-5224.000

*mean*	0.566-0.552=0.014
σ	0.034-0.043=-0.010
min	0.508-0.498=0.010
max	0.593-0.610=-0.017

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.760-289.725=0.036
σ	0.044-0.032=0.012
min	289.722-289.683=0.039
max	289.811-289.769=0.042

*mean*	1439.000-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	0.404-0.390=0.014
σ	0.011-0.001=0.010
min	0.394-0.389=0.005
max	0.420-0.391=0.029

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.691-1299.648=0.043
σ	0.092-0.113=-0.022
min	1299.581-1299.503=0.079
max	1299.819-1299.773=0.046

*mean*	1439.000-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	2.275-1.865=0.410
σ	0.094-0.053=0.041
min	2.150-1.821=0.329
max	2.349-1.943=0.406

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.665-1542.643=0.022
σ	4.004-4.032=-0.028
min	1540.705-1540.614=0.091
max	1549.822-1549.848=-0.026

*mean*	1439.000-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	2.308-2.364=-0.056
σ	0.129-0.200=-0.071
min	2.177-2.115=0.062
max	2.481-2.607=-0.126

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.628-1861.613=0.015
σ	0.064-0.087=-0.023
min	1861.541-1861.499=0.041
max	1861.706-1861.723=-0.017

*mean*	1771.000-7208.000=-5437.000
σ	224.690-0.000=224.690
min	1475.000-7208.000=-5733.000
max	1984.000-7208.000=-5224.000

*mean*	3.242-2.851=0.392
σ	0.343-0.025=0.318
min	2.875-2.812=0.063
max	3.667-2.875=0.792

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.788-1.469=0.318
σ	0.160-0.237=-0.077
min	1.509-1.205=0.305
max	1.906-1.748=0.158

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.185-446.149=0.036
σ	577.140-577.063=0.077
min	157.612-157.616=-0.004
max	1311.895-1311.744=0.151

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1439.000-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	0.534-0.551=-0.017
σ	0.539-0.565=-0.026
min	0.261-0.267=-0.006
max	1.342-1.398=-0.055

policies=20

*mean*	1576.434-1576.428=0.006
σ	0.372-0.355=0.017
min	1576.188-1576.188=0.000
max	1576.987-1576.955=0.032

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1439.000-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	2.666-2.642=0.025
σ	0.068-0.037=0.030
min	2.624-2.603=0.022
max	2.768-2.690=0.078

policies=200

*mean*	15772.285-15772.307=-0.021
σ	0.044-0.079=-0.036
min	15772.247-15772.230=0.017
max	15772.327-15772.416=-0.089

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1439.000-7208.000=-5769.000
σ	0.000
min	1439.000-7208.000=-5769.000
max	1439.000-7208.000=-5769.000

*mean*	26.502-26.635=-0.133
σ	0.034-0.132=-0.098
min	26.464-26.459=0.005
max	26.546-26.763=-0.216