2c7673548173ca63dbde4e59bb428aa6fe8cfbfe

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*	8900.500
σ	7.906
min	8898.000
max	8923.000

*mean*	12.611
σ	0.191
min	12.357
max	12.976

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.614
σ	0.000
min	36.613
max	36.614

*mean*	8900.500
σ	7.906
min	8898.000
max	8923.000

*mean*	12.660
σ	0.565
min	11.784
max	13.405

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*	5227.200
σ	2588.170
min	1268.000
max	8655.000

*mean*	101.484
σ	15.417
min	79.086
max	117.167

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.664
σ	0.001
min	70.662
max	70.666

*mean*	8898.000
σ	0.000
min	8898.000
max	8898.000

*mean*	132.213
σ	6.504
min	123.802
max	143.081

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*	5227.200
σ	2588.170
min	1268.000
max	8655.000

*mean*	9634.233
σ	2487.039
min	6608.957
max	12607.891

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.733
σ	0.002
min	14060.731
max	14060.735

*mean*	8898.000
σ	0.000
min	8898.000
max	8898.000

*mean*	7476.783
σ	1191.168
min	5438.984
max	8836.979

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.534
σ	0.000
min	8744.534
max	8744.535

*mean*	8900.500
σ	7.906
min	8898.000
max	8923.000

*mean*	4732.892
σ	1291.552
min	3539.566
max	7031.458

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.581
σ	0.002
min	2524.579
max	2524.584

*mean*	8898.000
σ	0.000
min	8898.000
max	8898.000

*mean*	1536.310
σ	894.430
min	1024.768
max	3279.167

iterations=10

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.667
σ	0.419
min	8744.534
max	8745.859

*mean*	4850.300
σ	2516.959
min	1046.000
max	8655.000

*mean*	4698.528
σ	1287.114
min	3513.283
max	7056.256

iterations=10

operation_display=load_product()with indexes

rows=200000

*mean*	8744.532
σ	0.002
min	8744.530
max	8744.535

*mean*	8679.300
σ	76.843
min	8655.000
max	8898.000

*mean*	4486.250
σ	990.049
min	3499.622
max	5884.975

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

*mean*	13.260
σ	1.286
min	11.595
max	15.077

iterations=10

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.901
σ	0.002
min	41.900
max	41.903

*mean*	8898.000
σ	0.000
min	8898.000
max	8898.000

*mean*	12.056
σ	1.056
min	10.915
max	13.571

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	41.901
σ	0.002
min	41.899
max	41.904

*mean*	8679.300
σ	76.843
min	8655.000
max	8898.000

*mean*	13.611
σ	1.637
min	10.692
max	15.634

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

*mean*	8679.300
σ	76.843
min	8655.000
max	8898.000

*mean*	10043.494
σ	1908.500
min	6533.487
max	11843.495

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*	5227.200
σ	2588.170
min	1268.000
max	8655.000

*mean*	6.306
σ	0.576
min	5.390
max	7.072

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*	8679.300
σ	76.843
min	8655.000
max	8898.000

*mean*	6.463
σ	0.390
min	5.472
max	6.761

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

*mean*	26.398
σ	0.000
min	26.398
max	26.398

*mean*	8900.500
σ	7.906
min	8898.000
max	8923.000

*mean*	7.514
σ	0.371
min	6.835
max	8.024

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

*mean*	91.440
σ	13.091
min	74.446
max	107.907

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.943
σ	0.002
min	40.942
max	40.946

*mean*	8898.000
σ	0.000
min	8898.000
max	8898.000

*mean*	91.304
σ	13.012
min	74.552
max	107.532

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

*mean*	8898.000
σ	0.000
min	8898.000
max	8898.000

*mean*	91.285
σ	13.312
min	74.230
max	107.435

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

*mean*	91.410
σ	13.166
min	74.353
max	107.829

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*	5227.200
σ	2588.170
min	1268.000
max	8655.000

*mean*	9.295
σ	0.740
min	8.244
max	10.116

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*	8679.300
σ	76.843
min	8655.000
max	8898.000

*mean*	9.078
σ	0.562
min	7.801
max	9.619

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*	8900.500
σ	7.906
min	8898.000
max	8923.000

*mean*	9752.198
σ	1927.388
min	6572.003
max	11702.880

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*	8679.300
σ	76.843
min	8655.000
max	8898.000

*mean*	4.859
σ	0.103
min	4.708
max	5.004

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*	8679.300
σ	76.843
min	8655.000
max	8898.000

*mean*	4.877
σ	0.195
min	4.673
max	5.342

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*	8679.300
σ	76.843
min	8655.000
max	8898.000

*mean*	4.919
σ	0.090
min	4.815
max	5.057

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*	8679.300
σ	76.843
min	8655.000
max	8898.000

*mean*	4.870
σ	0.057
min	4.801
max	5.004

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.002
min	66.670
max	66.673

*mean*	8898.000
σ	0.000
min	8898.000
max	8898.000

*mean*	141.214
σ	17.821
min	118.233
max	163.358

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

*mean*	141.548
σ	17.251
min	119.236
max	163.285

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

*mean*	381.868
σ	28.023
min	303.599
max	398.137

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*	731.764
σ	64.915
min	627.824
max	823.151