Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617-53.703=0.913
σ	0.351-0.370=-0.019
min	54.482-53.560=0.922
max	55.614-54.756=0.858

*mean*	417.000-416.000=1.000
σ	0.000
min	417.000-416.000=1.000
max	417.000-416.000=1.000

*mean*	0.139-0.137=0.002
σ	0.004-0.006=-0.001
min	0.135-0.130=0.004
max	0.148-0.146=0.002

cache=y

dps=1

iters=10

policies=100

*mean*	43.786-43.056=0.729
σ	0.008-0.005=0.003
min	43.771-43.050=0.722
max	43.800-43.065=0.735

*mean*	417.000-416.000=1.000
σ	0.000
min	417.000-416.000=1.000
max	417.000-416.000=1.000

*mean*	0.124-0.119=0.004
σ	0.006-0.004=0.002
min	0.120-0.114=0.006
max	0.138-0.125=0.012

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*	4287.750
σ	1976.741
min	1552.000
max	7216.000

*mean*	111.760
σ	279.006
min	12.756
max	802.265

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4287.750
σ	1976.741
min	1552.000
max	7216.000

*mean*	13.854
σ	3.028
min	12.113
max	21.254

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7216.000
σ	0.000
min	7216.000
max	7216.000

*mean*	15.062
σ	0.939
min	13.085
max	15.783

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7216.000
σ	0.000
min	7216.000
max	7216.000

*mean*	13.449
σ	0.805
min	12.269
max	14.481

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.931

*mean*	4170.625
σ	1899.434
min	1552.000
max	7216.000

*mean*	13.139
σ	1.239
min	11.520
max	14.634

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*	4170.625
σ	1899.434
min	1552.000
max	7216.000

*mean*	9.132
σ	0.373
min	8.490
max	9.533

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*	4170.625
σ	1899.434
min	1552.000
max	7216.000

*mean*	6.998
σ	0.527
min	6.067
max	7.424

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*	4287.750
σ	1976.741
min	1552.000
max	7216.000

*mean*	6.171
σ	0.536
min	5.772
max	7.453

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*	4287.750
σ	1976.741
min	1552.000
max	7216.000

*mean*	5.950
σ	0.551
min	5.606
max	7.270

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969
σ	0.002
min	25.967
max	25.972

*mean*	4287.750
σ	1976.741
min	1552.000
max	7216.000

*mean*	6.063
σ	0.594
min	5.494
max	7.354

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*	4287.750
σ	1976.741
min	1552.000
max	7216.000

*mean*	5.741
σ	0.587
min	5.209
max	7.141

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

*mean*	1437.480
σ	638.389
min	1038.067
max	2752.360

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.040
min	8744.545
max	8744.661

*mean*	3594.000
σ	1811.122
min	1077.000
max	5817.000

*mean*	4889.176
σ	1498.618
min	3542.357
max	7131.699

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*	4170.625
σ	1899.434
min	1552.000
max	7216.000

*mean*	82.543
σ	9.234
min	73.059
max	96.763

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.078
σ	0.002
min	62.076
max	62.080

*mean*	4170.625
σ	1899.434
min	1552.000
max	7216.000

*mean*	82.788
σ	9.499
min	72.963
max	98.310

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

*mean*	103.962
σ	9.405
min	86.280
max	109.806

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

*mean*	103.877
σ	9.545
min	85.865
max	109.722

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.951
σ	0.002
min	40.948
max	40.954

*mean*	7216.000
σ	0.000
min	7216.000
max	7216.000

*mean*	105.539
σ	9.444
min	89.212
max	112.705

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

*mean*	104.019
σ	9.496
min	85.937
max	109.544

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

*mean*	7216.000
σ	0.000
min	7216.000
max	7216.000

*mean*	224.061
σ	186.749
min	134.676
max	685.231

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

*mean*	154.334
σ	16.736
min	126.080
max	167.773

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*	4170.625
σ	1899.434
min	1552.000
max	7216.000

*mean*	7053.120
σ	1089.389
min	4886.976
max	8257.237

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.066
σ	0.002
min	11560.064
max	11560.068

*mean*	7216.000
σ	0.000
min	7216.000
max	7216.000

*mean*	5576.682
σ	1320.123
min	4395.644
max	7801.108

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.658
σ	0.012
min	172.638
max	172.671

*mean*	489.500
σ	0.926
min	489.000
max	491.000

*mean*	375.432
σ	42.659
min	311.767
max	412.793

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.470
σ	0.155
min	357.321
max	357.669

*mean*	566.000
σ	0.000
min	566.000
max	566.000

*mean*	771.907
σ	59.460
min	658.785
max	859.563

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.082-1005.105=2.977
σ	0.761-0.883=-0.122
min	1007.607-1004.640=2.967
max	1011.230-1008.762=2.467

*mean*	7216.000-1052.550=6163.450
σ	0.000-309.919=-309.919
min	7216.000-564.000=6652.000
max	7216.000-1650.000=5566.000

*mean*	1.493-1.631=-0.138
σ	0.111-0.067=0.044
min	1.397-1.579=-0.182
max	1.827-1.840=-0.013

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.884-0.882=0.002
σ	0.003-0.002=0.001
min	0.881
max	0.887-0.886=0.002

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	0.338-0.424=-0.086
σ	0.106-0.140=-0.034
min	0.256-0.341=-0.086
max	0.506-0.674=-0.167

name=error_case.art

*mean*	2.333-2.334=-0.001
σ	0.003-0.003=0.000
min	2.332
max	2.337

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	0.844-0.877=-0.033
σ	0.019-0.083=-0.064
min	0.814-0.826=-0.012
max	0.867-1.024=-0.157

name=heavy_item.art

*mean*	1.521-1.521=0.001
σ	0.002-0.001=0.001
min	1.520
max	1.524-1.523=0.001

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	0.536-0.540=-0.004
σ	0.045-0.055=-0.010
min	0.491-0.489=0.002
max	0.609-0.633=-0.024

name=nested_use.art

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

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	0.842-0.846=-0.003
σ	0.035-0.039=-0.005
min	0.815-0.806=0.009
max	0.901-0.910=-0.009

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.550-963.552=-0.002
σ	0.024-0.025=-0.002
min	963.527-963.524=0.002
max	963.588-963.585=0.003

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	0.801-0.832=-0.031
σ	0.043-0.033=0.010
min	0.756-0.777=-0.021
max	0.845-0.860=-0.015

name=cdr_enhanced_4k_loc.art

*mean*	884.854-884.857=-0.003
σ	0.009-0.004=0.005
min	884.847-884.851=-0.004
max	884.867-884.860=0.007

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	0.589-0.717=-0.128
σ	0.069-0.036=0.033
min	0.513-0.664=-0.151
max	0.646-0.745=-0.098

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-7.711=-0.002

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	3.578-4.271=-0.692
σ	0.142-0.090=0.052
min	3.448-4.140=-0.693
max	4.714-4.546=0.168

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	3.528-4.232=-0.704
σ	0.080-0.067=0.013
min	3.305-4.113=-0.809
max	3.752-4.537=-0.785

name=record_render_success.art

*mean*	2.288-2.288=0.000
σ	0.002-0.002=-0.000
min	2.287
max	2.291

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	0.546-0.756=-0.210
σ	0.017-0.018=-0.001
min	0.519-0.725=-0.206
max	0.678-0.880=-0.202

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	0.518-0.720=-0.202
σ	0.010-0.017=-0.006
min	0.494-0.661=-0.168
max	0.550-0.804=-0.254

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.426-294.428=2.998
σ	0.197-0.221=-0.024
min	297.254-294.284=2.969
max	297.966-295.044=2.923

*mean*	7216.000-1915.000=5301.000
σ	0.000
min	7216.000-1915.000=5301.000
max	7216.000-1915.000=5301.000

*mean*	0.531-0.577=-0.046
σ	0.037-0.029=0.009
min	0.493-0.514=-0.022
max	0.596-0.609=-0.014

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.730-281.499=8.231
σ	0.031-0.037=-0.006
min	289.680-281.451=8.230
max	289.766-281.536=8.230

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	0.389-0.389=0.001
σ	0.002-0.004=-0.002
min	0.387-0.384=0.003
max	0.391-0.393=-0.002

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.637-1291.481=8.156
σ	0.099-0.110=-0.012
min	1299.513-1291.361=8.152
max	1299.773-1291.615=8.158

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	1.931-1.902=0.029
σ	0.062-0.095=-0.033
min	1.828-1.810=0.018
max	1.973-2.011=-0.038

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.626-1534.361=8.265
σ	4.064-3.973=0.090
min	1540.595-1532.374=8.221
max	1549.886-1541.460=8.425

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	2.378-2.350=0.028
σ	0.282-0.263=0.019
min	2.067-2.026=0.041
max	2.734-2.614=0.120

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.602-1853.356=8.246
σ	0.065-0.052=0.012
min	1861.511-1853.315=8.196
max	1861.677-1853.432=8.245

*mean*	7216.000-1779.800=5436.200
σ	0.000-129.664=-129.664
min	7216.000-1650.000=5566.000
max	7216.000-1915.000=5301.000

*mean*	2.874-3.033=-0.159
σ	0.143-0.268=-0.125
min	2.692-2.858=-0.166
max	3.031-3.500=-0.468

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.516-1.387=0.129
σ	0.272-0.207=0.065
min	1.133-1.112=0.021
max	1.719-1.676=0.043

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.150-442.428=3.722
σ	577.066-577.064=0.002
min	157.616-153.892=3.723
max	1311.749-1308.024=3.725

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	0.553-0.521=0.032
σ	0.578-0.523=0.055
min	0.260-0.258=0.002
max	1.420-1.306=0.114

policies=20

*mean*	1576.420-1539.227=37.193
σ	0.352-0.325=0.027
min	1576.181-1539.003=37.178
max	1576.942-1539.710=37.232

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	2.635-2.582=0.052
σ	0.028-0.009=0.019
min	2.603-2.570=0.033
max	2.666-2.590=0.076

policies=200

*mean*	15772.315-15400.447=371.868
σ	0.097-0.025=0.073
min	15772.236-15400.415=371.820
max	15772.455-15400.472=371.983

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7216.000-1650.000=5566.000
σ	0.000
min	7216.000-1650.000=5566.000
max	7216.000-1650.000=5566.000

*mean*	26.547-26.178=0.369
σ	0.128-0.265=-0.137
min	26.399-25.980=0.419
max	26.707-26.569=0.138