ea9079207971d1107b1f271e253cc0f3c32a1d90

Home / Branches / sergeiwinitzki/lan-43-csv-benchmark / ea9079207971d1107b1f271e253cc0f3c32a1d90

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.015
σ0.369
min53.877
max55.066
mean417.000
σ0.000
min417.000
max417.000
mean0.140
σ0.004
min0.135
max0.149
cache=y
dps=1
iters=10
policies=100
mean43.322
σ0.006
min43.314
max43.332
mean417.000
σ0.000
min417.000
max417.000
mean0.122
σ0.002
min0.120
max0.128

CSV benchmark: base/load_csv_only

Factortime_s
iterations=20
operation=base/load_csv_only
rows=50000
mean7.786
σ0.378
min6.669
max8.125

CSV benchmark: base/table_records

Factortime_s
iterations=20
operation=base/table_records
rows=50000
mean10.082
σ0.923
min7.858
max10.870

CSV benchmark: base/table_records twice

Factortime_s
iterations=20
operation=base/table_records twice
rows=50000
mean10.165
σ0.773
min7.919
max10.845

CSV benchmark: double/dense_index+text_sparse_index, table_records, vertical_lookup_row_first

Factortime_s
iterations=20
operation=double/dense_index+text_sparse_index, table_records, vertical_lookup_row_first
rows=50000
mean8.589
σ0.809
min7.419
max10.755

CSV benchmark: double/dense_index+text_sparse_index, table_records, vertical_lookup_row_first, lookup twice

Factortime_s
iterations=20
operation=double/dense_index+text_sparse_index, table_records, vertical_lookup_row_first, lookup twice
rows=50000
mean8.359
σ0.794
min7.566
max10.671

CSV benchmark: double/dense_index+text_sparse_index, vertical_lookup_row_first

Factortime_s
iterations=20
operation=double/dense_index+text_sparse_index, vertical_lookup_row_first
rows=50000
mean8.704
σ1.151
min7.544
max10.780

CSV benchmark: double/dense_index+text_sparse_index, vertical_lookup_row_first, lookup twice

Factortime_s
iterations=20
operation=double/dense_index+text_sparse_index, vertical_lookup_row_first, lookup twice
rows=50000
mean8.674
σ0.912
min7.733
max10.597

CSV benchmark: double/dense_index+text_sparse_no_index, table_records, vertical_lookup_row_first

Factortime_s
iterations=20
operation=double/dense_index+text_sparse_no_index, table_records, vertical_lookup_row_first
rows=50000
mean6.977
σ0.479
min6.614
max8.334

CSV benchmark: double/dense_index+text_sparse_no_index, table_records, vertical_lookup_row_first, lookup twice

Factortime_s
iterations=20
operation=double/dense_index+text_sparse_no_index, table_records, vertical_lookup_row_first, lookup twice
rows=50000
mean6.788
σ0.049
min6.700
max6.906

CSV benchmark: double/dense_index+text_sparse_no_index, vertical_lookup_row_first

Factortime_s
iterations=20
operation=double/dense_index+text_sparse_no_index, vertical_lookup_row_first
rows=50000
mean6.784
σ0.038
min6.742
max6.907

CSV benchmark: double/dense_index+text_sparse_no_index, vertical_lookup_row_first, lookup twice

Factortime_s
iterations=20
operation=double/dense_index+text_sparse_no_index, vertical_lookup_row_first, lookup twice
rows=50000
mean6.649
σ0.088
min6.534
max6.814

CSV benchmark: double/dense_no_index+text_sparse_no_index, table_records, vertical_lookup_row_first

Factortime_s
iterations=20
operation=double/dense_no_index+text_sparse_no_index, table_records, vertical_lookup_row_first
rows=50000
mean6.943
σ0.709
min6.252
max8.770

CSV benchmark: double/dense_no_index+text_sparse_no_index, table_records, vertical_lookup_row_first, lookup twice

Factortime_s
iterations=20
operation=double/dense_no_index+text_sparse_no_index, table_records, vertical_lookup_row_first, lookup twice
rows=50000
mean7.439
σ1.034
min6.324
max10.389

CSV benchmark: double/dense_no_index+text_sparse_no_index, vertical_lookup_row_first

Factortime_s
iterations=20
operation=double/dense_no_index+text_sparse_no_index, vertical_lookup_row_first
rows=50000
mean6.965
σ0.214
min6.402
max7.243

CSV benchmark: double/dense_no_index+text_sparse_no_index, vertical_lookup_row_first, lookup twice

Factortime_s
iterations=20
operation=double/dense_no_index+text_sparse_no_index, vertical_lookup_row_first, lookup twice
rows=50000
mean7.341
σ1.009
min6.273
max10.504

CSV benchmark: double/unique_index+text_dense_no_index, table_records, vertical_lookup_row_first

Factortime_s
iterations=20
operation=double/unique_index+text_dense_no_index, table_records, vertical_lookup_row_first
rows=50000
mean7.386
σ1.041
min6.222
max10.605

CSV benchmark: double/unique_index+text_dense_no_index, table_records, vertical_lookup_row_first, lookup twice

Factortime_s
iterations=20
operation=double/unique_index+text_dense_no_index, table_records, vertical_lookup_row_first, lookup twice
rows=50000
mean7.222
σ1.150
min6.178
max10.441

CSV benchmark: double/unique_index+text_dense_no_index, vertical_lookup_row_first

Factortime_s
iterations=20
operation=double/unique_index+text_dense_no_index, vertical_lookup_row_first
rows=50000
mean7.607
σ1.270
min6.305
max10.485

CSV benchmark: double/unique_index+text_dense_no_index, vertical_lookup_row_first, lookup twice

Factortime_s
iterations=20
operation=double/unique_index+text_dense_no_index, vertical_lookup_row_first, lookup twice
rows=50000
mean7.935
σ1.414
min6.756
max10.561

CSV benchmark: double/unique_no_index+text_dense_index, table_records, vertical_lookup_row_first

Factortime_s
iterations=20
operation=double/unique_no_index+text_dense_index, table_records, vertical_lookup_row_first
rows=50000
mean6.672
σ0.223
min6.552
max7.610

CSV benchmark: double/unique_no_index+text_dense_index, table_records, vertical_lookup_row_first, lookup twice

Factortime_s
iterations=20
operation=double/unique_no_index+text_dense_index, table_records, vertical_lookup_row_first, lookup twice
rows=50000
mean6.639
σ0.019
min6.605
max6.670

CSV benchmark: double/unique_no_index+text_dense_index, vertical_lookup_row_first

Factortime_s
iterations=20
operation=double/unique_no_index+text_dense_index, vertical_lookup_row_first
rows=50000
mean6.623
σ0.027
min6.540
max6.653

CSV benchmark: double/unique_no_index+text_dense_index, vertical_lookup_row_first, lookup twice

Factortime_s
iterations=20
operation=double/unique_no_index+text_dense_index, vertical_lookup_row_first, lookup twice
rows=50000
mean6.633
σ0.028
min6.570
max6.683

CSV benchmark: single/dense_index, table_records, vertical_lookup_first

Factortime_s
iterations=20
operation=single/dense_index, table_records, vertical_lookup_first
rows=50000
mean8.042
σ0.590
min7.737
max10.525

CSV benchmark: single/dense_index, table_records, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/dense_index, table_records, vertical_lookup_first, lookup twice
rows=50000
mean8.129
σ0.624
min7.387
max9.781

CSV benchmark: single/dense_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/dense_index, vertical_lookup_first
rows=50000
mean8.452
σ0.785
min7.615
max9.749

CSV benchmark: single/dense_index, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/dense_index, vertical_lookup_first, lookup twice
rows=50000
mean7.812
σ0.070
min7.674
max8.003

CSV benchmark: single/dense_no_index, table_records, vertical_lookup_first

Factortime_s
iterations=20
operation=single/dense_no_index, table_records, vertical_lookup_first
rows=50000
mean10.040
σ0.584
min9.141
max10.765

CSV benchmark: single/dense_no_index, table_records, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/dense_no_index, table_records, vertical_lookup_first, lookup twice
rows=50000
mean10.247
σ0.650
min7.948
max10.724

CSV benchmark: single/dense_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/dense_no_index, vertical_lookup_first
rows=50000
mean10.094
σ0.714
min7.821
max10.789

CSV benchmark: single/dense_no_index, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/dense_no_index, vertical_lookup_first, lookup twice
rows=50000
mean10.093
σ0.799
min7.223
max10.741

CSV benchmark: single/sparse_index, table_records, vertical_lookup_first

Factortime_s
iterations=20
operation=single/sparse_index, table_records, vertical_lookup_first
rows=50000
mean9.173
σ1.256
min7.096
max10.578

CSV benchmark: single/sparse_index, table_records, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/sparse_index, table_records, vertical_lookup_first, lookup twice
rows=50000
mean8.617
σ1.575
min6.539
max10.604

CSV benchmark: single/sparse_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/sparse_index, vertical_lookup_first
rows=50000
mean8.923
σ1.152
min7.238
max10.471

CSV benchmark: single/sparse_index, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/sparse_index, vertical_lookup_first, lookup twice
rows=50000
mean9.217
σ1.329
min7.300
max10.543

CSV benchmark: single/sparse_no_index, table_records, vertical_lookup_first

Factortime_s
iterations=20
operation=single/sparse_no_index, table_records, vertical_lookup_first
rows=50000
mean9.812
σ0.969
min7.382
max10.638

CSV benchmark: single/sparse_no_index, table_records, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/sparse_no_index, table_records, vertical_lookup_first, lookup twice
rows=50000
mean8.834
σ1.434
min6.574
max10.583

CSV benchmark: single/sparse_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/sparse_no_index, vertical_lookup_first
rows=50000
mean9.305
σ1.141
min6.880
max10.634

CSV benchmark: single/sparse_no_index, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/sparse_no_index, vertical_lookup_first, lookup twice
rows=50000
mean9.531
σ1.177
min7.153
max10.620

CSV benchmark: single/text_dense_index, table_records, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_dense_index, table_records, vertical_lookup_first
rows=50000
mean7.703
σ0.492
min7.082
max9.600

CSV benchmark: single/text_dense_index, table_records, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/text_dense_index, table_records, vertical_lookup_first, lookup twice
rows=50000
mean8.047
σ0.919
min7.249
max9.538

CSV benchmark: single/text_dense_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_dense_index, vertical_lookup_first
rows=50000
mean7.488
σ0.609
min6.848
max9.273

CSV benchmark: single/text_dense_index, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/text_dense_index, vertical_lookup_first, lookup twice
rows=50000
mean7.593
σ0.817
min6.700
max10.768

CSV benchmark: single/text_dense_no_index, table_records, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_dense_no_index, table_records, vertical_lookup_first
rows=50000
mean7.755
σ1.263
min6.877
max10.641

CSV benchmark: single/text_dense_no_index, table_records, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/text_dense_no_index, table_records, vertical_lookup_first, lookup twice
rows=50000
mean7.511
σ1.114
min6.548
max10.523

CSV benchmark: single/text_dense_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_dense_no_index, vertical_lookup_first
rows=50000
mean7.898
σ1.281
min6.536
max10.292

CSV benchmark: single/text_dense_no_index, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/text_dense_no_index, vertical_lookup_first, lookup twice
rows=50000
mean8.446
σ1.406
min6.296
max10.571

CSV benchmark: single/text_sparse_index, table_records, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_sparse_index, table_records, vertical_lookup_first
rows=50000
mean8.217
σ1.531
min6.808
max10.496

CSV benchmark: single/text_sparse_index, table_records, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/text_sparse_index, table_records, vertical_lookup_first, lookup twice
rows=50000
mean7.819
σ1.504
min6.485
max10.480

CSV benchmark: single/text_sparse_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_sparse_index, vertical_lookup_first
rows=50000
mean7.796
σ1.306
min6.684
max10.273

CSV benchmark: single/text_sparse_index, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/text_sparse_index, vertical_lookup_first, lookup twice
rows=50000
mean7.427
σ1.009
min6.628
max10.358

CSV benchmark: single/text_sparse_no_index, table_records, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_sparse_no_index, table_records, vertical_lookup_first
rows=50000
mean7.766
σ1.140
min6.467
max10.202

CSV benchmark: single/text_sparse_no_index, table_records, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/text_sparse_no_index, table_records, vertical_lookup_first, lookup twice
rows=50000
mean8.078
σ1.206
min6.518
max10.351

CSV benchmark: single/text_sparse_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_sparse_no_index, vertical_lookup_first
rows=50000
mean7.985
σ1.254
min6.725
max10.201

CSV benchmark: single/text_sparse_no_index, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/text_sparse_no_index, vertical_lookup_first, lookup twice
rows=50000
mean7.954
σ1.311
min6.889
max10.295

CSV benchmark: single/unique_index, table_records, vertical_lookup_first

Factortime_s
iterations=20
operation=single/unique_index, table_records, vertical_lookup_first
rows=50000
mean8.108
σ1.380
min6.448
max10.256

CSV benchmark: single/unique_index, table_records, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/unique_index, table_records, vertical_lookup_first, lookup twice
rows=50000
mean7.554
σ1.279
min6.475
max10.406

CSV benchmark: single/unique_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/unique_index, vertical_lookup_first
rows=50000
mean8.329
σ1.353
min6.507
max10.569

CSV benchmark: single/unique_index, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/unique_index, vertical_lookup_first, lookup twice
rows=50000
mean8.402
σ1.272
min6.967
max10.526

CSV benchmark: single/unique_no_index, table_records, vertical_lookup_first

Factortime_s
iterations=20
operation=single/unique_no_index, table_records, vertical_lookup_first
rows=50000
mean8.306
σ1.368
min6.444
max10.347

CSV benchmark: single/unique_no_index, table_records, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/unique_no_index, table_records, vertical_lookup_first, lookup twice
rows=50000
mean8.160
σ1.375
min6.894
max10.642

CSV benchmark: single/unique_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/unique_no_index, vertical_lookup_first
rows=50000
mean8.146
σ1.076
min6.853
max10.194

CSV benchmark: single/unique_no_index, vertical_lookup_first, lookup twice

Factortime_s
iterations=20
operation=single/unique_no_index, vertical_lookup_first, lookup twice
rows=50000
mean7.653
σ1.034
min6.517
max10.292

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1006.204
σ1.044
min1005.665
max1010.579
mean1397.000
σ282.495
min1046.000
max1778.000
mean1.523
σ0.041
min1.485
max1.613

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.866
σ0.003
min0.864
max0.869
mean1778.000
σ0.000
min1778.000
max1778.000
mean0.300
σ0.117
min0.234
max0.508
name=error_case.art
mean2.337
σ0.003
min2.336
max2.341
mean1778.000
σ0.000
min1778.000
max1778.000
mean0.647
σ0.074
min0.598
max0.778
name=heavy_item.art
mean1.523
σ0.002
min1.522
max1.526
mean1778.000
σ0.000
min1778.000
max1778.000
mean0.509
σ0.034
min0.459
max0.553
name=nested_use.art
mean2.360
σ0.002
min2.359
max2.363
mean1778.000
σ0.000
min1778.000
max1778.000
mean0.850
σ0.037
min0.806
max0.906

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.098
σ0.016
min964.077
max964.120
mean1778.000
σ0.000
min1778.000
max1778.000
mean0.739
σ0.041
min0.713
max0.813
name=cdr_enhanced_4k_loc.art
mean884.717
σ0.015
min884.703
max884.743
mean1778.000
σ0.000
min1778.000
max1778.000
mean0.427
σ0.116
min0.355
max0.627

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.714
σ0.002
min7.714
max7.718
mean1778.000
σ0.000
min1778.000
max1778.000
mean1.985
σ0.079
min1.853
max2.250
name=record_render_large_syntax_err.art
mean7.663
σ0.002
min7.662
max7.670
mean1778.000
σ0.000
min1778.000
max1778.000
mean1.974
σ0.065
min1.862
max2.269
name=record_render_success.art
mean2.289
σ0.002
min2.289
max2.292
mean1778.000
σ0.000
min1778.000
max1778.000
mean0.299
σ0.007
min0.287
max0.345
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean1778.000
σ0.000
min1778.000
max1778.000
mean0.288
σ0.017
min0.271
max0.418

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean296.168
σ0.266
min296.000
max296.886
mean2436.000
σ0.000
min2436.000
max2436.000
mean0.557
σ0.041
min0.505
max0.609

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean284.714
σ0.065
min284.629
max284.787
mean1778.000
σ0.000
min1778.000
max1778.000
mean0.405
σ0.010
min0.393
max0.414
iters=5
new-facts=1
prior-facts=6402
mean1295.136
σ0.097
min1294.995
max1295.221
mean1778.000
σ0.000
min1778.000
max1778.000
mean2.075
σ0.378
min1.811
max2.715
iters=5
new-facts=6402
prior-facts=1
mean1539.190
σ6.865
min1535.789
max1551.463
mean1778.000
σ0.000
min1778.000
max1778.000
mean2.111
σ0.095
min1.994
max2.240
iters=5
new-facts=6402
prior-facts=6402
mean1857.002
σ0.066
min1856.925
max1857.089
mean2116.800
σ225.941
min1840.000
max2436.000
mean2.921
σ0.052
min2.864
max2.967

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.461
σ0.289
min1.004
max1.696

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean447.792
σ581.218
min157.176
max1319.620
mean96.250
σ8.500
min92.000
max109.000
mean1778.000
σ0.000
min1778.000
max1778.000
mean0.511
σ0.475
min0.270
max1.223
policies=20
mean1572.112
σ0.370
min1571.877
max1572.663
mean920.000
σ0.000
min920.000
max920.000
mean1778.000
σ0.000
min1778.000
max1778.000
mean2.709
σ0.005
min2.705
max2.717
policies=200
mean15729.006
σ0.208
min15728.836
max15729.280
mean9200.000
σ0.000
min9200.000
max9200.000
mean1778.000
σ0.000
min1778.000
max1778.000
mean27.009
σ0.434
min26.600
max27.618