efbe0230db32cf3553b5e037e17f5f69c8ff9445

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.003
min	36.780
max	36.788

*mean*	8991.900
σ	28.144
min	8983.000
max	9072.000

*mean*	108.393
σ	301.863
min	12.515
max	967.509

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.782
σ	0.002
min	36.780
max	36.784

*mean*	8991.900
σ	28.144
min	8983.000
max	9072.000

*mean*	13.420
σ	1.329
min	12.024
max	16.325

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*	5240.600
σ	2594.861
min	1270.000
max	8670.000

*mean*	98.607
σ	19.064
min	61.182
max	113.487

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.832
σ	0.002
min	70.830
max	70.834

*mean*	8983.000
σ	0.000
min	8983.000
max	8983.000

*mean*	131.451
σ	11.696
min	114.994
max	145.732

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

*mean*	5240.600
σ	2594.861
min	1270.000
max	8670.000

*mean*	9478.975
σ	1681.659
min	6712.255
max	12417.818

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.903
σ	0.004
min	14060.897
max	14060.908

*mean*	8983.000
σ	0.000
min	8983.000
max	8983.000

*mean*	7083.731
σ	2038.791
min	5454.342
max	11108.659

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

*mean*	4863.800
σ	2527.720
min	1044.000
max	8670.000

*mean*	4225.010
σ	1070.523
min	3495.639
max	6922.236

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.582
σ	0.004
min	2524.579
max	2524.592

*mean*	8983.000
σ	0.000
min	8983.000
max	8983.000

*mean*	1377.176
σ	910.142
min	1034.016
max	3936.024

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

*mean*	8983.000
σ	0.000
min	8983.000
max	8983.000

*mean*	13.795
σ	1.713
min	11.407
max	15.480

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	42.067
σ	0.002
min	42.065
max	42.070

*mean*	8701.300
σ	98.979
min	8670.000
max	8983.000

*mean*	14.630
σ	1.577
min	11.285
max	16.200

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*	8701.300
σ	98.979
min	8670.000
max	8983.000

*mean*	9783.298
σ	1825.428
min	6582.803
max	12216.358

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.566
σ	0.002
min	26.564
max	26.568

*mean*	5240.600
σ	2594.861
min	1270.000
max	8670.000

*mean*	7.044
σ	0.594
min	6.088
max	7.861

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.110
σ	0.002
min	41.109
max	41.114

*mean*	8983.000
σ	0.000
min	8983.000
max	8983.000

*mean*	91.042
σ	18.768
min	63.737
max	108.183

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	41.111
σ	0.002
min	41.109
max	41.113

*mean*	8983.000
σ	0.000
min	8983.000
max	8983.000

*mean*	91.095
σ	18.705
min	64.116
max	108.117

iterations=10

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

rows=200000

*mean*	41.116
σ	0.002
min	41.114
max	41.118

*mean*	8983.000
σ	0.000
min	8983.000
max	8983.000

*mean*	91.298
σ	18.790
min	64.188
max	108.988

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.770
σ	0.002
min	27.768
max	27.773

*mean*	5240.600
σ	2594.861
min	1270.000
max	8670.000

*mean*	9.834
σ	0.576
min	8.767
max	10.332

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	41.116
σ	0.002
min	41.114
max	41.119

*mean*	8983.000
σ	0.000
min	8983.000
max	8983.000

*mean*	91.310
σ	18.821
min	64.605
max	108.496

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.041
min	15074.105
max	15074.239

*mean*	8991.900
σ	28.144
min	8983.000
max	9072.000

*mean*	9779.729
σ	1827.546
min	6578.892
max	12514.146

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*	8701.300
σ	98.979
min	8670.000
max	8983.000

*mean*	5.242
σ	0.177
min	5.034
max	5.513

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.795
σ	0.002
min	25.793
max	25.797

*mean*	8701.300
σ	98.979
min	8670.000
max	8983.000

*mean*	5.193
σ	0.167
min	4.964
max	5.413

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	26.100
σ	0.003
min	26.096
max	26.104

*mean*	8701.300
σ	98.979
min	8670.000
max	8983.000

*mean*	5.209
σ	0.181
min	5.045
max	5.602

iterations=10

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

rows=200000

*mean*	26.099
σ	0.002
min	26.096
max	26.101

*mean*	8701.300
σ	98.979
min	8670.000
max	8983.000

*mean*	5.187
σ	0.171
min	4.991
max	5.521

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.836
max	66.841

*mean*	8983.000
σ	0.000
min	8983.000
max	8983.000

*mean*	141.433
σ	25.483
min	104.549
max	164.930

iterations=10

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

rows=200000

*mean*	66.838
σ	0.003
min	66.836
max	66.845

*mean*	8983.000
σ	0.000
min	8983.000
max	8983.000

*mean*	209.159
σ	220.047
min	106.206
max	831.472

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*	475.700
σ	0.483
min	475.000
max	476.000

*mean*	380.813
σ	32.406
min	304.766
max	404.073

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*	738.910
σ	62.416
min	636.010
max	790.352