011af648e09c6dab0e24d970c8c6ca70d1441974

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.614
σ	0.000
min	36.614
max	36.615

*mean*	8702.700
σ	191.950
min	8642.000
max	9249.000

*mean*	119.460
σ	228.693
min	12.751
max	639.005

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.614
σ	0.000
min	36.614
max	36.614

*mean*	8702.700
σ	191.950
min	8642.000
max	9249.000

*mean*	14.743
σ	4.040
min	12.200
max	22.491

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.074
σ	0.000
min	62.073
max	62.074

*mean*	5223.000
σ	2585.075
min	1265.000
max	8642.000

*mean*	101.268
σ	14.994
min	79.019
max	117.469

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.663
σ	0.002
min	70.662
max	70.667

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	143.057
σ	34.614
min	122.062
max	238.755

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.672
σ	3.988
min	15108.410
max	15121.021

*mean*	5223.000
σ	2585.075
min	1265.000
max	8642.000

*mean*	9723.555
σ	2124.233
min	6641.068
max	12479.614

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.733
σ	0.002
min	14060.731
max	14060.735

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	7375.148
σ	1734.958
min	5445.681
max	10083.332

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.535
σ	0.002
min	8744.534
max	8744.539

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	4729.340
σ	1449.412
min	3497.337
max	6875.559

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.581
σ	0.002
min	2524.579
max	2524.583

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	1298.473
σ	341.448
min	1035.391
max	1782.208

iterations=10

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.667
σ	0.419
min	8744.535
max	8745.859

*mean*	4847.600
σ	2515.145
min	1045.000
max	8642.000

*mean*	4693.544
σ	1345.380
min	3503.030
max	7616.575

iterations=10

operation_display=load_product()with indexes

rows=200000

*mean*	8744.532
σ	0.002
min	8744.530
max	8744.535

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	4934.265
σ	1668.782
min	3514.396
max	7142.018

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records(), no indexes

rows=200000

*mean*	41.901
σ	0.002
min	41.899
max	41.904

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	13.357
σ	1.838
min	10.878
max	15.225

iterations=10

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.901
σ	0.002
min	41.900
max	41.904

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	12.211
σ	1.259
min	10.527
max	13.713

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	41.901
σ	0.002
min	41.899
max	41.903

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	13.776
σ	2.113
min	10.908
max	16.237

CSV - table_records(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	15088.238
σ	0.002
min	15088.236
max	15088.241

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	9851.185
σ	2314.890
min	6563.475
max	12466.473

CSV - vertical_lookup_list() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed, after column_set(), repeat

rows=200000

*mean*	26.397
σ	0.000
min	26.397
max	26.398

*mean*	5223.000
σ	2585.075
min	1265.000
max	8642.000

*mean*	6.829
σ	0.445
min	6.275
max	7.619

iterations=10

operation_display=vertical_lookup_list() on indexed, after table_records(), repeat

rows=200000

*mean*	26.398
σ	0.002
min	26.397
max	26.401

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	7.758
σ	1.386
min	6.664
max	10.449

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

*mean*	26.398
σ	0.000
min	26.398
max	26.398

*mean*	8702.700
σ	191.950
min	8642.000
max	9249.000

*mean*	8.033
σ	0.249
min	7.672
max	8.418

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*	40.943
σ	0.002
min	40.942
max	40.947

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	88.677
σ	18.810
min	64.462
max	108.837

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.943
σ	0.002
min	40.942
max	40.945

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	88.563
σ	18.678
min	64.060
max	108.035

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.949
σ	0.002
min	40.947
max	40.952

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	88.698
σ	18.486
min	65.496
max	108.319

iterations=10

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

rows=200000

*mean*	40.948
σ	0.002
min	40.947
max	40.951

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	88.745
σ	18.599
min	64.791
max	108.080

CSV - vertical_lookup_list(), mini warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed, after column_set()

rows=200000

*mean*	27.602
σ	0.002
min	27.602
max	27.607

*mean*	5223.000
σ	2585.075
min	1265.000
max	8642.000

*mean*	9.687
σ	0.687
min	8.662
max	10.384

iterations=10

operation_display=vertical_lookup_list() on indexed, after table_records()

rows=200000

*mean*	27.602
σ	0.001
min	27.602
max	27.605

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	9.733
σ	1.594
min	8.315
max	12.641

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*	15073.940
σ	0.001
min	15073.939
max	15073.941

*mean*	8702.700
σ	191.950
min	8642.000
max	9249.000

*mean*	9592.321
σ	1969.397
min	6547.069
max	11965.846

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.634
σ	0.002
min	25.631
max	25.637

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	5.918
σ	1.236
min	5.215
max	8.287

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.628
σ	0.002
min	25.626
max	25.631

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	5.871
σ	1.256
min	5.186
max	8.281

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.932
σ	0.002
min	25.930
max	25.935

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	5.904
σ	1.292
min	5.199
max	8.424

iterations=10

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

rows=200000

*mean*	25.931
σ	0.002
min	25.930
max	25.934

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	5.796
σ	1.300
min	4.798
max	8.264

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.671
σ	0.001
min	66.670
max	66.673

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	215.516
σ	251.943
min	105.784
max	929.426

iterations=10

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

rows=200000

*mean*	66.671
σ	0.003
min	66.670
max	66.677

*mean*	8642.000
σ	0.000
min	8642.000
max	8642.000

*mean*	244.380
σ	345.111
min	106.525
max	1224.581

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*	367.449
σ	36.945
min	302.495
max	405.419

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*	711.715
σ	86.832
min	571.700
max	797.561