Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	53.703-53.703=-0.000
σ	0.369-0.368=0.001
min	53.559-53.556=0.004
max	54.753-54.750=0.003

*mean*	414.000-415.000=-1.000
σ	0.000
min	414.000-415.000=-1.000
max	414.000-415.000=-1.000

*mean*	0.139-0.136=0.003
σ	0.004-0.004=0.000
min	0.135-0.130=0.005
max	0.144-0.142=0.002

cache=y

dps=1

iters=10

policies=100

*mean*	43.058-43.058=-0.000
σ	0.005-0.005=0.001
min	43.051-43.051=0.000
max	43.064-43.066=-0.002

*mean*	414.000-415.000=-1.000
σ	0.000
min	414.000-415.000=-1.000
max	414.000-415.000=-1.000

*mean*	0.119-0.119=-0.001
σ	0.005-0.004=0.001
min	0.113-0.113=-0.000
max	0.126-0.127=-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-36.618=-0.000
σ	0.002-0.002=-0.000
min	36.615
max	36.619-36.620=-0.001

*mean*	4284.750-4167.000=117.750
σ	1976.153-1897.389=78.764
min	1548.000-1551.000=-3.000
max	7210.000-7198.000=12.000

*mean*	104.094-12.828=91.266
σ	257.601-0.366=257.235
min	12.714-12.412=0.303
max	741.623-13.521=728.102

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.618-36.617=0.000
σ	0.002-0.002=0.000
min	36.616-36.616=0.000
max	36.620-36.620=0.000

*mean*	4284.750-4286.750=-2.000
σ	1976.153-1976.947=-0.795
min	1548.000-1551.000=-3.000
max	7210.000-7198.000=12.000

*mean*	14.368-81.752=-67.384
σ	2.744-195.336=-192.591
min	13.081-11.882=1.199
max	21.144-565.181=-544.037

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930-41.929=0.001
σ	0.002-0.001=0.001
min	41.928-41.928=-0.000
max	41.932-41.932=0.001

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	14.929-14.892=0.036
σ	0.909-1.267=-0.359
min	13.321-12.151=1.170
max	15.761-15.707=0.055

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929-41.930=-0.001
σ	0.002-0.002=-0.000
min	41.928-41.928=0.000
max	41.932-41.932=-0.000

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	13.724-13.960=-0.236
σ	1.096-1.257=-0.161
min	12.215-11.290=0.925
max	14.890-15.350=-0.461

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929-41.929=-0.000
σ	0.002-0.002=-0.000
min	41.927-41.927=0.000
max	41.932-41.932=0.000

*mean*	4167.500-4167.000=0.500
σ	1898.698-1897.389=1.309
min	1548.000-1551.000=-3.000
max	7210.000-7198.000=12.000

*mean*	13.887-13.649=0.238
σ	1.521-1.485=0.036
min	11.368-11.585=-0.217
max	15.699-15.312=0.386

iterations=8

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

rows=200000

*mean*	27.605-27.604=0.001
σ	0.002-0.002=0.000
min	27.603-27.603=-0.000
max	27.607-27.607=0.000

*mean*	4167.500-4167.000=0.500
σ	1898.698-1897.389=1.309
min	1548.000-1551.000=-3.000
max	7210.000-7198.000=12.000

*mean*	9.208-9.083=0.125
σ	0.425-0.337=0.088
min	8.550-8.330=0.220
max	9.796-9.427=0.369

iterations=8

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

rows=200000

*mean*	26.400-26.400=0.000
σ	0.001-0.001=0.000
min	26.399-26.399=-0.000
max	26.403

*mean*	4167.500-4167.000=0.500
σ	1898.698-1897.389=1.309
min	1548.000-1551.000=-3.000
max	7210.000-7198.000=12.000

*mean*	6.556-6.505=0.050
σ	0.183-0.365=-0.182
min	6.325-5.846=0.479
max	6.815-6.880=-0.065

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.666-25.667=-0.000
σ	0.002-0.002=-0.000
min	25.664-25.665=-0.000
max	25.668-25.670=-0.001

*mean*	4284.750-4286.750=-2.000
σ	1976.153-1976.947=-0.795
min	1548.000-1551.000=-3.000
max	7210.000-7198.000=12.000

*mean*	6.271-6.054=0.217
σ	0.504-0.094=0.409
min	5.910-5.920=-0.010
max	7.494-6.186=1.308

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.661-25.661=0.000
σ	0.002-0.002=0.000
min	25.659-25.659=-0.000
max	25.663-25.663=0.000

*mean*	4284.750-4286.750=-2.000
σ	1976.153-1976.947=-0.795
min	1548.000-1551.000=-3.000
max	7210.000-7198.000=12.000

*mean*	6.007-5.678=0.329
σ	0.593-0.226=0.366
min	5.664-5.200=0.464
max	7.447-5.964=1.483

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969-25.969=-0.000
σ	0.002-0.002=-0.000
min	25.967
max	25.971-25.971=-0.000

*mean*	4284.750-4286.750=-2.000
σ	1976.153-1976.947=-0.795
min	1548.000-1551.000=-3.000
max	7210.000-7198.000=12.000

*mean*	6.057-5.705=0.352
σ	0.577-0.204=0.374
min	5.693-5.274=0.419
max	7.473-5.934=1.538

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat

rows=200000

*mean*	25.968-25.968=0.000
σ	0.002-0.001=0.000
min	25.967
max	25.971-25.971=0.000

*mean*	4284.750-4286.750=-2.000
σ	1976.153-1976.947=-0.795
min	1548.000-1551.000=-3.000
max	7210.000-7198.000=12.000

*mean*	5.921-5.543=0.377
σ	0.635-0.233=0.401
min	5.599-5.035=0.564
max	7.481-5.839=1.642

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-2524.596=-0.000
σ	0.002-0.002=0.000
min	2524.594-2524.594=0.000
max	2524.598-2524.598=0.001

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	1420.424-1179.823=240.601
σ	628.629-398.268=230.361
min	1041.276-1033.396=7.879
max	2780.107-2165.444=614.663

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.560-8744.561=-0.001
σ	0.041-0.042=-0.002
min	8744.545-8744.545=0.000
max	8744.661-8744.665=-0.004

*mean*	3590.500-3594.625=-4.125
σ	1812.038-1816.551=-4.513
min	1072.000-1075.000=-3.000
max	5815.000-5832.000=-17.000

*mean*	4911.557-4448.307=463.250
σ	1619.976-1320.628=299.348
min	3535.764-3498.189=37.575
max	7380.228-6978.018=402.211

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-62.077=-0.000
σ	0.001-0.002=-0.001
min	62.076
max	62.080-62.081=-0.001

*mean*	4167.500-4167.000=0.500
σ	1898.698-1897.389=1.309
min	1548.000-1551.000=-3.000
max	7210.000-7198.000=12.000

*mean*	80.302-80.898=-0.596
σ	9.015-8.824=0.191
min	72.245-73.991=-1.747
max	96.712-98.885=-2.173

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077-62.077=-0.000
σ	0.002-0.002=0.000
min	62.076-62.076=-0.000
max	62.080-62.080=0.000

*mean*	4167.500-4167.000=0.500
σ	1898.698-1897.389=1.309
min	1548.000-1551.000=-3.000
max	7210.000-7198.000=12.000

*mean*	81.227-82.215=-0.988
σ	9.174-8.771=0.403
min	72.636-75.330=-2.694
max	98.263-99.764=-1.501

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.945-40.944=0.000
σ	0.002-0.001=0.001
min	40.944-40.944=-0.000
max	40.949-40.947=0.002

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	104.456-102.883=1.573
σ	8.671-8.929=-0.258
min	86.251-85.031=1.220
max	109.896-109.256=0.640

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.945-40.946=-0.001
σ	0.002-0.002=0.000
min	40.943-40.944=-0.000
max	40.947

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	104.361-103.152=1.209
σ	8.514-8.984=-0.470
min	86.493-85.483=1.011
max	109.953-109.756=0.196

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.950-40.951=-0.001
σ	0.002-0.002=-0.000
min	40.949
max	40.954-40.954=-0.000

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	107.302-105.614=1.688
σ	7.515-8.179=-0.663
min	92.529-92.220=0.309
max	114.508-112.441=2.066

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat

rows=200000

*mean*	40.950-40.951=-0.000
σ	0.002-0.002=-0.000
min	40.948-40.948=-0.000
max	40.953-40.954=-0.001

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	104.348-103.124=1.224
σ	8.553-8.918=-0.365
min	86.201-85.414=0.787
max	109.952-109.986=-0.034

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.687-66.686=0.001
σ	0.003-0.001=0.002
min	66.686-66.685=0.000
max	66.693-66.689=0.004

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	215.674-208.726=6.948
σ	158.430-145.962=12.468
min	137.571-133.404=4.167
max	606.814-568.690=38.124

iterations=8

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

rows=200000

*mean*	66.686-66.687=-0.001
σ	0.001-0.002=-0.001
min	66.685
max	66.689-66.690=-0.000

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	154.211-151.310=2.901
σ	18.537-20.957=-2.420
min	117.959-108.493=9.466
max	167.857-167.243=0.613

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=table_records()

rows=200000

*mean*	11656.833-11656.833=0.000
σ	4.319-4.318=0.001
min	11655.305-11655.305=-0.000
max	11667.523-11667.520=0.004

*mean*	4167.500-4167.000=0.500
σ	1898.698-1897.389=1.309
min	1548.000-1551.000=-3.000
max	7210.000-7198.000=12.000

*mean*	6881.016-5984.266=896.749
σ	1371.091-1009.545=361.547
min	4905.550-4878.768=26.782
max	8435.507-8109.332=326.174

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.066-11560.065=0.001
σ	0.002-0.001=0.001
min	11560.064-11560.065=-0.001
max	11560.069-11560.068=0.002

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	5960.613-5745.796=214.818
σ	1440.546-1630.646=-190.100
min	4389.494-4358.814=30.680
max	7774.767-8499.389=-724.622

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.668-172.666=0.003
σ	0.009-0.013=-0.004
min	172.654-172.647=0.007
max	172.680-172.681=-0.000

*mean*	485.000-486.000=-1.000
σ	0.000
min	485.000-486.000=-1.000
max	485.000-486.000=-1.000

*mean*	402.631-396.220=6.410
σ	18.662-27.429=-8.766
min	364.364-348.143=16.221
max	421.959-421.595=0.364

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.466-357.467=-0.001
σ	0.157-0.155=0.001
min	357.321
max	357.646-357.642=0.004

*mean*	561.000-566.000=-5.000
σ	0.000
min	561.000-566.000=-5.000
max	561.000-566.000=-5.000

*mean*	790.811-741.341=49.470
σ	58.801-68.953=-10.151
min	647.279-622.588=24.691
max	832.521-869.523=-37.002

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1005.001-1005.002=-0.002
σ	0.751-0.750=0.002
min	1004.528-1004.525=0.003
max	1008.104-1008.102=0.003

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	1.594-1.603=-0.010
σ	0.115-0.120=-0.005
min	1.475-1.474=0.001
max	1.882-1.979=-0.096

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*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	0.423-0.318=0.105
σ	0.143-0.104=0.039
min	0.343-0.258=0.086
max	0.677-0.502=0.175

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	0.889-0.638=0.250
σ	0.105-0.073=0.031
min	0.802-0.594=0.208
max	1.069-0.767=0.302

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	0.539-0.425=0.114
σ	0.042-0.062=-0.020
min	0.504-0.376=0.128
max	0.604-0.521=0.083

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	0.840-0.854=-0.015
σ	0.048-0.044=0.005
min	0.795-0.819=-0.024
max	0.915-0.930=-0.015

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.548-963.552=-0.004
σ	0.024-0.024=0.000
min	963.523-963.527=-0.004
max	963.580-963.582=-0.002

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	0.817-0.798=0.019
σ	0.043-0.036=0.006
min	0.765-0.759=0.006
max	0.852-0.838=0.014

name=cdr_enhanced_4k_loc.art

*mean*	884.854-884.853=0.001
σ	0.006-0.007=-0.000
min	884.847
max	884.861-884.863=-0.002

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	0.730-0.727=0.003
σ	0.024-0.020=0.004
min	0.687-0.691=-0.004
max	0.744-0.740=0.004

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

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	4.296-4.148=0.148
σ	0.109-0.307=-0.198
min	3.679-2.799=0.880
max	4.630-4.645=-0.015

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.660=-0.002

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	4.265-3.523=0.741
σ	0.078-0.066=0.012
min	4.145-3.356=0.789
max	4.568-3.739=0.829

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	0.747-0.543=0.204
σ	0.018-0.017=0.001
min	0.713-0.515=0.198
max	0.861-0.629=0.232

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	0.716-0.512=0.204
σ	0.021-0.013=0.008
min	0.624-0.486=0.138
max	0.812-0.584=0.229

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	294.251-294.266=-0.015
σ	0.200-0.282=-0.082
min	294.070-294.070=-0.001
max	294.764-295.036=-0.272

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	0.580-0.588=-0.009
σ	0.030-0.041=-0.011
min	0.511-0.503=0.008
max	0.604-0.621=-0.018

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	281.455-281.466=-0.011
σ	0.034-0.037=-0.003
min	281.401-281.409=-0.008
max	281.495-281.507=-0.012

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	0.393-0.391=0.002
σ	0.006-0.008=-0.002
min	0.386-0.387=-0.001
max	0.400-0.405=-0.006

iters=5

new-facts=1

prior-facts=6402

*mean*	1291.479-1291.493=-0.015
σ	0.087-0.102=-0.015
min	1291.366-1291.365=0.001
max	1291.583-1291.611=-0.029

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	1.940-2.015=-0.074
σ	0.067-0.215=-0.148
min	1.868-1.760=0.107
max	2.020-2.313=-0.293

iters=5

new-facts=6402

prior-facts=1

*mean*	1534.343-1534.394=-0.052
σ	4.063-4.031=0.031
min	1532.301-1532.413=-0.112
max	1541.602-1541.601=0.001

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	2.267-2.350=-0.083
σ	0.238-0.221=0.016
min	2.087-2.132=-0.045
max	2.659-2.632=0.027

iters=5

new-facts=6402

prior-facts=6402

*mean*	1853.338-1853.314=0.024
σ	0.078-0.053=0.025
min	1853.229-1853.262=-0.033
max	1853.427-1853.377=0.050

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	3.173-3.072=0.102
σ	0.237-0.315=-0.078
min	2.871-2.842=0.028
max	3.386-3.627=-0.241

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.659-1.574=0.086
σ	0.180-0.214=-0.034
min	1.369-1.295=0.074
max	1.799-1.895=-0.096

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	442.428-442.430=-0.002
σ	577.063-577.064=-0.001
min	153.895-153.896=-0.000
max	1308.023-1308.027=-0.003

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	0.558-0.542=0.016
σ	0.586-0.549=0.037
min	0.264-0.265=-0.001
max	1.436-1.366=0.070

policies=20

*mean*	1539.203-1539.228=-0.024
σ	0.316-0.315=0.001
min	1538.983-1539.007=-0.024
max	1539.671-1539.694=-0.023

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	2.587-2.584=0.003
σ	0.029-0.028=0.002
min	2.571-2.558=0.013
max	2.631-2.610=0.022

policies=200

*mean*	15400.260-15400.385=-0.125
σ	0.089-0.066=0.023
min	15400.155-15400.293=-0.138
max	15400.372-15400.438=-0.066

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7210.000-7198.000=12.000
σ	0.000
min	7210.000-7198.000=12.000
max	7210.000-7198.000=12.000

*mean*	26.123-26.211=-0.087
σ	0.118-0.136=-0.017
min	26.022-26.093=-0.071
max	26.295-26.395=-0.100