2e321dcda5b0773d5dd0bc34fb0472c3400b0d39

Home / Branches / sergeiwinitzki/lan-43-csv-benchmark / 2e321dcda5b0773d5dd0bc34fb0472c3400b0d39

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.014
σ0.370
min53.875
max55.066
mean415.000
σ0.000
min415.000
max415.000
mean0.138
σ0.003
min0.133
max0.143
cache=y
dps=1
iters=10
policies=100
mean43.322
σ0.007
min43.311
max43.331
mean415.000
σ0.000
min415.000
max415.000
mean0.121
σ0.004
min0.114
max0.128

CSV benchmark: base/load_csv_only

Factortime_s
iterations=20
operation=base/load_csv_only
rows=50000
mean7.848
σ0.194
min7.379
max8.133

CSV benchmark: base/table_records

Factortime_s
iterations=20
operation=base/table_records
rows=50000
mean10.324
σ0.706
min7.827
max10.852

CSV benchmark: base/table_records twice

Factortime_s
iterations=20
operation=base/table_records twice
rows=50000
mean10.099
σ0.892
min7.340
max10.714

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.013
σ0.717
min7.425
max10.981

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.229
σ0.642
min7.870
max10.470

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.317
σ0.815
min7.837
max10.643

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.321
σ0.806
min7.527
max10.924

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.806
σ0.314
min6.637
max7.859

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.711
σ0.041
min6.663
max6.851

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.693
σ0.026
min6.646
max6.744

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.564
σ0.058
min6.493
max6.718

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.960
σ0.749
min6.175
max8.890

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.407
σ0.933
min6.215
max9.040

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.912
σ0.416
min6.198
max8.383

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.322
σ1.102
min6.493
max10.266

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.091
σ0.958
min6.361
max10.319

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.161
σ0.839
min6.364
max10.086

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.424
σ1.016
min6.140
max10.372

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.852
σ1.552
min6.189
max10.584

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.591
σ0.235
min6.503
max7.586

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.566
σ0.023
min6.512
max6.609

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.567
σ0.019
min6.540
max6.630

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.562
σ0.019
min6.525
max6.609

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.443
σ0.997
min7.646
max10.958

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.185
σ0.755
min7.496
max9.764

CSV benchmark: single/dense_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/dense_index, vertical_lookup_first
rows=50000
mean7.615
σ0.151
min7.342
max7.801

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.756
σ0.276
min7.510
max8.874

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.606
σ1.257
min7.225
max10.795

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.599
σ1.315
min6.511
max10.981

CSV benchmark: single/dense_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/dense_no_index, vertical_lookup_first
rows=50000
mean9.866
σ1.015
min7.339
max10.841

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
mean9.881
σ0.971
min7.530
max10.773

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.060
σ1.453
min6.422
max10.521

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.409
σ1.324
min6.881
max10.334

CSV benchmark: single/sparse_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/sparse_index, vertical_lookup_first
rows=50000
mean9.027
σ0.998
min6.652
max10.269

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.308
σ1.267
min7.003
max10.284

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.494
σ1.301
min6.983
max10.621

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.720
σ1.490
min6.498
max10.588

CSV benchmark: single/sparse_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/sparse_no_index, vertical_lookup_first
rows=50000
mean9.370
σ1.394
min6.882
max10.638

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.999
σ1.506
min6.895
max10.601

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.572
σ0.657
min6.814
max10.091

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.421
σ0.492
min6.848
max9.290

CSV benchmark: single/text_dense_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_dense_index, vertical_lookup_first
rows=50000
mean7.501
σ0.635
min7.193
max9.394

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.646
σ0.860
min6.886
max10.619

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.545
σ0.984
min6.776
max10.259

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.792
σ1.164
min6.708
max10.348

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.472
σ1.401
min7.006
max10.535

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.351
σ1.262
min6.860
max10.591

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.201
σ1.579
min6.458
max10.395

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.966
σ1.432
min6.401
max10.348

CSV benchmark: single/text_sparse_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_sparse_index, vertical_lookup_first
rows=50000
mean7.398
σ1.232
min6.428
max10.256

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.861
σ1.423
min6.202
max10.271

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.115
σ1.372
min6.388
max10.374

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.642
σ1.214
min6.464
max10.449

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.360
σ1.622
min6.453
max10.328

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.226
σ1.559
min6.450
max10.515

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.550
σ1.370
min7.015
max10.550

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.039
σ1.406
min6.564
max10.306

CSV benchmark: single/unique_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/unique_index, vertical_lookup_first
rows=50000
mean7.742
σ1.096
min6.831
max10.304

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.093
σ1.493
min6.506
max10.582

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.595
σ1.262
min6.894
max10.473

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.269
σ1.288
min6.540
max10.551

CSV benchmark: single/unique_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/unique_no_index, vertical_lookup_first
rows=50000
mean7.817
σ1.183
min6.803
max10.302

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
mean8.283
σ1.434
min6.824
max10.640

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1006.204
σ1.043
min1005.668
max1010.572
mean1396.250
σ296.825
min1050.000
max2001.000
mean1.501
σ0.103
min1.322
max1.769

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.866
σ0.003
min0.864
max0.869
mean2001.000
σ0.000
min2001.000
max2001.000
mean0.307
σ0.111
min0.251
max0.505
name=error_case.art
mean2.337
σ0.003
min2.336
max2.341
mean2001.000
σ0.000
min2001.000
max2001.000
mean0.661
σ0.073
min0.615
max0.789
name=heavy_item.art
mean1.523
σ0.002
min1.522
max1.526
mean2001.000
σ0.000
min2001.000
max2001.000
mean0.400
σ0.030
min0.376
max0.453
name=nested_use.art
mean2.360
σ0.002
min2.359
max2.363
mean2001.000
σ0.000
min2001.000
max2001.000
mean0.761
σ0.101
min0.626
max0.850

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.110
σ0.024
min964.088
max964.148
mean2001.000
σ0.000
min2001.000
max2001.000
mean0.601
σ0.060
min0.567
max0.708
name=cdr_enhanced_4k_loc.art
mean884.712
σ0.006
min884.703
max884.717
mean2001.000
σ0.000
min2001.000
max2001.000
mean0.405
σ0.134
min0.319
max0.626

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.714
σ0.002
min7.714
max7.718
mean2001.000
σ0.000
min2001.000
max2001.000
mean1.826
σ0.072
min1.713
max2.162
name=record_render_large_syntax_err.art
mean7.663
σ0.002
min7.662
max7.666
mean2001.000
σ0.000
min2001.000
max2001.000
mean1.817
σ0.062
min1.677
max2.058
name=record_render_success.art
mean2.289
σ0.002
min2.289
max2.294
mean2001.000
σ0.000
min2001.000
max2001.000
mean0.313
σ0.014
min0.296
max0.436
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean2001.000
σ0.000
min2001.000
max2001.000
mean0.293
σ0.007
min0.280
max0.324

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean296.187
σ0.184
min295.958
max296.636
mean2323.000
σ0.000
min2323.000
max2323.000
mean0.551
σ0.029
min0.508
max0.598

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean284.722
σ0.062
min284.643
max284.794
mean2001.000
σ0.000
min2001.000
max2001.000
mean0.393
σ0.002
min0.390
max0.395
iters=5
new-facts=1
prior-facts=6402
mean1295.100
σ0.064
min1295.041
max1295.203
mean2001.000
σ0.000
min2001.000
max2001.000
mean1.995
σ0.181
min1.797
max2.168
iters=5
new-facts=6402
prior-facts=1
mean1539.180
σ6.785
min1535.860
max1551.311
mean2001.000
σ0.000
min2001.000
max2001.000
mean2.083
σ0.081
min2.004
max2.188
iters=5
new-facts=6402
prior-facts=6402
mean1856.988
σ0.093
min1856.898
max1857.122
mean2121.400
σ132.668
min2001.000
max2323.000
mean2.969
σ0.386
min2.676
max3.647

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.127
σ0.226
min0.950
max1.495

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean447.793
σ581.218
min157.175
max1319.620
mean96.250
σ8.500
min92.000
max109.000
mean2001.000
σ0.000
min2001.000
max2001.000
mean0.463
σ0.383
min0.270
max1.038
policies=20
mean1572.135
σ0.389
min1571.879
max1572.715
mean920.000
σ0.000
min920.000
max920.000
mean2001.000
σ0.000
min2001.000
max2001.000
mean2.727
σ0.009
min2.714
max2.735
policies=200
mean15728.867
σ0.161
min15728.719
max15729.087
mean9200.000
σ0.000
min9200.000
max9200.000
mean2001.000
σ0.000
min2001.000
max2001.000
mean26.610
σ0.110
min26.516
max26.769