9007e9126253fd1214f6ca54a5d5f7a8b18a162f

CSV - column_set() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on indexed

rows=200000

*mean*	36.783
σ	0.002
min	36.781
max	36.785

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	13.139
σ	0.531
min	12.368
max	13.862

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.783
σ	0.002
min	36.781
max	36.785

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	12.833
σ	0.631
min	12.142
max	13.790

CSV - column_set() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.244
σ	0.002
min	62.241
max	62.245

*mean*	5185.500
σ	2674.754
min	1295.000
max	9663.000

*mean*	116.393
σ	60.250
min	84.463
max	284.127

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.832
σ	0.002
min	70.830
max	70.834

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	135.888
σ	7.277
min	122.936
max	143.323

CSV - column_set(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on unindexed, dense

rows=200000

*mean*	15109.844
σ	3.992
min	15108.577
max	15121.205

*mean*	5180.600
σ	2680.554
min	1295.000
max	9663.000

*mean*	9403.905
σ	2130.782
min	6724.677
max	12733.722

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.903
σ	0.005
min	14060.898
max	14060.912

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	6500.876
σ	1516.186
min	5420.042
max	9739.135

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=load_product()

rows=200000

*mean*	8744.666
σ	0.419
min	8744.531
max	8745.858

*mean*	4566.400
σ	2531.801
min	1052.000
max	8035.000

*mean*	4354.131
σ	1357.778
min	3542.667
max	7075.314

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.582
σ	0.002
min	2524.579
max	2524.583

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	1045.963
σ	7.102
min	1034.238
max	1062.828

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	42.068
σ	0.002
min	42.067
max	42.071

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	14.160
σ	1.315
min	12.135
max	15.424

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	42.068
σ	0.002
min	42.066
max	42.070

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	12.830
σ	1.335
min	11.009
max	15.043

CSV - table_records(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	15088.407
σ	0.003
min	15088.403
max	15088.412

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	9031.873
σ	2039.189
min	6545.383
max	12568.954

CSV - vertical_lookup_list() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

*mean*	26.567
σ	0.002
min	26.564
max	26.569

*mean*	5185.500
σ	2674.754
min	1295.000
max	9663.000

*mean*	7.036
σ	0.459
min	6.230
max	7.899

CSV - vertical_lookup_list() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	41.111
σ	0.002
min	41.110
max	41.114

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	153.314
σ	182.432
min	76.435
max	671.405

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	41.112
σ	0.002
min	41.110
max	41.114

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	95.305
σ	12.079
min	76.763
max	104.536

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat

rows=200000

*mean*	41.117
σ	0.002
min	41.115
max	41.120

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	96.750
σ	12.193
min	77.393
max	105.086

CSV - vertical_lookup_list(), mini warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	27.771
σ	0.002
min	27.769
max	27.774

*mean*	5185.500
σ	2674.754
min	1295.000
max	9663.000

*mean*	9.404
σ	0.628
min	8.749
max	10.359

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	41.117
σ	0.002
min	41.114
max	41.119

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	96.714
σ	12.233
min	77.142
max	105.109

CSV - vertical_lookup_list(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	15074.122
σ	0.040
min	15074.106
max	15074.235

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	9853.423
σ	2133.213
min	6581.271
max	12287.497

CSV - vertical_lookup_row_list() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.801
σ	0.002
min	25.799
max	25.802

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	5.440
σ	0.174
min	5.141
max	5.668

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.795
σ	0.002
min	25.793
max	25.798

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	5.441
σ	0.287
min	5.041
max	6.119

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	26.101
σ	0.002
min	26.097
max	26.106

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	5.366
σ	0.202
min	4.997
max	5.647

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat

rows=200000

*mean*	26.099
σ	0.002
min	26.097
max	26.101

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	5.342
σ	0.122
min	5.096
max	5.452

CSV - vertical_lookup_row_list() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.839
σ	0.004
min	66.837
max	66.849

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	269.753
σ	396.082
min	122.053
max	1395.847

iterations=10

operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat

rows=200000

*mean*	66.838
σ	0.002
min	66.837
max	66.841

*mean*	9663.000
σ	0.000
min	9663.000
max	9663.000

*mean*	143.195
σ	18.923
min	118.395
max	162.710

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.559
σ	0.002
min	172.558
max	172.562

*mean*	473.900
σ	0.316
min	473.000
max	474.000

*mean*	401.387
σ	5.392
min	392.833
max	410.263

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	559.000
σ	0.000
min	559.000
max	559.000

*mean*	780.731
σ	21.772
min	732.063
max	800.818