7590a8363f2654f61c5a0abc71bd8c7ab0e14120

Home / Branches / sergeiwinitzki/lan-43-csv-benchmark / 7590a8363f2654f61c5a0abc71bd8c7ab0e14120

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.016
σ0.369
min53.871
max55.065
mean418.000
σ0.000
min418.000
max418.000
mean0.139
σ0.005
min0.130
max0.148
cache=y
dps=1
iters=10
policies=100
mean43.324
σ0.006
min43.317
max43.336
mean418.000
σ0.000
min418.000
max418.000
mean0.128
σ0.008
min0.119
max0.140

CSV benchmark: base/load_csv_only

Factortime_s
iterations=20
operation=base/load_csv_only
rows=50000
mean7.692
σ0.319
min6.880
max8.064

CSV benchmark: base/table_records

Factortime_s
iterations=20
operation=base/table_records
rows=50000
mean9.872
σ0.959
min7.495
max10.821

CSV benchmark: base/table_records_twice

Factortime_s
iterations=20
operation=base/table_records_twice
rows=50000
mean10.355
σ0.372
min9.120
max10.786

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
mean7.851
σ1.012
min7.065
max10.526

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
mean7.876
σ0.815
min7.099
max10.608

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.333
σ0.116
min7.195
max7.499

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
mean7.410
σ0.127
min7.122
max7.560

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.562
σ0.969
min6.673
max10.151

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.419
σ1.045
min6.545
max10.234

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.485
σ1.139
min6.287
max10.180

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
mean8.511
σ1.361
min6.921
max10.479

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
mean7.519
σ0.140
min7.342
max7.811

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
mean7.357
σ0.493
min6.600
max9.232

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.586
σ0.944
min7.738
max10.819

CSV benchmark: single/dense_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/dense_index, vertical_lookup_first
rows=50000
mean7.926
σ0.346
min7.635
max9.315

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
mean9.868
σ1.036
min7.257
max10.751

CSV benchmark: single/dense_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/dense_no_index, vertical_lookup_first
rows=50000
mean10.280
σ0.551
min8.987
max10.750

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.828
σ1.052
min7.451
max10.662

CSV benchmark: single/sparse_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/sparse_index, vertical_lookup_first
rows=50000
mean9.346
σ1.007
min6.823
max10.507

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.406
σ1.423
min6.905
max10.610

CSV benchmark: single/sparse_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/sparse_no_index, vertical_lookup_first
rows=50000
mean9.438
σ1.189
min6.842
max10.794

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.290
σ0.204
min6.736
max7.735

CSV benchmark: single/text_dense_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_dense_index, vertical_lookup_first
rows=50000
mean7.327
σ0.103
min7.106
max7.533

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
mean9.215
σ1.444
min6.224
max10.615

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
mean8.770
σ1.420
min6.904
max10.495

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.257
σ1.400
min6.794
max10.569

CSV benchmark: single/text_sparse_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_sparse_index, vertical_lookup_first
rows=50000
mean8.573
σ1.243
min6.834
max10.259

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.314
σ1.374
min6.802
max10.380

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
mean8.648
σ1.482
min6.904
max10.532

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
mean9.048
σ1.262
min6.440
max10.521

CSV benchmark: single/unique_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/unique_index, vertical_lookup_first
rows=50000
mean8.605
σ1.251
min7.009
max10.481

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.513
σ0.948
min6.969
max10.576

CSV benchmark: single/unique_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/unique_no_index, vertical_lookup_first
rows=50000
mean9.404
σ1.297
min6.854
max10.598

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1006.206
σ1.044
min1005.666
max1010.577
mean1236.550
σ293.705
min861.000
max1820.000
mean1.478
σ0.060
min1.408
max1.590

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.866
σ0.003
min0.864
max0.869
mean1820.000
σ0.000
min1820.000
max1820.000
mean0.309
σ0.104
min0.254
max0.494
name=error_case.art
mean2.337
σ0.003
min2.336
max2.341
mean1820.000
σ0.000
min1820.000
max1820.000
mean0.774
σ0.049
min0.687
max0.810
name=heavy_item.art
mean1.523
σ0.002
min1.522
max1.526
mean1820.000
σ0.000
min1820.000
max1820.000
mean0.541
σ0.038
min0.511
max0.606
name=nested_use.art
mean2.360
σ0.002
min2.359
max2.363
mean1820.000
σ0.000
min1820.000
max1820.000
mean0.838
σ0.041
min0.797
max0.907

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.110
σ0.023
min964.095
max964.149
mean1820.000
σ0.000
min1820.000
max1820.000
mean0.682
σ0.054
min0.596
max0.734
name=cdr_enhanced_4k_loc.art
mean884.713
σ0.011
min884.703
max884.731
mean1820.000
σ0.000
min1820.000
max1820.000
mean0.622
σ0.011
min0.615
max0.640

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.715
σ0.002
min7.714
max7.719
mean1820.000
σ0.000
min1820.000
max1820.000
mean3.547
σ0.067
min3.433
max3.821
name=record_render_large_syntax_err.art
mean7.663
σ0.002
min7.662
max7.670
mean1820.000
σ0.000
min1820.000
max1820.000
mean3.537
σ0.079
min3.402
max3.782
name=record_render_success.art
mean2.289
σ0.002
min2.289
max2.292
mean1820.000
σ0.000
min1820.000
max1820.000
mean0.537
σ0.019
min0.507
max0.683
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean1820.000
σ0.000
min1820.000
max1820.000
mean0.511
σ0.013
min0.488
max0.589

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean296.194
σ0.257
min296.022
max296.907
mean2136.000
σ0.000
min2136.000
max2136.000
mean0.546
σ0.037
min0.495
max0.589

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean284.685
σ0.050
min284.623
max284.741
mean1820.000
σ0.000
min1820.000
max1820.000
mean0.397
σ0.004
min0.394
max0.403
iters=5
new-facts=1
prior-facts=6402
mean1295.101
σ0.066
min1295.028
max1295.199
mean1820.000
σ0.000
min1820.000
max1820.000
mean1.791
σ0.015
min1.772
max1.807
iters=5
new-facts=6402
prior-facts=1
mean1539.212
σ6.845
min1535.923
max1551.452
mean1820.000
σ0.000
min1820.000
max1820.000
mean2.083
σ0.119
min1.997
max2.287
iters=5
new-facts=6402
prior-facts=6402
mean1856.994
σ0.034
min1856.949
max1857.030
mean1949.600
σ123.929
min1820.000
max2136.000
mean3.032
σ0.250
min2.826
max3.445

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.114
σ0.253
min0.933
max1.481

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean447.789
σ581.216
min157.176
max1319.613
mean96.250
σ8.500
min92.000
max109.000
mean1820.000
σ0.000
min1820.000
max1820.000
mean0.493
σ0.451
min0.263
max1.170
policies=20
mean1572.133
σ0.359
min1571.877
max1572.662
mean920.000
σ0.000
min920.000
max920.000
mean1820.000
σ0.000
min1820.000
max1820.000
mean2.663
σ0.002
min2.661
max2.666
policies=200
mean15729.014
σ0.046
min15728.945
max15729.046
mean9200.000
σ0.000
min9200.000
max9200.000
mean1820.000
σ0.000
min1820.000
max1820.000
mean26.815
σ0.139
min26.716
max27.012