Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.616-53.704=0.912
σ	0.351-0.367=-0.016
min	54.481-53.565=0.916
max	55.615-54.750=0.865

*mean*	412.000-413.000=-1.000
σ	0.000
min	412.000-413.000=-1.000
max	412.000-413.000=-1.000

*mean*	0.137-0.137=0.000
σ	0.007-0.005=0.002
min	0.131-0.129=0.001
max	0.148-0.147=0.000

cache=y

dps=1

iters=10

policies=100

*mean*	43.786-43.059=0.727
σ	0.005-0.006=-0.001
min	43.778-43.050=0.728
max	43.795-43.069=0.726

*mean*	412.000-413.000=-1.000
σ	0.000
min	412.000-413.000=-1.000
max	412.000-413.000=-1.000

*mean*	0.121-0.122=-0.001
σ	0.005-0.004=0.001
min	0.115-0.118=-0.004
max	0.129-0.127=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

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

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

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

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

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.084-1005.104=2.981
σ	0.761-0.892=-0.131
min	1007.611-1004.640=2.971
max	1011.229-1008.806=2.424

*mean*	7208.000-1062.900=6145.100
σ	0.000-328.165=-328.165
min	7208.000-552.000=6656.000
max	7208.000-1630.000=5578.000

*mean*	1.513-1.619=-0.106
σ	0.122-0.098=0.023
min	1.392-1.471=-0.079
max	1.800-1.893=-0.092

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.883-0.883=0.000
σ	0.002-0.002=0.000
min	0.881
max	0.886-0.886=0.000

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	0.417-0.448=-0.032
σ	0.119-0.167=-0.049
min	0.347-0.334=0.012
max	0.628-0.741=-0.114

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	0.887-0.907=-0.020
σ	0.103-0.170=-0.067
min	0.806-0.810=-0.005
max	1.062-1.210=-0.148

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	0.547-0.545=0.002
σ	0.073-0.048=0.025
min	0.488-0.513=-0.025
max	0.660-0.623=0.037

name=nested_use.art

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

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	0.826-0.840=-0.015
σ	0.044-0.036=0.008
min	0.789-0.802=-0.013
max	0.895-0.899=-0.004

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.549-963.553=-0.004
σ	0.033-0.025=0.008
min	963.523
max	963.605-963.583=0.022

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	0.745-0.794=-0.049
σ	0.073-0.024=0.049
min	0.641-0.772=-0.130
max	0.806-0.822=-0.016

name=cdr_enhanced_4k_loc.art

*mean*	884.856-884.855=0.001
σ	0.007-0.005=0.002
min	884.847
max	884.863-884.861=0.002

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	0.700-0.728=-0.028
σ	0.057-0.031=0.027
min	0.606-0.682=-0.076
max	0.749-0.755=-0.006

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

*mean*	4.280-4.291=-0.011
σ	0.094-0.089=0.004
min	4.146-4.134=0.012
max	4.862-4.800=0.062

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.661-7.660=0.001

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	4.272-4.282=-0.010
σ	0.070-0.108=-0.038
min	4.148-3.787=0.361
max	4.521-4.849=-0.327

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	0.756-0.764=-0.007
σ	0.024-0.022=0.002
min	0.712-0.722=-0.010
max	0.892-0.883=0.009

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	0.708-0.733=-0.025
σ	0.017-0.019=-0.001
min	0.669-0.697=-0.028
max	0.807-0.821=-0.014

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.539-294.186=3.354
σ	0.221-0.215=0.005
min	297.384-294.023=3.361
max	298.128-294.772=3.356

*mean*	7208.000-1929.000=5279.000
σ	0.000
min	7208.000-1929.000=5279.000
max	7208.000-1929.000=5279.000

*mean*	0.552-0.580=-0.028
σ	0.043-0.034=0.009
min	0.498-0.512=-0.014
max	0.610-0.613=-0.003

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.725-281.494=8.231
σ	0.032-0.039=-0.007
min	289.683-281.446=8.236
max	289.769-281.535=8.234

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	0.390-0.388=0.002
σ	0.001-0.008=-0.007
min	0.389-0.378=0.010
max	0.391-0.398=-0.008

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.648-1291.481=8.168
σ	0.113-0.106=0.008
min	1299.503-1291.362=8.140
max	1299.773-1291.607=8.166

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	1.865-1.882=-0.017
σ	0.053-0.093=-0.041
min	1.821-1.813=0.008
max	1.943-2.020=-0.076

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.643-1534.334=8.309
σ	4.032-3.964=0.069
min	1540.614-1532.331=8.283
max	1549.848-1541.415=8.434

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	2.364-2.279=0.086
σ	0.200-0.125=0.075
min	2.115-2.139=-0.023
max	2.607-2.416=0.190

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.613-1853.357=8.256
σ	0.087-0.054=0.033
min	1861.499-1853.307=8.192
max	1861.723-1853.436=8.287

*mean*	7208.000-1784.200=5423.800
σ	0.000-142.143=-142.143
min	7208.000-1630.000=5578.000
max	7208.000-1929.000=5279.000

*mean*	2.851-3.077=-0.226
σ	0.025-0.309=-0.283
min	2.812-2.874=-0.062
max	2.875-3.620=-0.744

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.469-1.376=0.093
σ	0.237-0.175=0.062
min	1.205-1.264=-0.060
max	1.748-1.666=0.082

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.149-442.427=3.721
σ	577.063-577.064=-0.001
min	157.616-153.893=3.722
max	1311.744-1308.023=3.721

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	0.551-0.537=0.014
σ	0.565-0.556=0.009
min	0.267-0.258=0.009
max	1.398-1.371=0.027

policies=20

*mean*	1576.428-1539.211=37.218
σ	0.355-0.335=0.020
min	1576.188-1538.979=37.209
max	1576.955-1539.708=37.247

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	2.642-2.595=0.046
σ	0.037-0.024=0.013
min	2.603-2.564=0.039
max	2.690-2.619=0.070

policies=200

*mean*	15772.307-15400.420=371.887
σ	0.079-0.126=-0.046
min	15772.230-15400.232=371.998
max	15772.416-15400.491=371.925

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7208.000-1630.000=5578.000
σ	0.000
min	7208.000-1630.000=5578.000
max	7208.000-1630.000=5578.000

*mean*	26.635-26.111=0.524
σ	0.132-0.113=0.019
min	26.459-25.946=0.513
max	26.763-26.197=0.565