2e7f6671f2ed0b435b1214a2c5ab626329cc73da

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*	8936.000
σ	75.895
min	8912.000
max	9152.000

*mean*	12.930
σ	0.277
min	12.570
max	13.521

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.783
σ	0.002
min	36.781
max	36.785

*mean*	8936.000
σ	75.895
min	8912.000
max	9152.000

*mean*	13.046
σ	0.426
min	12.145
max	13.572

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*	5231.800
σ	2591.935
min	1267.000
max	8662.000

*mean*	102.713
σ	14.806
min	77.543
max	119.156

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.833
σ	0.002
min	70.830
max	70.834

*mean*	8912.000
σ	0.000
min	8912.000
max	8912.000

*mean*	136.158
σ	4.587
min	128.513
max	142.381

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.992
min	15108.577
max	15121.206

*mean*	5231.800
σ	2591.935
min	1267.000
max	8662.000

*mean*	9306.383
σ	2305.617
min	6664.629
max	12087.886

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.904
σ	0.003
min	14060.898
max	14060.909

*mean*	8912.000
σ	0.000
min	8912.000
max	8912.000

*mean*	7410.076
σ	1630.911
min	5425.181
max	9554.457

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.419
min	8744.530
max	8745.858

*mean*	4856.900
σ	2522.000
min	1046.000
max	8662.000

*mean*	4507.892
σ	1333.004
min	3516.712
max	7502.406

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.581
σ	0.002
min	2524.579
max	2524.583

*mean*	8912.000
σ	0.000
min	8912.000
max	8912.000

*mean*	1129.319
σ	188.237
min	1029.673
max	1489.234

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.067
max	42.071

*mean*	8912.000
σ	0.000
min	8912.000
max	8912.000

*mean*	14.457
σ	1.396
min	11.554
max	16.224

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	42.067
σ	0.002
min	42.066
max	42.070

*mean*	8687.000
σ	79.057
min	8662.000
max	8912.000

*mean*	14.545
σ	1.256
min	11.617
max	15.925

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

*mean*	8687.000
σ	79.057
min	8662.000
max	8912.000

*mean*	9541.359
σ	1902.100
min	6521.562
max	12247.395

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*	5231.800
σ	2591.935
min	1267.000
max	8662.000

*mean*	7.244
σ	0.558
min	6.250
max	8.017

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.003
min	41.110
max	41.116

*mean*	8912.000
σ	0.000
min	8912.000
max	8912.000

*mean*	190.274
σ	287.332
min	87.332
max	1007.736

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	41.111
σ	0.002
min	41.110
max	41.114

*mean*	8912.000
σ	0.000
min	8912.000
max	8912.000

*mean*	97.009
σ	10.567
min	76.452
max	107.019

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

*mean*	100.085
σ	8.178
min	87.446
max	107.453

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*	5231.800
σ	2591.935
min	1267.000
max	8662.000

*mean*	9.798
σ	0.683
min	8.868
max	10.382

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

*mean*	99.864
σ	8.407
min	87.303
max	107.369

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*	8936.000
σ	75.895
min	8912.000
max	9152.000

*mean*	9255.802
σ	1920.491
min	6531.126
max	12291.061

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*	8687.000
σ	79.057
min	8662.000
max	8912.000

*mean*	5.337
σ	0.167
min	5.155
max	5.595

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*	8687.000
σ	79.057
min	8662.000
max	8912.000

*mean*	5.220
σ	0.202
min	4.959
max	5.570

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	26.100
σ	0.003
min	26.097
max	26.106

*mean*	8687.000
σ	79.057
min	8662.000
max	8912.000

*mean*	5.250
σ	0.272
min	4.926
max	5.758

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*	8687.000
σ	79.057
min	8662.000
max	8912.000

*mean*	5.239
σ	0.220
min	4.930
max	5.638

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

*mean*	147.485
σ	16.100
min	112.933
max	163.791

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

*mean*	8912.000
σ	0.000
min	8912.000
max	8912.000

*mean*	249.149
σ	235.034
min	113.753
max	863.662

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

*mean*	399.537
σ	6.077
min	383.337
max	404.074

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	561.000
σ	0.000
min	561.000
max	561.000

*mean*	724.420
σ	58.539
min	617.058
max	774.840