cbd6f4d4e5c6ba742c30a11e8ede482208063d40

Home / Branches / sergeiwinitzki/lan-43-test-csv-benchmarks / cbd6f4d4e5c6ba742c30a11e8ede482208063d40

CSV - column_set() on indexed

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=column_set() on indexed
rows=200000
scenario_id=mixed_indexes/benchmark4
step_id=column_set.indexed.4
mean36.783
σ0.002
min36.781
max36.785
mean9687.000
σ0.000
min9687.000
max9687.000
mean12.994
σ0.354
min12.537
max13.883
iterations=10
operation_display=column_set() on indexed, repeat
rows=200000
scenario_id=mixed_indexes/benchmark4
step_id=column_set.indexed.repeat.4
mean36.783
σ0.002
min36.781
max36.785
mean9687.000
σ0.000
min9687.000
max9687.000
mean12.962
σ0.668
min12.117
max13.976

CSV - column_set() on unindexed

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=column_set() on unindexed, dense, repeat
rows=200000
scenario_id=mixed_indexes/benchmark1
step_id=column_set.unindexed.dense.repeat.1
mean62.242
σ0.000
min62.241
max62.243
mean5190.700
σ2682.541
min1294.000
max9687.000
mean111.845
σ41.210
min82.428
max225.027
iterations=10
operation_display=column_set() on unindexed, sparse, repeat
rows=200000
scenario_id=no_indexes/benchmark3
step_id=column_set.unindexed.sparse.repeat.3
mean70.832
σ0.002
min70.830
max70.834
mean9687.000
σ0.000
min9687.000
max9687.000
mean134.764
σ6.433
min121.265
max139.539

CSV - column_set(), warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=column_set() on unindexed, dense
rows=200000
scenario_id=mixed_indexes/benchmark1
step_id=column_set.unindexed.dense.1
mean15109.842
σ3.993
min15108.577
max15121.206
mean5187.100
σ2686.802
min1294.000
max9687.000
mean8841.415
σ1807.560
min6660.631
max11534.777
iterations=10
operation_display=column_set() on unindexed, sparse
rows=200000
scenario_id=no_indexes/benchmark3
step_id=column_set.unindexed.sparse.3
mean14060.903
σ0.004
min14060.898
max14060.912
mean9687.000
σ0.000
min9687.000
max9687.000
mean6747.022
σ1673.478
min5415.319
max9246.896

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=load_product()
rows=200000
scenario_id=mixed_indexes/benchmark1
step_id=load_product.1
mean8744.666
σ0.418
min8744.530
max8745.856
mean4572.000
σ2536.643
min1051.000
max8050.000
mean4200.012
σ1089.914
min3490.792
max6394.156
iterations=10
operation_display=load_product()
rows=200000
scenario_id=mixed_indexes/benchmark2
step_id=load_product.2
mean8744.535
σ0.003
min8744.530
max8744.539
mean9687.000
σ0.000
min9687.000
max9687.000
mean4323.184
σ1330.741
min3511.415
max6996.892
iterations=10
operation_display=load_product()
rows=200000
scenario_id=mixed_indexes/benchmark4
step_id=load_product.4.mixed_indexes
mean8744.535
σ0.003
min8744.531
max8744.539
mean9687.000
σ0.000
min9687.000
max9687.000
mean5042.742
σ1430.992
min3501.271
max7338.125
iterations=10
operation_display=load_product(), no indexes
rows=200000
scenario_id=no_indexes/benchmark3
step_id=load_product.3.no_indexes
mean2524.582
σ0.003
min2524.579
max2524.589
mean9687.000
σ0.000
min9687.000
max9687.000
mean1284.094
σ501.460
min1026.468
max2611.763

CSV - table_records()

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=table_records()
rows=200000
scenario_id=no_indexes/benchmark3
step_id=table_records.3
mean42.070
σ0.002
min42.067
max42.072
mean9687.000
σ0.000
min9687.000
max9687.000
mean14.685
σ1.141
min12.137
max16.047
iterations=10
operation_display=table_records(), repeat
rows=200000
scenario_id=mixed_indexes/benchmark2
step_id=table_records.repeat.2
mean42.068
σ0.002
min42.066
max42.070
mean9687.000
σ0.000
min9687.000
max9687.000
mean13.521
σ1.838
min11.344
max16.098
iterations=10
operation_display=table_records(), repeat
rows=200000
scenario_id=no_indexes/benchmark3
step_id=table_records.repeat.3
mean42.069
σ0.002
min42.066
max42.071
mean9687.000
σ0.000
min9687.000
max9687.000
mean13.717
σ0.985
min11.370
max14.800

CSV - table_records(), warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=table_records()
rows=200000
scenario_id=mixed_indexes/benchmark2
step_id=table_records.2
mean15088.407
σ0.002
min15088.403
max15088.409
mean9687.000
σ0.000
min9687.000
max9687.000
mean9057.947
σ2311.046
min6552.359
max12657.764

CSV - vertical_lookup_list() on indexed

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=vertical_lookup_list() on indexed, repeat
rows=200000
scenario_id=mixed_indexes/benchmark1
step_id=vertical_lookup_list.indexed.repeat.1
mean26.567
σ0.002
min26.565
max26.569
mean5190.700
σ2682.541
min1294.000
max9687.000
mean7.065
σ0.576
min6.014
max7.953
iterations=10
operation_display=vertical_lookup_list() on indexed, repeat
rows=200000
scenario_id=mixed_indexes/benchmark2
step_id=vertical_lookup_list.indexed.repeat.2
mean26.567
σ0.002
min26.565
max26.569
mean9687.000
σ0.000
min9687.000
max9687.000
mean7.349
σ1.208
min5.765
max10.516
iterations=10
operation_display=vertical_lookup_list() on indexed, repeat
rows=200000
scenario_id=mixed_indexes/benchmark4
step_id=vertical_lookup_list.indexed.repeat.4
mean26.567
σ0.002
min26.564
max26.569
mean9687.000
σ0.000
min9687.000
max9687.000
mean8.103
σ0.370
min7.596
max8.560

CSV - vertical_lookup_list() on unindexed

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=vertical_lookup_list() on unindexed missing Int
rows=200000
scenario_id=no_indexes/benchmark3
step_id=vertical_lookup_list.unindexed.missing_int.3
mean41.111
σ0.002
min41.110
max41.114
mean9687.000
σ0.000
min9687.000
max9687.000
mean100.410
σ12.013
min74.844
max106.842
iterations=10
operation_display=vertical_lookup_list() on unindexed missing Int, repeat
rows=200000
scenario_id=no_indexes/benchmark3
step_id=vertical_lookup_list.unindexed.missing_int.repeat.3
mean41.112
σ0.002
min41.109
max41.114
mean9687.000
σ0.000
min9687.000
max9687.000
mean100.495
σ11.933
min75.471
max107.898
iterations=10
operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat
rows=200000
scenario_id=no_indexes/benchmark3
step_id=vertical_lookup_list.unindexed.tail_unique_int.repeat.3
mean41.116
σ0.002
min41.115
max41.120
mean9687.000
σ0.000
min9687.000
max9687.000
mean100.302
σ11.920
min75.279
max106.605

CSV - vertical_lookup_list(), mini warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=vertical_lookup_list() on indexed
rows=200000
scenario_id=mixed_indexes/benchmark1
step_id=vertical_lookup_list.indexed.1
mean27.771
σ0.003
min27.769
max27.778
mean5190.700
σ2682.541
min1294.000
max9687.000
mean9.450
σ0.639
min8.828
max10.428
iterations=10
operation_display=vertical_lookup_list() on indexed
rows=200000
scenario_id=mixed_indexes/benchmark2
step_id=vertical_lookup_list.indexed.2
mean27.771
σ0.003
min27.769
max27.777
mean9687.000
σ0.000
min9687.000
max9687.000
mean9.540
σ1.143
min8.654
max12.564
iterations=10
operation_display=vertical_lookup_list() on unindexed unique Int near end
rows=200000
scenario_id=no_indexes/benchmark3
step_id=vertical_lookup_list.unindexed.tail_unique_int.3
mean41.117
σ0.002
min41.114
max41.119
mean9687.000
σ0.000
min9687.000
max9687.000
mean100.427
σ11.813
min75.170
max106.870

CSV - vertical_lookup_list(), warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=vertical_lookup_list() on indexed
rows=200000
scenario_id=mixed_indexes/benchmark4
step_id=vertical_lookup_list.indexed.4
mean15074.109
σ0.003
min15074.106
max15074.115
mean9687.000
σ0.000
min9687.000
max9687.000
mean10220.236
σ1848.327
min6533.801
max11901.862

CSV - vertical_lookup_row_list() on indexed

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
scenario_id=mixed_indexes/benchmark2
step_id=vertical_lookup_row_list.two_indexed.2
mean25.682
σ0.003
min25.680
max25.686
mean9687.000
σ0.000
min9687.000
max9687.000
mean5.572
σ0.962
min5.041
max8.295
iterations=10
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
scenario_id=mixed_indexes/benchmark2
step_id=vertical_lookup_row_list.two_indexed.repeat.2
mean25.683
σ0.002
min25.680
max25.685
mean9687.000
σ0.000
min9687.000
max9687.000
mean5.565
σ0.933
min5.022
max8.171
iterations=10
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
scenario_id=mixed_indexes/benchmark2
step_id=vertical_lookup_row_list.three_one_unindexed.2
mean25.875
σ0.002
min25.872
max25.876
mean9687.000
σ0.000
min9687.000
max9687.000
mean5.577
σ0.977
min5.067
max8.339
iterations=10
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
scenario_id=mixed_indexes/benchmark2
step_id=vertical_lookup_row_list.three_one_unindexed.repeat.2
mean25.873
σ0.002
min25.871
max25.876
mean9687.000
σ0.000
min9687.000
max9687.000
mean5.517
σ0.943
min5.049
max8.188

CSV - vertical_lookup_row_list() on unindexed

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=10
operation_display=vertical_lookup_row_list() on unindexed small unique Int
rows=200000
scenario_id=no_indexes/benchmark3
step_id=vertical_lookup_row_list.unindexed.small_unique_int.3
mean66.839
σ0.002
min66.837
max66.841
mean9687.000
σ0.000
min9687.000
max9687.000
mean153.084
σ16.215
min118.759
max162.429
iterations=10
operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat
rows=200000
scenario_id=no_indexes/benchmark3
step_id=vertical_lookup_row_list.unindexed.small_unique_int.repeat.3
mean66.840
σ0.003
min66.837
max66.846
mean9687.000
σ0.000
min9687.000
max9687.000
mean350.529
σ424.846
min121.079
max1277.237

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
benchmark=pointed_index_from_kvs
iterations=10
rows=400000
mean357.322
σ0.002
min357.321
max357.325
mean557.900
σ4.557
min545.000
max560.000
mean707.004
σ66.555
min631.329
max786.914