9a8a206039b68dce47da2156b667c2c1e6aac8e9

Home / Branches / sergeiwinitzki/lan-43-csv-benchmark / 9a8a206039b68dce47da2156b667c2c1e6aac8e9

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.016
σ0.369
min53.870
max55.065
mean415.000
σ0.000
min415.000
max415.000
mean0.140
σ0.004
min0.137
max0.147
cache=y
dps=1
iters=10
policies=100
mean43.323
σ0.007
min43.309
max43.334
mean415.000
σ0.000
min415.000
max415.000
mean0.123
σ0.004
min0.120
max0.130

CSV benchmark: base/load_csv_only

Factortime_s
iterations=20
operation=base/load_csv_only
rows=50000
mean7.819
σ0.175
min7.416
max8.175

CSV benchmark: base/table_records

Factortime_s
iterations=20
operation=base/table_records
rows=50000
mean10.462
σ0.391
min9.036
max10.736

CSV benchmark: base/table_records twice

Factortime_s
iterations=20
operation=base/table_records twice
rows=50000
mean10.237
σ0.650
min8.910
max10.703

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.364
σ0.867
min7.317
max10.446

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.590
σ1.111
min7.687
max10.653

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.301
σ0.842
min7.795
max10.648

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.438
σ0.914
min7.649
max10.632

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
mean7.355
σ0.346
min6.599
max7.948

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
mean7.495
σ0.312
min6.643
max7.782

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.717
σ0.249
min6.536
max7.704

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.671
σ0.050
min6.575
max6.781

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
mean7.101
σ0.800
min6.119
max9.031

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.278
σ1.014
min6.200
max10.211

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
mean7.033
σ0.578
min6.718
max8.782

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
mean6.807
σ0.206
min6.391
max7.089

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.368
σ1.242
min6.149
max10.482

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
mean6.907
σ0.438
min6.374
max8.554

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.713
σ1.189
min6.110
max10.407

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
mean8.090
σ1.549
min6.678
max10.408

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.552
σ0.250
min6.455
max7.609

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.500
σ0.019
min6.458
max6.523

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.498
σ0.027
min6.444
max6.540

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.505
σ0.030
min6.439
max6.573

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
mean7.858
σ0.314
min7.560
max9.149

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
mean7.913
σ0.445
min7.383
max9.253

CSV benchmark: single/dense_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/dense_index, vertical_lookup_first
rows=50000
mean8.259
σ0.773
min7.610
max9.778

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.664
σ0.150
min7.215
max7.958

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.137
σ0.922
min7.115
max10.792

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
mean9.916
σ1.001
min7.327
max10.686

CSV benchmark: single/dense_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/dense_no_index, vertical_lookup_first
rows=50000
mean9.985
σ0.794
min7.323
max10.673

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.163
σ0.539
min8.797
max10.884

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
mean8.630
σ1.384
min6.782
max10.518

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.801
σ1.422
min6.766
max10.472

CSV benchmark: single/sparse_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/sparse_index, vertical_lookup_first
rows=50000
mean8.915
σ1.322
min6.806
max10.534

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
mean8.705
σ1.386
min6.839
max10.584

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.747
σ0.906
min7.314
max10.632

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
mean9.521
σ1.238
min6.820
max10.751

CSV benchmark: single/sparse_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/sparse_no_index, vertical_lookup_first
rows=50000
mean9.078
σ1.440
min6.800
max10.568

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
mean8.965
σ1.341
min6.748
max10.360

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.340
σ0.276
min6.655
max7.645

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
mean7.529
σ0.557
min6.693
max9.548

CSV benchmark: single/text_dense_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_dense_index, vertical_lookup_first
rows=50000
mean7.340
σ0.193
min6.836
max7.828

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
mean8.082
σ1.167
min6.550
max10.865

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
mean8.018
σ1.445
min6.293
max10.511

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
σ0.815
min6.640
max8.899

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.488
σ1.154
min6.639
max10.294

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
mean7.282
σ1.120
min6.763
max10.514

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.131
σ1.560
min6.352
max10.347

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.836
σ1.482
min6.374
max10.237

CSV benchmark: single/text_sparse_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_sparse_index, vertical_lookup_first
rows=50000
mean7.251
σ0.915
min6.488
max10.021

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
mean8.017
σ1.541
min6.616
max10.454

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
mean8.208
σ1.324
min6.310
max10.234

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
mean7.797
σ1.256
min6.420
max10.272

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.846
σ1.197
min6.365
max10.019

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
mean8.044
σ1.266
min6.781
max10.252

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.001
σ1.184
min6.395
max10.221

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
mean8.768
σ1.537
min6.859
max10.551

CSV benchmark: single/unique_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/unique_index, vertical_lookup_first
rows=50000
mean8.045
σ1.384
min6.379
max10.446

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.029
σ1.413
min6.410
max10.432

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
mean9.296
σ1.341
min6.864
max10.643

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.313
σ1.342
min6.800
max10.405

CSV benchmark: single/unique_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/unique_no_index, vertical_lookup_first
rows=50000
mean8.522
σ1.276
min7.079
max10.470

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.962
σ1.130
min6.816
max10.208

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1006.205
σ1.044
min1005.668
max1010.578
mean1384.050
σ300.051
min1037.000
max1963.000
mean1.460
σ0.057
min1.395
max1.566

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.866
σ0.003
min0.864
max0.869
mean1963.000
σ0.000
min1963.000
max1963.000
mean0.409
σ0.130
min0.328
max0.638
name=error_case.art
mean2.337
σ0.003
min2.336
max2.341
mean1963.000
σ0.000
min1963.000
max1963.000
mean0.902
σ0.081
min0.844
max1.043
name=heavy_item.art
mean1.523
σ0.002
min1.522
max1.526
mean1963.000
σ0.000
min1963.000
max1963.000
mean0.559
σ0.047
min0.511
max0.637
name=nested_use.art
mean2.360
σ0.002
min2.359
max2.363
mean1963.000
σ0.000
min1963.000
max1963.000
mean0.856
σ0.048
min0.817
max0.940

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.111
σ0.032
min964.086
max964.161
mean1963.000
σ0.000
min1963.000
max1963.000
mean0.746
σ0.045
min0.716
max0.823
name=cdr_enhanced_4k_loc.art
mean884.721
σ0.021
min884.703
max884.755
mean1963.000
σ0.000
min1963.000
max1963.000
mean0.538
σ0.072
min0.483
max0.621

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.715
σ0.002
min7.714
max7.720
mean1963.000
σ0.000
min1963.000
max1963.000
mean3.531
σ0.077
min3.425
max3.805
name=record_render_large_syntax_err.art
mean7.663
σ0.002
min7.662
max7.666
mean1963.000
σ0.000
min1963.000
max1963.000
mean3.524
σ0.062
min3.401
max3.776
name=record_render_success.art
mean2.289
σ0.002
min2.289
max2.292
mean1963.000
σ0.000
min1963.000
max1963.000
mean0.546
σ0.013
min0.517
max0.633
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean1963.000
σ0.000
min1963.000
max1963.000
mean0.518
σ0.011
min0.496
max0.573

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean296.391
σ0.275
min296.079
max297.039
mean2295.000
σ0.000
min2295.000
max2295.000
mean0.555
σ0.037
min0.512
max0.599

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean284.723
σ0.059
min284.649
max284.789
mean1963.000
σ0.000
min1963.000
max1963.000
mean0.395
σ0.000
min0.395
max0.396
iters=5
new-facts=1
prior-facts=6402
mean1295.121
σ0.075
min1295.051
max1295.207
mean1963.000
σ0.000
min1963.000
max1963.000
mean1.894
σ0.123
min1.802
max2.067
iters=5
new-facts=6402
prior-facts=1
mean1539.167
σ6.800
min1535.867
max1551.326
mean1963.000
σ0.000
min1963.000
max1963.000
mean2.032
σ0.091
min1.942
max2.151
iters=5
new-facts=6402
prior-facts=6402
mean1856.985
σ0.091
min1856.900
max1857.119
mean2095.400
σ138.767
min1963.000
max2295.000
mean2.988
σ0.427
min2.643
max3.732

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.113
σ0.211
min0.922
max1.408

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean447.789
σ581.214
min157.176
max1319.611
mean96.250
σ8.500
min92.000
max109.000
mean1963.000
σ0.000
min1963.000
max1963.000
mean0.487
σ0.422
min0.272
max1.120
policies=20
mean1572.137
σ0.380
min1571.879
max1572.701
mean920.000
σ0.000
min920.000
max920.000
mean1963.000
σ0.000
min1963.000
max1963.000
mean2.711
σ0.012
min2.694
max2.721
policies=200
mean15728.999
σ0.073
min15728.926
max15729.100
mean9200.000
σ0.000
min9200.000
max9200.000
mean1963.000
σ0.000
min1963.000
max1963.000
mean26.869
σ0.384
min26.538
max27.416