Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.616-54.036=0.581
σ	0.348-0.368=-0.020
min	54.484-53.890=0.594
max	55.607-55.082=0.525

*mean*	415.000-413.000=2.000
σ	0.000
min	415.000-413.000=2.000
max	415.000-413.000=2.000

*mean*	0.147-0.149=-0.002
σ	0.008-0.009=-0.001
min	0.137-0.138=-0.000
max	0.160-0.162=-0.002

cache=y

dps=1

iters=10

policies=100

*mean*	43.785-43.384=0.400
σ	0.007-0.005=0.001
min	43.774-43.378=0.396
max	43.795-43.396=0.399

*mean*	415.000-413.000=2.000
σ	0.000
min	415.000-413.000=2.000
max	415.000-413.000=2.000

*mean*	0.123-0.123=-0.000
σ	0.004-0.004=0.000
min	0.117-0.120=-0.003
max	0.130-0.130=0.000

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*	4164.000
σ	1895.945
min	1548.000
max	7196.000

*mean*	12.673
σ	0.308
min	12.175
max	13.224

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4283.875
σ	1975.396
min	1548.000
max	7196.000

*mean*	86.304
σ	206.870
min	12.623
max	598.280

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7196.000
σ	0.000
min	7196.000
max	7196.000

*mean*	14.863
σ	1.219
min	12.255
max	16.241

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7196.000
σ	0.000
min	7196.000
max	7196.000

*mean*	13.607
σ	1.162
min	11.791
max	15.170

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.931

*mean*	4164.000
σ	1895.945
min	1548.000
max	7196.000

*mean*	13.616
σ	1.613
min	11.002
max	15.664

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*	4164.000
σ	1895.945
min	1548.000
max	7196.000

*mean*	9.199
σ	0.404
min	8.558
max	9.728

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*	4164.000
σ	1895.945
min	1548.000
max	7196.000

*mean*	6.766
σ	0.333
min	6.235
max	7.231

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.667
σ	0.002
min	25.665
max	25.670

*mean*	4283.875
σ	1975.396
min	1548.000
max	7196.000

*mean*	6.326
σ	0.836
min	5.848
max	8.375

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*	4283.875
σ	1975.396
min	1548.000
max	7196.000

*mean*	5.787
σ	0.575
min	5.358
max	7.184

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969
σ	0.002
min	25.967
max	25.971

*mean*	4283.875
σ	1975.396
min	1548.000
max	7196.000

*mean*	5.879
σ	0.538
min	5.474
max	7.186

iterations=8

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

rows=200000

*mean*	25.968
σ	0.001
min	25.967
max	25.971

*mean*	4283.875
σ	1975.396
min	1548.000
max	7196.000

*mean*	5.737
σ	0.550
min	5.368
max	7.082

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

*mean*	1196.914
σ	412.314
min	1041.886
max	2217.186

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.042
min	8744.545
max	8744.664

*mean*	3591.750
σ	1814.262
min	1074.000
max	5826.000

*mean*	4791.494
σ	1673.552
min	3525.090
max	7193.961

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.075
max	62.080

*mean*	4164.000
σ	1895.945
min	1548.000
max	7196.000

*mean*	76.477
σ	4.974
min	71.479
max	83.741

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.075
max	62.080

*mean*	4164.000
σ	1895.945
min	1548.000
max	7196.000

*mean*	77.175
σ	5.403
min	71.301
max	84.841

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.944
σ	0.001
min	40.943
max	40.947

*mean*	7196.000
σ	0.000
min	7196.000
max	7196.000

*mean*	101.933
σ	9.333
min	82.155
max	108.251

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.946
σ	0.002
min	40.944
max	40.948

*mean*	7196.000
σ	0.000
min	7196.000
max	7196.000

*mean*	101.743
σ	9.321
min	81.980
max	107.787

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

*mean*	104.239
σ	7.922
min	88.270
max	111.532

iterations=8

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

rows=200000

*mean*	40.951
σ	0.002
min	40.948
max	40.954

*mean*	7196.000
σ	0.000
min	7196.000
max	7196.000

*mean*	102.206
σ	9.211
min	82.793
max	108.717

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.686
σ	0.001
min	66.685
max	66.689

*mean*	7196.000
σ	0.000
min	7196.000
max	7196.000

*mean*	211.427
σ	152.065
min	132.041
max	586.458

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

*mean*	151.741
σ	22.276
min	105.975
max	168.796

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*	4164.000
σ	1895.945
min	1548.000
max	7196.000

*mean*	6125.092
σ	1015.511
min	4922.400
max	8085.947

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.065
σ	0.001
min	11560.064
max	11560.068

*mean*	7196.000
σ	0.000
min	7196.000
max	7196.000

*mean*	5566.973
σ	1489.662
min	4323.784
max	8526.478

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.662
σ	0.012
min	172.643
max	172.678

*mean*	485.000
σ	0.000
min	485.000
max	485.000

*mean*	382.598
σ	45.501
min	311.685
max	424.053

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.466
σ	0.154
min	357.321
max	357.626

*mean*	561.000
σ	0.000
min	561.000
max	561.000

*mean*	804.625
σ	14.967
min	773.502
max	822.649

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.086-1006.327=1.758
σ	0.761-0.911=-0.150
min	1007.611-1005.867=1.744
max	1011.230-1010.118=1.112

*mean*	7196.000-1053.800=6142.200
σ	0.000-305.174=-305.174
min	7196.000-582.000=6614.000
max	7196.000-1453.000=5743.000

*mean*	1.494-1.559=-0.064
σ	0.116-0.086=0.029
min	1.386-1.477=-0.090
max	1.793-1.759=0.033

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*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	0.307-0.443=-0.136
σ	0.110-0.181=-0.071
min	0.246-0.352=-0.106
max	0.503-0.766=-0.263

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	0.648-0.920=-0.272
σ	0.088-0.174=-0.086
min	0.590-0.818=-0.228
max	0.802-1.228=-0.426

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	0.476-0.540=-0.065
σ	0.040-0.047=-0.008
min	0.428-0.499=-0.071
max	0.512-0.616=-0.105

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	0.843-0.846=-0.003
σ	0.034-0.037=-0.003
min	0.810-0.800=0.010
max	0.900-0.902=-0.002

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.551-963.543=0.007
σ	0.022-0.025=-0.004
min	963.530-963.523=0.007
max	963.575-963.585=-0.010

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	0.811-0.812=-0.001
σ	0.036-0.044=-0.008
min	0.761-0.766=-0.006
max	0.850-0.858=-0.008

name=cdr_enhanced_4k_loc.art

*mean*	884.854-884.853=0.000
σ	0.006-0.005=0.001
min	884.847
max	884.860-884.861=-0.001

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	0.676-0.726=-0.051
σ	0.069-0.027=0.042
min	0.566-0.679=-0.113
max	0.740-0.744=-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.002

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	4.259-4.249=0.010
σ	0.068-0.073=-0.005
min	4.149-4.116=0.033
max	4.666-4.550=0.117

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.658=0.000

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	4.268-4.057=0.211
σ	0.072-0.312=-0.240
min	4.135-3.382=0.753
max	4.553-4.352=0.200

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	0.756-0.748=0.008
σ	0.016-0.026=-0.010
min	0.723-0.667=0.056
max	0.856-0.937=-0.081

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	0.717-0.708=0.009
σ	0.012-0.017=-0.005
min	0.687-0.681=0.006
max	0.767-0.819=-0.052

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.154-295.573=1.580
σ	0.239-0.203=0.036
min	297.004-295.441=1.563
max	297.813-296.116=1.697

*mean*	7196.000-1912.000=5284.000
σ	0.000
min	7196.000-1912.000=5284.000
max	7196.000-1912.000=5284.000

*mean*	0.556-0.588=-0.031
σ	0.039-0.028=0.010
min	0.517-0.518=-0.000
max	0.611-0.616=-0.005

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.736-285.245=4.491
σ	0.032-0.040=-0.008
min	289.688-285.193=4.495
max	289.778-285.286=4.491

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	0.390-0.392=-0.003
σ	0.001-0.011=-0.011
min	0.389-0.380=0.009
max	0.391-0.404=-0.013

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.649-1295.155=4.494
σ	0.107-0.112=-0.005
min	1299.514-1295.074=4.441
max	1299.763-1295.342=4.421

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	1.869-1.973=-0.103
σ	0.045-0.219=-0.174
min	1.828-1.797=0.032
max	1.925-2.337=-0.413

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.621-1538.138=4.483
σ	4.002-3.973=0.029
min	1540.593-1536.239=4.354
max	1549.771-1545.242=4.530

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	2.247-2.334=-0.087
σ	0.125-0.276=-0.150
min	2.108-2.077=0.031
max	2.411-2.761=-0.350

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.613-1857.101=4.512
σ	0.086-0.054=0.032
min	1861.500-1857.049=4.451
max	1861.725-1857.176=4.549

*mean*	7196.000-1749.000=5447.000
σ	0.000-176.634=-176.634
min	7196.000-1499.000=5697.000
max	7196.000-1912.000=5284.000

*mean*	3.045-3.054=-0.010
σ	0.361-0.274=0.086
min	2.846-2.863=-0.017
max	3.688-3.529=0.159

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.593-1.756=-0.163
σ	0.227-0.179=0.048
min	1.320-1.445=-0.125
max	1.837-1.906=-0.069

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.149-443.611=2.538
σ	577.064-577.065=-0.001
min	157.617-155.077=2.539
max	1311.745-1309.208=2.537

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	0.553-0.539=0.014
σ	0.558-0.560=-0.002
min	0.269-0.257=0.011
max	1.389-1.379=0.010

policies=20

*mean*	1576.427-1551.052=25.375
σ	0.351-0.342=0.010
min	1576.192-1550.820=25.372
max	1576.949-1551.560=25.389

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	2.630-2.608=0.022
σ	0.020-0.040=-0.020
min	2.612-2.580=0.032
max	2.651-2.667=-0.016

policies=200

*mean*	15772.222-15518.511=253.710
σ	0.176-0.070=0.106
min	15772.013-15518.449=253.564
max	15772.403-15518.606=253.797

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7196.000-1453.000=5743.000
σ	0.000
min	7196.000-1453.000=5743.000
max	7196.000-1453.000=5743.000

*mean*	26.630-26.174=0.457
σ	0.144-0.125=0.019
min	26.470-26.042=0.429
max	26.807-26.287=0.520