Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	53.705-54.056=-0.351
σ	0.369-0.368=0.001
min	53.556-53.914=-0.358
max	54.755-55.103=-0.348

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

*mean*	0.139-0.140=-0.002
σ	0.004-0.004=0.000
min	0.135-0.136=-0.001
max	0.145-0.147=-0.001

cache=y

dps=1

iters=10

policies=100

*mean*	43.057-43.395=-0.338
σ	0.007-0.006=0.001
min	43.045-43.385=-0.341
max	43.070-43.404=-0.334

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

*mean*	0.122-0.123=-0.001
σ	0.004-0.003=0.001
min	0.118-0.119=-0.001
max	0.128-0.129=-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.620

*mean*	4285.625
σ	1981.810
min	1549.000
max	7210.000

*mean*	95.047
σ	232.649
min	12.597
max	670.825

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.618
σ	0.002
min	36.616
max	36.620

*mean*	4285.625
σ	1981.810
min	1549.000
max	7210.000

*mean*	14.610
σ	4.277
min	12.610
max	25.180

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7210.000
σ	0.000
min	7210.000
max	7210.000

*mean*	15.000
σ	1.090
min	12.728
max	15.962

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7210.000
σ	0.000
min	7210.000
max	7210.000

*mean*	13.540
σ	1.432
min	11.124
max	14.776

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.931

*mean*	4169.250
σ	1904.322
min	1549.000
max	7210.000

*mean*	13.646
σ	1.557
min	11.273
max	15.374

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*	4169.250
σ	1904.322
min	1549.000
max	7210.000

*mean*	8.965
σ	0.431
min	8.057
max	9.399

iterations=8

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

rows=200000

*mean*	26.400
σ	0.001
min	26.399
max	26.403

*mean*	4169.250
σ	1904.322
min	1549.000
max	7210.000

*mean*	6.927
σ	0.256
min	6.396
max	7.270

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*	4285.625
σ	1981.810
min	1549.000
max	7210.000

*mean*	6.402
σ	0.996
min	5.855
max	8.843

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.625
σ	1981.810
min	1549.000
max	7210.000

*mean*	5.998
σ	1.045
min	5.487
max	8.564

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969
σ	0.003
min	25.967
max	25.975

*mean*	4285.625
σ	1981.810
min	1549.000
max	7210.000

*mean*	6.022
σ	1.033
min	5.582
max	8.572

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.625
σ	1981.810
min	1549.000
max	7210.000

*mean*	5.996
σ	0.935
min	5.495
max	8.263

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

*mean*	1527.166
σ	775.106
min	1042.413
max	2797.276

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.560
σ	0.041
min	8744.545
max	8744.661

*mean*	3591.000
σ	1819.547
min	1073.000
max	5825.000

*mean*	4841.011
σ	1692.439
min	3504.303
max	7350.002

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.001
min	62.076
max	62.080

*mean*	4169.250
σ	1904.322
min	1549.000
max	7210.000

*mean*	80.039
σ	6.672
min	72.280
max	91.716

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4169.250
σ	1904.322
min	1549.000
max	7210.000

*mean*	81.033
σ	6.959
min	72.545
max	92.754

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.944
σ	0.002
min	40.943
max	40.949

*mean*	7210.000
σ	0.000
min	7210.000
max	7210.000

*mean*	104.110
σ	8.500
min	89.650
max	109.507

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.946
σ	0.002
min	40.944
max	40.947

*mean*	7210.000
σ	0.000
min	7210.000
max	7210.000

*mean*	104.044
σ	8.487
min	89.539
max	109.421

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

*mean*	105.885
σ	9.089
min	90.868
max	114.815

iterations=8

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

rows=200000

*mean*	40.951
σ	0.002
min	40.949
max	40.953

*mean*	7210.000
σ	0.000
min	7210.000
max	7210.000

*mean*	104.268
σ	8.487
min	89.886
max	109.633

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.686
σ	0.002
min	66.685
max	66.690

*mean*	7210.000
σ	0.000
min	7210.000
max	7210.000

*mean*	236.852
σ	220.547
min	140.197
max	781.961

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

*mean*	7210.000
σ	0.000
min	7210.000
max	7210.000

*mean*	156.369
σ	15.051
min	134.140
max	169.396

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=table_records()

rows=200000

*mean*	11656.833
σ	4.319
min	11655.305
max	11667.523

*mean*	4169.250
σ	1904.322
min	1549.000
max	7210.000

*mean*	6242.709
σ	1275.436
min	4907.648
max	8300.341

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.065
σ	0.001
min	11560.064
max	11560.068

*mean*	7210.000
σ	0.000
min	7210.000
max	7210.000

*mean*	5496.021
σ	1269.421
min	4340.849
max	7699.699

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.662
σ	0.018
min	172.632
max	172.679

*mean*	486.000
σ	0.000
min	486.000
max	486.000

*mean*	374.980
σ	36.644
min	307.729
max	418.976

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.475
σ	0.167
min	357.321
max	357.669

*mean*	562.000
σ	0.000
min	562.000
max	562.000

*mean*	779.644
σ	55.255
min	644.818
max	812.878

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1005.002-1006.978=-1.976
σ	0.750-0.878=-0.128
min	1004.530-1006.488=-1.958
max	1008.103-1010.616=-2.512

*mean*	7210.000-1044.950=6165.050
σ	0.000-313.891=-313.891
min	7210.000-574.000=6636.000
max	7210.000-1641.000=5569.000

*mean*	1.598-1.535=0.063
σ	0.120-0.079=0.042
min	1.405-1.394=0.011
max	1.866-1.805=0.061

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-0.882=-0.000
max	0.886-0.887=-0.001

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	0.418-0.429=-0.011
σ	0.122-0.149=-0.027
min	0.348-0.333=0.015
max	0.633-0.692=-0.058

name=error_case.art

*mean*	2.333-2.339=-0.006
σ	0.003-0.003=0.000
min	2.332-2.337=-0.005
max	2.337-2.342=-0.005

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	0.880-0.939=-0.059
σ	0.085-0.079=0.006
min	0.822-0.855=-0.032
max	1.024-1.048=-0.024

name=heavy_item.art

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

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	0.546-0.545=0.001
σ	0.043-0.057=-0.014
min	0.520-0.504=0.016
max	0.621-0.645=-0.024

name=nested_use.art

*mean*	2.355-2.362=-0.006
σ	0.002-0.002=-0.000
min	2.355-2.360=-0.005
max	2.358-2.364=-0.005

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	0.854-0.848=0.006
σ	0.043-0.050=-0.008
min	0.817-0.805=0.013
max	0.926-0.931=-0.005

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.552-964.839=-1.287
σ	0.028-0.033=-0.005
min	963.534-964.813=-1.279
max	963.601-964.893=-1.292

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	0.773-0.816=-0.043
σ	0.065-0.048=0.017
min	0.696-0.751=-0.055
max	0.852-0.864=-0.012

name=cdr_enhanced_4k_loc.art

*mean*	884.854-885.513=-0.659
σ	0.009-0.007=0.002
min	884.847-885.505=-0.659
max	884.868-885.521=-0.653

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	0.691-0.708=-0.017
σ	0.047-0.034=0.012
min	0.640-0.670=-0.030
max	0.736-0.736=-0.000

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.706-7.716=-0.010
σ	0.002-0.002=-0.000
min	7.705-7.715=-0.010
max	7.709-7.719=-0.010

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	4.267-3.503=0.764
σ	0.089-0.110=-0.021
min	4.139-3.376=0.763
max	4.647-4.268=0.379

name=record_render_large_syntax_err.art

*mean*	7.655-7.665=-0.010
σ	0.002-0.002=0.000
min	7.654-7.664=-0.010
max	7.658-7.668=-0.010

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	4.235-3.513=0.723
σ	0.064-0.227=-0.164
min	4.119-3.320=0.799
max	4.432-4.387=0.045

name=record_render_success.art

*mean*	2.288-2.291=-0.003
σ	0.002
min	2.287-2.290=-0.003
max	2.291-2.294=-0.003

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	0.751-0.747=0.004
σ	0.018-0.018=0.000
min	0.715-0.720=-0.004
max	0.882-0.850=0.031

name=record_render_syntax_err.art

*mean*	2.163-2.166=-0.002
σ	0.002
min	2.163-2.165=-0.002
max	2.166-2.169=-0.002

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	0.723-0.702=0.021
σ	0.031-0.016=0.016
min	0.578-0.664=-0.086
max	0.904-0.779=0.125

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	294.378-295.592=-1.214
σ	0.216-0.205=0.011
min	294.222-295.427=-1.205
max	294.957-296.146=-1.189

*mean*	7210.000-1928.000=5282.000
σ	0.000
min	7210.000-1928.000=5282.000
max	7210.000-1928.000=5282.000

*mean*	0.551-0.578=-0.028
σ	0.031-0.048=-0.017
min	0.515-0.498=0.017
max	0.590-0.695=-0.105

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	281.468-285.406=-3.938
σ	0.037-0.035=0.002
min	281.410-285.357=-3.947
max	281.501-285.439=-3.938

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	0.395-0.390=0.005
σ	0.012-0.009=0.002
min	0.386-0.380=0.006
max	0.412-0.397=0.015

iters=5

new-facts=1

prior-facts=6402

*mean*	1291.509-1295.801=-4.292
σ	0.117-0.115=0.002
min	1291.373-1295.677=-4.304
max	1291.631-1295.932=-4.301

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	1.929-1.941=-0.012
σ	0.082-0.088=-0.007
min	1.798-1.826=-0.029
max	2.003-2.028=-0.025

iters=5

new-facts=6402

prior-facts=1

*mean*	1534.387-1539.940=-5.553
σ	4.025-6.889=-2.864
min	1532.354-1536.632=-4.278
max	1541.581-1552.257=-10.676

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	2.377-2.370=0.008
σ	0.265-0.210=0.054
min	1.991-2.112=-0.121
max	2.668-2.635=0.033

iters=5

new-facts=6402

prior-facts=6402

*mean*	1853.320-1857.719=-4.400
σ	0.063-0.084=-0.021
min	1853.226-1857.624=-4.398
max	1853.378-1857.824=-4.446

*mean*	7210.000-1780.800=5429.200
σ	0.000-143.738=-143.738
min	7210.000-1641.000=5569.000
max	7210.000-1928.000=5282.000

*mean*	2.950-3.077=-0.127
σ	0.127-0.282=-0.155
min	2.863-2.837=0.026
max	3.150-3.553=-0.403

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.483-1.259=0.224
σ	0.193-0.342=-0.149
min	1.269-0.935=0.334
max	1.704-1.823=-0.119

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	442.431-445.739=-3.308
σ	577.064-580.934=-3.871
min	153.898-155.271=-1.373
max	1308.027-1317.141=-9.114

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	0.545-0.533=0.012
σ	0.562-0.548=0.015
min	0.261-0.257=0.004
max	1.388-1.354=0.034

policies=20

*mean*	1539.239-1552.959=-13.720
σ	0.333-0.315=0.018
min	1539.012-1552.746=-13.734
max	1539.733-1553.427=-13.694

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	2.607-2.577=0.029
σ	0.016-0.033=-0.017
min	2.585-2.540=0.045
max	2.623-2.620=0.003

policies=200

*mean*	15400.458-15537.992=-137.534
σ	0.114-0.144=-0.030
min	15400.379-15537.848=-137.470
max	15400.626-15538.174=-137.549

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7210.000-1641.000=5569.000
σ	0.000
min	7210.000-1641.000=5569.000
max	7210.000-1641.000=5569.000

*mean*	26.308-26.113=0.194
σ	0.072-0.029=0.043
min	26.243-26.073=0.170
max	26.395-26.140=0.255