75b010cf98fc6be6e637e67bf414d461d3280bc1

Home / Branches / sergeiwinitzki/lan-43-csv-benchmark / 75b010cf98fc6be6e637e67bf414d461d3280bc1

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.013
σ0.370
min53.871
max55.067
mean415.000
σ0.000
min415.000
max415.000
mean0.135
σ0.005
min0.130
max0.145
cache=y
dps=1
iters=10
policies=100
mean43.323
σ0.008
min43.312
max43.342
mean415.000
σ0.000
min415.000
max415.000
mean0.122
σ0.004
min0.117
max0.127

CSV benchmark: base/column_set

Factortime_s
iterations=20
operation=base/column_set
rows=50000
mean2.948
σ0.179
min2.688
max3.238

CSV benchmark: base/column_set twice

Factortime_s
iterations=20
operation=base/column_set twice
rows=50000
mean2.991
σ0.151
min2.742
max3.328

CSV benchmark: base/load_csv_only

Factortime_s
iterations=20
operation=base/load_csv_only
rows=50000
mean0.300
σ0.034
min0.226
max0.346

CSV benchmark: base/table_records

Factortime_s
iterations=20
operation=base/table_records
rows=50000
mean2.956
σ0.158
min2.710
max3.208

CSV benchmark: base/table_records twice

Factortime_s
iterations=20
operation=base/table_records twice
rows=50000
mean2.938
σ0.286
min1.917
max3.220

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
mean2.858
σ0.387
min2.298
max3.280

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
mean2.857
σ0.445
min1.954
max3.282

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
mean2.974
σ0.394
min2.326
max3.334

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
mean2.943
σ0.425
min1.996
max3.318

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
mean2.083
σ0.250
min1.960
max3.075

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
mean2.027
σ0.088
min1.960
max2.212

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
mean2.006
σ0.069
min1.957
max2.202

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
mean2.005
σ0.070
min1.964
max2.214

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
mean2.230
σ0.494
min1.559
max2.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
mean2.442
σ0.440
min1.615
max3.083

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
mean2.109
σ0.401
min1.587
max2.624

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
mean2.231
σ0.515
min1.599
max3.028

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
mean2.207
σ0.532
min1.546
max2.899

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
mean2.194
σ0.504
min1.509
max2.898

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
mean2.186
σ0.495
min1.534
max2.867

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
mean2.235
σ0.539
min1.521
max2.882

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
mean2.100
σ0.295
min1.982
max3.319

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
mean2.047
σ0.091
min1.986
max2.351

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
mean2.041
σ0.062
min1.976
max2.188

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
mean2.039
σ0.058
min1.993
max2.188

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
mean2.393
σ0.315
min1.987
max3.163

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
mean2.307
σ0.232
min2.005
max2.716

CSV benchmark: single/dense_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/dense_index, vertical_lookup_first
rows=50000
mean2.294
σ0.357
min1.990
max3.160

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
mean2.601
σ0.386
min2.003
max3.407

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
mean2.895
σ0.160
min2.615
max3.167

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
mean2.907
σ0.183
min2.629
max3.308

CSV benchmark: single/dense_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/dense_no_index, vertical_lookup_first
rows=50000
mean2.969
σ0.186
min2.550
max3.152

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
mean3.024
σ0.197
min2.652
max3.264

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
mean2.769
σ0.180
min2.462
max3.070

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
mean2.740
σ0.303
min1.759
max3.077

CSV benchmark: single/sparse_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/sparse_index, vertical_lookup_first
rows=50000
mean2.887
σ0.114
min2.665
max3.092

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
mean2.617
σ0.217
min1.986
max2.899

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
mean2.758
σ0.357
min1.732
max3.136

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
mean2.789
σ0.199
min2.489
max3.209

CSV benchmark: single/sparse_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/sparse_no_index, vertical_lookup_first
rows=50000
mean2.749
σ0.264
min1.927
max3.150

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
mean2.867
σ0.241
min2.268
max3.115

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
mean2.149
σ0.237
min2.010
max3.066

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
mean2.075
σ0.021
min2.039
max2.113

CSV benchmark: single/text_dense_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_dense_index, vertical_lookup_first
rows=50000
mean2.001
σ0.113
min1.920
max2.216

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
mean1.957
σ0.061
min1.924
max2.209

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
mean2.339
σ0.530
min1.570
max3.045

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
mean2.309
σ0.502
min1.570
max2.991

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
mean2.434
σ0.530
min1.533
max2.993

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
mean2.324
σ0.467
min1.545
max2.991

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
mean2.234
σ0.597
min1.516
max2.940

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
mean2.184
σ0.556
min1.546
max2.912

CSV benchmark: single/text_sparse_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/text_sparse_index, vertical_lookup_first
rows=50000
mean2.338
σ0.545
min1.558
max2.922

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
mean2.265
σ0.503
min1.548
max2.944

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
mean2.537
σ0.429
min1.553
max3.109

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
mean1.963
σ0.607
min1.546
max3.106

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
mean1.567
σ0.037
min1.529
max1.669

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
mean2.147
σ0.570
min1.549
max3.001

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
mean2.403
σ0.390
min1.610
max2.959

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
mean2.321
σ0.419
min1.641
max2.996

CSV benchmark: single/unique_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/unique_index, vertical_lookup_first
rows=50000
mean2.545
σ0.407
min1.533
max3.004

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
mean2.397
σ0.464
min1.624
max2.964

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
mean2.612
σ0.333
min1.830
max2.992

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
mean2.558
σ0.444
min1.557
max2.972

CSV benchmark: single/unique_no_index, vertical_lookup_first

Factortime_s
iterations=20
operation=single/unique_no_index, vertical_lookup_first
rows=50000
mean2.618
σ0.363
min1.626
max3.012

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
mean2.510
σ0.337
min1.861
max2.909

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1006.204
σ1.045
min1005.663
max1010.582
mean1333.450
σ320.563
min952.000
max1970.000
mean1.553
σ0.057
min1.494
max1.653

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.866
σ0.003
min0.864
max0.871
mean1970.000
σ0.000
min1970.000
max1970.000
mean0.184
σ0.082
min0.131
max0.329
name=error_case.art
mean2.338
σ0.003
min2.336
max2.343
mean1970.000
σ0.000
min1970.000
max1970.000
mean0.380
σ0.065
min0.342
max0.495
name=heavy_item.art
mean1.523
σ0.002
min1.522
max1.526
mean1970.000
σ0.000
min1970.000
max1970.000
mean0.226
σ0.023
min0.206
max0.266
name=nested_use.art
mean2.361
σ0.002
min2.359
max2.364
mean1970.000
σ0.000
min1970.000
max1970.000
mean0.880
σ0.050
min0.844
max0.966

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.114
σ0.017
min964.099
max964.142
mean1970.000
σ0.000
min1970.000
max1970.000
mean0.748
σ0.048
min0.721
max0.833
name=cdr_enhanced_4k_loc.art
mean884.711
σ0.008
min884.705
max884.726
mean1970.000
σ0.000
min1970.000
max1970.000
mean0.439
σ0.116
min0.337
max0.626

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.715
σ0.002
min7.714
max7.721
mean1970.000
σ0.000
min1970.000
max1970.000
mean2.154
σ0.319
min1.851
max2.853
name=record_render_large_syntax_err.art
mean7.663
σ0.002
min7.662
max7.666
mean1970.000
σ0.000
min1970.000
max1970.000
mean2.591
σ0.068
min2.462
max2.811
name=record_render_success.art
mean2.289
σ0.002
min2.289
max2.292
mean1970.000
σ0.000
min1970.000
max1970.000
mean0.302
σ0.008
min0.288
max0.358
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean1970.000
σ0.000
min1970.000
max1970.000
mean0.291
σ0.010
min0.276
max0.348

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean296.083
σ0.195
min295.969
max296.629
mean2194.000
σ0.000
min2194.000
max2194.000
mean0.587
σ0.033
min0.516
max0.650

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean284.711
σ0.058
min284.641
max284.786
mean1970.000
σ0.000
min1970.000
max1970.000
mean0.399
σ0.007
min0.393
max0.410
iters=5
new-facts=1
prior-facts=6402
mean1295.176
σ0.078
min1295.103
max1295.306
mean1970.000
σ0.000
min1970.000
max1970.000
mean2.024
σ0.198
min1.890
max2.374
iters=5
new-facts=6402
prior-facts=1
mean1539.175
σ6.811
min1535.889
max1551.354
mean1970.000
σ0.000
min1970.000
max1970.000
mean2.101
σ0.055
min2.031
max2.159
iters=5
new-facts=6402
prior-facts=6402
mean1856.945
σ0.047
min1856.893
max1857.009
mean2082.400
σ112.004
min1970.000
max2194.000
mean2.995
σ0.240
min2.794
max3.366

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.029
σ0.183
min0.922
max1.349

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean445.695
σ577.026
min157.179
max1311.235
mean96.250
σ8.500
min92.000
max109.000
mean1970.000
σ0.000
min1970.000
max1970.000
mean0.517
σ0.491
min0.271
max1.253
policies=20
mean1572.145
σ0.380
min1571.898
max1572.712
mean920.000
σ0.000
min920.000
max920.000
mean1970.000
σ0.000
min1970.000
max1970.000
mean2.723
σ0.009
min2.711
max2.732
policies=200
mean15729.044
σ0.139
min15728.905
max15729.234
mean9200.000
σ0.000
min9200.000
max9200.000
mean1970.000
σ0.000
min1970.000
max1970.000
mean26.663
σ0.158
min26.517
max26.876