8bf807c2b83ca1d11a23a055c201306f2230cb46

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

*mean*	13.376
σ	0.458
min	12.653
max	13.982

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.783
σ	0.002
min	36.781
max	36.785

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	13.009
σ	0.547
min	12.223
max	13.891

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.241
σ	0.000
min	62.241
max	62.241

*mean*	5086.500
σ	2509.664
min	1297.000
max	8381.000

*mean*	106.990
σ	14.383
min	79.469
max	118.602

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.832
σ	0.002
min	70.830
max	70.834

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	139.831
σ	5.166
min	131.539
max	148.728

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

*mean*	5086.500
σ	2509.664
min	1297.000
max	8381.000

*mean*	10337.854
σ	1966.407
min	6610.779
max	12033.518

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.904
σ	0.005
min	14060.899
max	14060.910

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	6838.172
σ	1454.580
min	5462.941
max	8935.807

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=load_product()

rows=200000

*mean*	8744.667
σ	0.418
min	8744.531
max	8745.856

*mean*	4688.300
σ	2487.452
min	1051.000
max	8381.000

*mean*	4951.119
σ	1538.749
min	3497.933
max	7292.302

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.581
σ	0.002
min	2524.579
max	2524.584

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	1091.560
σ	144.192
min	1034.767
max	1501.659

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

*mean*	14.443
σ	1.338
min	11.146
max	15.529

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	42.067
σ	0.002
min	42.066
max	42.070

*mean*	8523.300
σ	449.992
min	8381.000
max	9804.000

*mean*	12.917
σ	1.891
min	11.308
max	15.826

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

*mean*	8523.300
σ	449.992
min	8381.000
max	9804.000

*mean*	9611.924
σ	2057.889
min	6640.943
max	11646.023

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.565
max	26.569

*mean*	5086.500
σ	2509.664
min	1297.000
max	8381.000

*mean*	7.292
σ	0.350
min	6.594
max	7.789

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.112
σ	0.002
min	41.109
max	41.116

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	204.494
σ	330.404
min	86.903
max	1144.653

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	41.112
σ	0.002
min	41.109
max	41.114

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	98.172
σ	8.729
min	81.567
max	106.874

iterations=10

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

rows=200000

*mean*	41.116
σ	0.002
min	41.115
max	41.120

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	100.449
σ	6.611
min	87.241
max	105.997

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.003
min	27.769
max	27.778

*mean*	5086.500
σ	2509.664
min	1297.000
max	8381.000

*mean*	9.948
σ	0.652
min	8.829
max	10.568

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

*mean*	100.917
σ	6.958
min	86.917
max	106.360

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.110
σ	0.003
min	15074.106
max	15074.114

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	9323.317
σ	1967.760
min	6560.235
max	12186.100

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.798
max	25.804

*mean*	8523.300
σ	449.992
min	8381.000
max	9804.000

*mean*	5.297
σ	0.102
min	5.138
max	5.423

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.796
σ	0.002
min	25.793
max	25.798

*mean*	8523.300
σ	449.992
min	8381.000
max	9804.000

*mean*	5.224
σ	0.169
min	4.939
max	5.412

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	26.100
σ	0.002
min	26.097
max	26.102

*mean*	8523.300
σ	449.992
min	8381.000
max	9804.000

*mean*	5.280
σ	0.145
min	4.972
max	5.441

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*	8523.300
σ	449.992
min	8381.000
max	9804.000

*mean*	5.326
σ	0.161
min	4.968
max	5.586

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

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	150.105
σ	14.672
min	118.053
max	163.336

iterations=10

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

rows=200000

*mean*	66.839
σ	0.002
min	66.837
max	66.843

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	203.688
σ	169.573
min	119.935
max	684.620

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	557.600
σ	4.427
min	545.000
max	559.000

*mean*	757.670
σ	60.162
min	637.075
max	805.263