Compare commits

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-36.783=-0.000
σ	0.002-0.002=-0.000
min	36.781-36.781=0.000
max	36.785-36.785=0.000

*mean*	9663.000-9804.000=-141.000
σ	0.000
min	9663.000-9804.000=-141.000
max	9663.000-9804.000=-141.000

*mean*	13.139-13.376=-0.238
σ	0.531-0.458=0.073
min	12.368-12.653=-0.286
max	13.862-13.982=-0.120

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.783-36.783=0.000
σ	0.002-0.002=-0.000
min	36.781-36.781=0.000
max	36.785-36.785=-0.000

*mean*	9663.000-9804.000=-141.000
σ	0.000
min	9663.000-9804.000=-141.000
max	9663.000-9804.000=-141.000

*mean*	12.833-13.009=-0.176
σ	0.631-0.547=0.083
min	12.142-12.223=-0.081
max	13.790-13.891=-0.102

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.244-62.241=0.002
σ	0.002-0.000=0.002
min	62.241-62.241=0.000
max	62.245-62.241=0.004

*mean*	5185.500-5086.500=99.000
σ	2674.754-2509.664=165.089
min	1295.000-1297.000=-2.000
max	9663.000-8381.000=1282.000

*mean*	116.393-106.990=9.403
σ	60.250-14.383=45.867
min	84.463-79.469=4.994
max	284.127-118.602=165.525

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.832-70.832=0.000
σ	0.002-0.002=0.000
min	70.830-70.830=0.000
max	70.834-70.834=0.000

*mean*	9663.000-9804.000=-141.000
σ	0.000
min	9663.000-9804.000=-141.000
max	9663.000-9804.000=-141.000

*mean*	135.888-139.831=-3.943
σ	7.277-5.166=2.111
min	122.936-131.539=-8.603
max	143.323-148.728=-5.405

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.844-15109.841=0.002
σ	3.992-3.993=-0.001
min	15108.577
max	15121.205-15121.206=-0.001

*mean*	5180.600-5086.500=94.100
σ	2680.554-2509.664=170.889
min	1295.000-1297.000=-2.000
max	9663.000-8381.000=1282.000

*mean*	9403.905-10337.854=-933.949
σ	2130.782-1966.407=164.375
min	6724.677-6610.779=113.899
max	12733.722-12033.518=700.204

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.903-14060.904=-0.001
σ	0.005-0.005=0.000
min	14060.898-14060.899=-0.001
max	14060.912-14060.910=0.001

*mean*	9663.000-9804.000=-141.000
σ	0.000
min	9663.000-9804.000=-141.000
max	9663.000-9804.000=-141.000

*mean*	6500.876-6838.172=-337.296
σ	1516.186-1454.580=61.606
min	5420.042-5462.941=-42.899
max	9739.135-8935.807=803.327

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=load_product()

rows=200000

*mean*	8744.666-8744.667=-0.000
σ	0.419-0.418=0.001
min	8744.531-8744.531=0.000
max	8745.858-8745.856=0.001

*mean*	4566.400-4688.300=-121.900
σ	2531.801-2487.452=44.349
min	1052.000-1051.000=1.000
max	8035.000-8381.000=-346.000

*mean*	4354.131-4951.119=-596.988
σ	1357.778-1538.749=-180.972
min	3542.667-3497.933=44.734
max	7075.314-7292.302=-216.988

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.582-2524.581=0.001
σ	0.002-0.002=-0.000
min	2524.579-2524.579=0.000
max	2524.583-2524.584=-0.000

*mean*	9663.000-9804.000=-141.000
σ	0.000
min	9663.000-9804.000=-141.000
max	9663.000-9804.000=-141.000

*mean*	1045.963-1091.560=-45.597
σ	7.102-144.192=-137.090
min	1034.238-1034.767=-0.529
max	1062.828-1501.659=-438.831

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	42.068-42.069=-0.000
σ	0.002-0.002=-0.000
min	42.067-42.066=0.000
max	42.071-42.072=-0.001

*mean*	9663.000-9804.000=-141.000
σ	0.000
min	9663.000-9804.000=-141.000
max	9663.000-9804.000=-141.000

*mean*	14.160-14.443=-0.283
σ	1.315-1.338=-0.023
min	12.135-11.146=0.989
max	15.424-15.529=-0.104

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	42.068-42.067=0.000
σ	0.002-0.002=0.000
min	42.066-42.066=-0.000
max	42.070-42.070=0.000

*mean*	9663.000-8523.300=1139.700
σ	0.000-449.992=-449.992
min	9663.000-8381.000=1282.000
max	9663.000-9804.000=-141.000

*mean*	12.830-12.917=-0.088
σ	1.335-1.891=-0.557
min	11.009-11.308=-0.299
max	15.043-15.826=-0.783

CSV - table_records(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	15088.407-15088.407=-0.001
σ	0.003-0.003=0.000
min	15088.403
max	15088.412-15088.411=0.001

*mean*	9663.000-8523.300=1139.700
σ	0.000-449.992=-449.992
min	9663.000-8381.000=1282.000
max	9663.000-9804.000=-141.000

*mean*	9031.873-9611.924=-580.051
σ	2039.189-2057.889=-18.700
min	6545.383-6640.943=-95.559
max	12568.954-11646.023=922.932

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-26.567=-0.000
σ	0.002-0.002=0.000
min	26.564-26.565=-0.000
max	26.569-26.569=0.000

*mean*	5185.500-5086.500=99.000
σ	2674.754-2509.664=165.089
min	1295.000-1297.000=-2.000
max	9663.000-8381.000=1282.000

*mean*	7.036-7.292=-0.256
σ	0.459-0.350=0.109
min	6.230-6.594=-0.364
max	7.899-7.789=0.110

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.111-41.112=-0.001
σ	0.002-0.002=-0.001
min	41.110-41.109=0.000
max	41.114-41.116=-0.003

*mean*	9663.000-9804.000=-141.000
σ	0.000
min	9663.000-9804.000=-141.000
max	9663.000-9804.000=-141.000

*mean*	153.314-204.494=-51.180
σ	182.432-330.404=-147.972
min	76.435-86.903=-10.468
max	671.405-1144.653=-473.248

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	41.112-41.112=0.000
σ	0.002-0.002=-0.000
min	41.110-41.109=0.000
max	41.114-41.114=-0.000

*mean*	9663.000-9804.000=-141.000
σ	0.000
min	9663.000-9804.000=-141.000
max	9663.000-9804.000=-141.000

*mean*	95.305-98.172=-2.866
σ	12.079-8.729=3.350
min	76.763-81.567=-4.804
max	104.536-106.874=-2.337

iterations=10

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

rows=200000

*mean*	41.117-41.116=0.000
σ	0.002-0.002=0.000
min	41.115-41.115=0.000
max	41.120-41.120=0.000

*mean*	9663.000-9804.000=-141.000
σ	0.000
min	9663.000-9804.000=-141.000
max	9663.000-9804.000=-141.000

*mean*	96.750-100.449=-3.699
σ	12.193-6.611=5.582
min	77.393-87.241=-9.847
max	105.086-105.997=-0.911

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-27.771=-0.000
σ	0.002-0.003=-0.001
min	27.769-27.769=0.000
max	27.774-27.778=-0.004

*mean*	5185.500-5086.500=99.000
σ	2674.754-2509.664=165.089
min	1295.000-1297.000=-2.000
max	9663.000-8381.000=1282.000

*mean*	9.404-9.948=-0.544
σ	0.628-0.652=-0.024
min	8.749-8.829=-0.081
max	10.359-10.568=-0.209

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	41.117-41.117=-0.000
σ	0.002-0.002=0.000
min	41.114
max	41.119

*mean*	9663.000-9804.000=-141.000
σ	0.000
min	9663.000-9804.000=-141.000
max	9663.000-9804.000=-141.000

*mean*	96.714-100.917=-4.203
σ	12.233-6.958=5.275
min	77.142-86.917=-9.776
max	105.109-106.360=-1.252

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-15074.110=0.012
σ	0.040-0.003=0.037
min	15074.106
max	15074.235-15074.114=0.121

*mean*	9663.000-9804.000=-141.000
σ	0.000
min	9663.000-9804.000=-141.000
max	9663.000-9804.000=-141.000

*mean*	9853.423-9323.317=530.106
σ	2133.213-1967.760=165.453
min	6581.271-6560.235=21.036
max	12287.497-12186.100=101.396

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-25.801=0.000
σ	0.002-0.002=-0.000
min	25.799-25.798=0.000
max	25.802-25.804=-0.001

*mean*	9663.000-8523.300=1139.700
σ	0.000-449.992=-449.992
min	9663.000-8381.000=1282.000
max	9663.000-9804.000=-141.000

*mean*	5.440-5.297=0.143
σ	0.174-0.102=0.073
min	5.141-5.138=0.003
max	5.668-5.423=0.246

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.795-25.796=-0.001
σ	0.002-0.002=0.000
min	25.793-25.793=-0.000
max	25.798-25.798=0.000

*mean*	9663.000-8523.300=1139.700
σ	0.000-449.992=-449.992
min	9663.000-8381.000=1282.000
max	9663.000-9804.000=-141.000

*mean*	5.441-5.224=0.217
σ	0.287-0.169=0.118
min	5.041-4.939=0.102
max	6.119-5.412=0.707

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	26.101-26.100=0.000
σ	0.002-0.002=0.001
min	26.097-26.097=0.000
max	26.106-26.102=0.003

*mean*	9663.000-8523.300=1139.700
σ	0.000-449.992=-449.992
min	9663.000-8381.000=1282.000
max	9663.000-9804.000=-141.000

*mean*	5.366-5.280=0.086
σ	0.202-0.145=0.057
min	4.997-4.972=0.025
max	5.647-5.441=0.206

iterations=10

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

rows=200000

*mean*	26.099-26.099=0.000
σ	0.002-0.002=0.000
min	26.097-26.097=-0.000
max	26.101

*mean*	9663.000-8523.300=1139.700
σ	0.000-449.992=-449.992
min	9663.000-8381.000=1282.000
max	9663.000-9804.000=-141.000

*mean*	5.342-5.326=0.016
σ	0.122-0.161=-0.038
min	5.096-4.968=0.128
max	5.452-5.586=-0.133

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-66.839=0.001
σ	0.004-0.002=0.002
min	66.837-66.837=0.000
max	66.849-66.841=0.008

*mean*	9663.000-9804.000=-141.000
σ	0.000
min	9663.000-9804.000=-141.000
max	9663.000-9804.000=-141.000

*mean*	269.753-150.105=119.647
σ	396.082-14.672=381.410
min	122.053-118.053=4.000
max	1395.847-163.336=1232.511

iterations=10

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

rows=200000

*mean*	66.838-66.839=-0.001
σ	0.002-0.002=-0.000
min	66.837
max	66.841-66.843=-0.002

*mean*	9663.000-9804.000=-141.000
σ	0.000
min	9663.000-9804.000=-141.000
max	9663.000-9804.000=-141.000

*mean*	143.195-203.688=-60.494
σ	18.923-169.573=-150.651
min	118.395-119.935=-1.540
max	162.710-684.620=-521.910

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*	473.900
σ	0.316
min	473.000
max	474.000

*mean*	401.387
σ	5.392
min	392.833
max	410.263

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	559.000-557.600=1.400
σ	0.000-4.427=-4.427
min	559.000-545.000=14.000
max	559.000

*mean*	780.731-757.670=23.061
σ	21.772-60.162=-38.389
min	732.063-637.075=94.988
max	800.818-805.263=-4.445