930a31f3e10969c10fc7a05e8dd15f94296164f7

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*	8552.400
σ	34.574
min	8536.000
max	8618.000

*mean*	12.481
σ	0.405
min	11.836
max	13.093

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.783
σ	0.002
min	36.781
max	36.785

*mean*	8552.400
σ	34.574
min	8536.000
max	8618.000

*mean*	13.166
σ	0.371
min	12.407
max	13.773

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.243
σ	0.002
min	62.241
max	62.245

*mean*	5039.600
σ	2527.648
min	1291.000
max	8536.000

*mean*	104.842
σ	10.655
min	88.959
max	115.408

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.832
σ	0.002
min	70.830
max	70.834

*mean*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	136.856
σ	7.692
min	121.183
max	143.421

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.843
σ	3.993
min	15108.577
max	15121.206

*mean*	5039.600
σ	2527.648
min	1291.000
max	8536.000

*mean*	9905.669
σ	1921.589
min	6536.787
max	11781.621

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.903
σ	0.004
min	14060.898
max	14060.912

*mean*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	8032.540
σ	1990.150
min	5374.391
max	11098.012

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=load_product() with indexes

rows=200000

*mean*	8744.667
σ	0.418
min	8744.531
max	8745.857

*mean*	4771.000
σ	2500.101
min	1049.000
max	8536.000

*mean*	5127.065
σ	1757.715
min	3458.145
max	7605.003

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.583
σ	0.004
min	2524.579
max	2524.589

*mean*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	1562.869
σ	791.375
min	1034.072
max	3197.306

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	42.069
σ	0.002
min	42.066
max	42.072

*mean*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	13.942
σ	1.619
min	11.346
max	15.232

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	42.067
σ	0.002
min	42.066
max	42.071

*mean*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	12.677
σ	1.785
min	11.117
max	15.099

CSV - table_records(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	15088.406
σ	0.003
min	15088.403
max	15088.412

*mean*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	9494.119
σ	2512.452
min	6509.324
max	12395.935

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*	5039.600
σ	2527.648
min	1291.000
max	8536.000

*mean*	7.170
σ	0.281
min	6.683
max	7.523

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.115

*mean*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	93.836
σ	15.959
min	66.574
max	106.685

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	41.112
σ	0.003
min	41.110
max	41.117

*mean*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	184.757
σ	293.087
min	66.463
max	1017.636

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.119

*mean*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	95.214
σ	14.359
min	67.375
max	106.725

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*	5039.600
σ	2527.648
min	1291.000
max	8536.000

*mean*	9.725
σ	0.600
min	8.777
max	10.323

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.120

*mean*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	127.408
σ	99.743
min	66.179
max	408.323

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*	8552.400
σ	34.574
min	8536.000
max	8618.000

*mean*	9912.240
σ	2304.454
min	6536.337
max	12511.799

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.800
σ	0.002
min	25.798
max	25.802

*mean*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	5.291
σ	0.099
min	5.084
max	5.430

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.796
σ	0.002
min	25.793
max	25.797

*mean*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	5.163
σ	0.092
min	5.040
max	5.346

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	26.101
σ	0.003
min	26.097
max	26.106

*mean*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	5.175
σ	0.093
min	4.988
max	5.328

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*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	5.107
σ	0.086
min	5.029
max	5.285

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.002
min	66.837
max	66.842

*mean*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	142.147
σ	23.258
min	106.944
max	165.702

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*	8536.000
σ	0.000
min	8536.000
max	8536.000

*mean*	172.169
σ	89.248
min	107.750
max	417.859

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.500
σ	0.527
min	473.000
max	474.000

*mean*	384.299
σ	32.970
min	321.968
max	402.416

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	560.000
σ	0.000
min	560.000
max	560.000

*mean*	749.202
σ	59.817
min	656.577
max	800.211