Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.524
σ	0.371
min	54.375
max	55.579

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.142
σ	0.005
min	0.138
max	0.151

cache=y

dps=1

iters=10

policies=100

*mean*	43.766
σ	0.005
min	43.759
max	43.777

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.123
σ	0.005
min	0.119
max	0.133

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*	4289.875
σ	1982.843
min	1548.000
max	7212.000

*mean*	105.899
σ	263.631
min	12.403
max	758.352

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4289.875
σ	1982.843
min	1548.000
max	7212.000

*mean*	13.755
σ	3.136
min	11.755
max	21.354

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	14.830
σ	0.778
min	13.298
max	15.316

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	13.574
σ	0.909
min	11.895
max	14.362

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.931

*mean*	4173.000
σ	1904.988
min	1548.000
max	7212.000

*mean*	13.089
σ	1.223
min	10.975
max	14.231

iterations=8

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

rows=200000

*mean*	27.605
σ	0.003
min	27.603
max	27.611

*mean*	4173.000
σ	1904.988
min	1548.000
max	7212.000

*mean*	9.154
σ	0.416
min	8.443
max	9.539

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*	4173.000
σ	1904.988
min	1548.000
max	7212.000

*mean*	7.157
σ	0.299
min	6.552
max	7.418

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*	4289.875
σ	1982.843
min	1548.000
max	7212.000

*mean*	6.295
σ	0.621
min	5.936
max	7.811

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*	4289.875
σ	1982.843
min	1548.000
max	7212.000

*mean*	5.894
σ	0.583
min	5.580
max	7.324

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*	4289.875
σ	1982.843
min	1548.000
max	7212.000

*mean*	5.930
σ	0.633
min	5.602
max	7.491

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*	4289.875
σ	1982.843
min	1548.000
max	7212.000

*mean*	5.783
σ	0.640
min	5.513
max	7.366

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

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	1461.696
σ	681.193
min	1025.959
max	2799.332

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.040
min	8744.545
max	8744.661

*mean*	3595.250
σ	1821.424
min	1075.000
max	5832.000

*mean*	4994.959
σ	1590.015
min	3522.422
max	6936.968

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*	4173.000
σ	1904.988
min	1548.000
max	7212.000

*mean*	77.398
σ	6.130
min	70.355
max	87.598

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4173.000
σ	1904.988
min	1548.000
max	7212.000

*mean*	78.197
σ	6.101
min	71.549
max	88.292

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.944
σ	0.001
min	40.944
max	40.947

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	103.333
σ	7.808
min	88.563
max	108.988

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

*mean*	103.321
σ	7.871
min	88.417
max	108.952

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.950
σ	0.002
min	40.949
max	40.953

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	105.737
σ	8.570
min	91.163
max	113.195

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

*mean*	103.562
σ	8.012
min	88.456
max	108.991

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

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	234.500
σ	212.722
min	138.625
max	760.292

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

*mean*	156.369
σ	14.551
min	130.708
max	167.691

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*	4173.000
σ	1904.988
min	1548.000
max	7212.000

*mean*	6972.420
σ	1274.887
min	4917.926
max	8245.947

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.065
σ	0.001
min	11560.064
max	11560.068

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	5682.008
σ	1447.275
min	4387.625
max	7709.246

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.668
σ	0.011
min	172.655
max	172.684

*mean*	489.000
σ	0.000
min	489.000
max	489.000

*mean*	395.056
σ	25.759
min	348.961
max	417.755

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.469
σ	0.163
min	357.321
max	357.700

*mean*	566.000
σ	0.000
min	566.000
max	566.000

*mean*	770.243
σ	69.486
min	624.311
max	856.119

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.079
σ	0.761
min	1007.606
max	1011.228

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	1.574
σ	0.133
min	1.362
max	1.871

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

*mean*	0.326
σ	0.124
min	0.258
max	0.548

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.653
σ	0.078
min	0.604
max	0.792

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.388
σ	0.032
min	0.361
max	0.443

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.756
σ	0.116
min	0.603
max	0.852

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.552
σ	0.022
min	963.527
max	963.577

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.804
σ	0.051
min	0.724
max	0.845

name=cdr_enhanced_4k_loc.art

*mean*	884.854
σ	0.007
min	884.847
max	884.864

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.685
σ	0.058
min	0.597
max	0.739

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

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	4.226
σ	0.065
min	4.112
max	4.506

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	4.220
σ	0.107
min	3.548
max	4.623

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.757
σ	0.028
min	0.719
max	0.936

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.718
σ	0.015
min	0.684
max	0.789

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.407
σ	0.233
min	297.256
max	298.052

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.550
σ	0.033
min	0.513
max	0.590

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.725
σ	0.043
min	289.666
max	289.785

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.405
σ	0.022
min	0.388
max	0.441

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.653
σ	0.082
min	1299.573
max	1299.768

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	1.959
σ	0.156
min	1.809
max	2.209

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.628
σ	4.076
min	1540.582
max	1549.911

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	2.323
σ	0.236
min	2.068
max	2.650

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.595
σ	0.066
min	1861.505
max	1861.666

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	2.886
σ	0.092
min	2.794
max	3.040

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.505
σ	0.315
min	1.265
max	1.855

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.144
σ	577.065
min	157.607
max	1311.741

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.538
σ	0.537
min	0.264
max	1.344

policies=20

*mean*	1576.385
σ	0.350
min	1576.150
max	1576.904

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	2.620
σ	0.020
min	2.597
max	2.647

policies=200

*mean*	15771.968
σ	0.074
min	15771.867
max	15772.042

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	26.526
σ	0.121
min	26.444
max	26.702