Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.618
σ	0.348
min	54.478
max	55.609

*mean*	415.000
σ	0.000
min	415.000
max	415.000

*mean*	0.141
σ	0.004
min	0.137
max	0.146

cache=y

dps=1

iters=10

policies=100

*mean*	43.789
σ	0.005
min	43.782
max	43.796

*mean*	415.000
σ	0.000
min	415.000
max	415.000

*mean*	0.122
σ	0.005
min	0.115
max	0.130

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*	4285.125
σ	1980.490
min	1552.000
max	7207.000

*mean*	82.273
σ	196.283
min	12.531
max	568.048

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4285.125
σ	1980.490
min	1552.000
max	7207.000

*mean*	13.710
σ	2.785
min	11.708
max	20.437

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	14.675
σ	1.012
min	12.590
max	15.382

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	13.202
σ	1.531
min	11.141
max	14.596

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.932

*mean*	4168.875
σ	1903.037
min	1552.000
max	7207.000

*mean*	13.268
σ	1.244
min	11.538
max	14.985

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*	4168.875
σ	1903.037
min	1552.000
max	7207.000

*mean*	8.955
σ	0.204
min	8.722
max	9.251

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*	4168.875
σ	1903.037
min	1552.000
max	7207.000

*mean*	6.670
σ	0.253
min	6.075
max	6.864

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.666
σ	0.002
min	25.665
max	25.668

*mean*	4285.125
σ	1980.490
min	1552.000
max	7207.000

*mean*	6.317
σ	0.623
min	5.929
max	7.820

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.125
σ	1980.490
min	1552.000
max	7207.000

*mean*	5.772
σ	0.460
min	5.527
max	6.903

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*	4285.125
σ	1980.490
min	1552.000
max	7207.000

*mean*	5.913
σ	0.552
min	5.614
max	7.274

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*	4285.125
σ	1980.490
min	1552.000
max	7207.000

*mean*	5.731
σ	0.440
min	5.495
max	6.814

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

*mean*	1195.868
σ	399.359
min	1044.807
max	2184.078

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.560
σ	0.040
min	8744.545
max	8744.660

*mean*	3590.750
σ	1819.077
min	1071.000
max	5824.000

*mean*	4818.725
σ	1715.365
min	3523.819
max	7554.262

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.875
σ	1903.037
min	1552.000
max	7207.000

*mean*	78.447
σ	8.040
min	69.902
max	92.601

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.078
σ	0.002
min	62.076
max	62.080

*mean*	4168.875
σ	1903.037
min	1552.000
max	7207.000

*mean*	79.187
σ	8.186
min	70.439
max	93.061

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

*mean*	101.744
σ	12.065
min	73.899
max	108.751

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.945
σ	0.001
min	40.944
max	40.947

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	101.787
σ	12.224
min	73.470
max	108.801

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

*mean*	104.116
σ	12.181
min	77.315
max	113.654

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

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	101.957
σ	12.010
min	74.163
max	108.842

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.687
σ	0.002
min	66.686
max	66.689

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	237.994
σ	232.631
min	119.565
max	812.361

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

*mean*	154.481
σ	16.838
min	122.082
max	167.087

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.875
σ	1903.037
min	1552.000
max	7207.000

*mean*	6711.080
σ	1211.587
min	4889.954
max	8187.375

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.066
σ	0.002
min	11560.064
max	11560.068

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	5775.916
σ	1518.860
min	4348.244
max	7653.305

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.666
σ	0.008
min	172.650
max	172.674

*mean*	485.375
σ	0.518
min	485.000
max	486.000

*mean*	401.886
σ	19.958
min	361.710
max	422.361

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.470
σ	0.164
min	357.321
max	357.699

*mean*	563.000
σ	0.000
min	563.000
max	563.000

*mean*	790.302
σ	36.261
min	711.153
max	816.576

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.084
σ	0.759
min	1007.610
max	1011.224

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	1.526
σ	0.127
min	1.417
max	1.861

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

*mean*	0.306
σ	0.112
min	0.244
max	0.505

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.651
σ	0.071
min	0.605
max	0.775

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.579
σ	0.094
min	0.447
max	0.686

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.887
σ	0.056
min	0.829
max	0.947

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.550
σ	0.035
min	963.527
max	963.612

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.805
σ	0.050
min	0.735
max	0.860

name=cdr_enhanced_4k_loc.art

*mean*	884.854
σ	0.007
min	884.847
max	884.860

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.712
σ	0.032
min	0.665
max	0.742

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.706
σ	0.002
min	7.705
max	7.712

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	4.305
σ	0.080
min	4.149
max	4.622

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	4.266
σ	0.079
min	4.129
max	4.533

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.741
σ	0.018
min	0.717
max	0.862

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.706
σ	0.013
min	0.678
max	0.766

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.424
σ	0.218
min	297.278
max	298.027

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.592
σ	0.025
min	0.528
max	0.614

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.730
σ	0.050
min	289.652
max	289.791

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.407
σ	0.016
min	0.388
max	0.422

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.647
σ	0.109
min	1299.514
max	1299.771

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	1.957
σ	0.124
min	1.822
max	2.142

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.621
σ	4.069
min	1540.558
max	1549.891

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	2.328
σ	0.214
min	2.069
max	2.514

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.621
σ	0.080
min	1861.509
max	1861.713

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	3.010
σ	0.193
min	2.857
max	3.333

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.572
σ	0.286
min	1.233
max	1.895

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.148
σ	577.064
min	157.613
max	1311.744

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.540
σ	0.545
min	0.267
max	1.357

policies=20

*mean*	1576.424
σ	0.353
min	1576.179
max	1576.946

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	2.651
σ	0.017
min	2.626
max	2.662

policies=200

*mean*	15772.322
σ	0.065
min	15772.245
max	15772.394

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	26.667
σ	0.138
min	26.553
max	26.848