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*	8936.000-9663.000=-727.000
σ	75.895-0.000=75.895
min	8912.000-9663.000=-751.000
max	9152.000-9663.000=-511.000

*mean*	12.930-13.139=-0.209
σ	0.277-0.531=-0.254
min	12.570-12.368=0.202
max	13.521-13.862=-0.341

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*	8936.000-9663.000=-727.000
σ	75.895-0.000=75.895
min	8912.000-9663.000=-751.000
max	9152.000-9663.000=-511.000

*mean*	13.046-12.833=0.214
σ	0.426-0.631=-0.204
min	12.145-12.142=0.003
max	13.572-13.790=-0.218

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

*mean*	5231.800-5185.500=46.300
σ	2591.935-2674.754=-82.819
min	1267.000-1295.000=-28.000
max	8662.000-9663.000=-1001.000

*mean*	102.713-116.393=-13.680
σ	14.806-60.250=-45.444
min	77.543-84.463=-6.920
max	119.156-284.127=-164.971

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

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

*mean*	8912.000-9663.000=-751.000
σ	0.000
min	8912.000-9663.000=-751.000
max	8912.000-9663.000=-751.000

*mean*	136.158-135.888=0.270
σ	4.587-7.277=-2.691
min	128.513-122.936=5.577
max	142.381-143.323=-0.942

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-15109.844=-0.001
σ	3.992-3.992=0.001
min	15108.577
max	15121.206-15121.205=0.001

*mean*	5231.800-5180.600=51.200
σ	2591.935-2680.554=-88.619
min	1267.000-1295.000=-28.000
max	8662.000-9663.000=-1001.000

*mean*	9306.383-9403.905=-97.522
σ	2305.617-2130.782=174.835
min	6664.629-6724.677=-60.049
max	12087.886-12733.722=-645.836

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.904-14060.903=0.001
σ	0.003-0.005=-0.001
min	14060.898
max	14060.909-14060.912=-0.003

*mean*	8912.000-9663.000=-751.000
σ	0.000
min	8912.000-9663.000=-751.000
max	8912.000-9663.000=-751.000

*mean*	7410.076-6500.876=909.200
σ	1630.911-1516.186=114.724
min	5425.181-5420.042=5.139
max	9554.457-9739.135=-184.678

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=load_product()

rows=200000

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

*mean*	4856.900-4566.400=290.500
σ	2522.000-2531.801=-9.801
min	1046.000-1052.000=-6.000
max	8662.000-8035.000=627.000

*mean*	4507.892-4354.131=153.761
σ	1333.004-1357.778=-24.774
min	3516.712-3542.667=-25.955
max	7502.406-7075.314=427.093

iterations=10

operation_display=load_product(), no indexes

rows=200000

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

*mean*	8912.000-9663.000=-751.000
σ	0.000
min	8912.000-9663.000=-751.000
max	8912.000-9663.000=-751.000

*mean*	1129.319-1045.963=83.356
σ	188.237-7.102=181.134
min	1029.673-1034.238=-4.565
max	1489.234-1062.828=426.406

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

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

*mean*	8912.000-9663.000=-751.000
σ	0.000
min	8912.000-9663.000=-751.000
max	8912.000-9663.000=-751.000

*mean*	14.457-14.160=0.297
σ	1.396-1.315=0.081
min	11.554-12.135=-0.581
max	16.224-15.424=0.800

iterations=10

operation_display=table_records(), repeat

rows=200000

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

*mean*	8687.000-9663.000=-976.000
σ	79.057-0.000=79.057
min	8662.000-9663.000=-1001.000
max	8912.000-9663.000=-751.000

*mean*	14.545-12.830=1.715
σ	1.256-1.335=-0.079
min	11.617-11.009=0.608
max	15.925-15.043=0.882

CSV - table_records(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

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

*mean*	8687.000-9663.000=-976.000
σ	79.057-0.000=79.057
min	8662.000-9663.000=-1001.000
max	8912.000-9663.000=-751.000

*mean*	9541.359-9031.873=509.486
σ	1902.100-2039.189=-137.089
min	6521.562-6545.383=-23.821
max	12247.395-12568.954=-321.559

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.565-26.564=0.000
max	26.569

*mean*	5231.800-5185.500=46.300
σ	2591.935-2674.754=-82.819
min	1267.000-1295.000=-28.000
max	8662.000-9663.000=-1001.000

*mean*	7.244-7.036=0.209
σ	0.558-0.459=0.099
min	6.250-6.230=0.020
max	8.017-7.899=0.118

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-41.111=0.001
σ	0.003-0.002=0.001
min	41.110
max	41.116-41.114=0.003

*mean*	8912.000-9663.000=-751.000
σ	0.000
min	8912.000-9663.000=-751.000
max	8912.000-9663.000=-751.000

*mean*	190.274-153.314=36.960
σ	287.332-182.432=104.900
min	87.332-76.435=10.897
max	1007.736-671.405=336.331

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

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

*mean*	8912.000-9663.000=-751.000
σ	0.000
min	8912.000-9663.000=-751.000
max	8912.000-9663.000=-751.000

*mean*	97.009-95.305=1.703
σ	10.567-12.079=-1.512
min	76.452-76.763=-0.311
max	107.019-104.536=2.482

iterations=10

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

rows=200000

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

*mean*	8912.000-9663.000=-751.000
σ	0.000
min	8912.000-9663.000=-751.000
max	8912.000-9663.000=-751.000

*mean*	100.085-96.750=3.335
σ	8.178-12.193=-4.016
min	87.446-77.393=10.053
max	107.453-105.086=2.367

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.002=-0.000
min	27.769
max	27.774-27.774=-0.000

*mean*	5231.800-5185.500=46.300
σ	2591.935-2674.754=-82.819
min	1267.000-1295.000=-28.000
max	8662.000-9663.000=-1001.000

*mean*	9.798-9.404=0.394
σ	0.683-0.628=0.055
min	8.868-8.749=0.120
max	10.382-10.359=0.023

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.120-41.119=0.001

*mean*	8912.000-9663.000=-751.000
σ	0.000
min	8912.000-9663.000=-751.000
max	8912.000-9663.000=-751.000

*mean*	99.864-96.714=3.150
σ	8.407-12.233=-3.826
min	87.303-77.142=10.162
max	107.369-105.109=2.260

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.122=0.000
σ	0.040-0.040=-0.000
min	15074.106
max	15074.235-15074.235=-0.000

*mean*	8936.000-9663.000=-727.000
σ	75.895-0.000=75.895
min	8912.000-9663.000=-751.000
max	9152.000-9663.000=-511.000

*mean*	9255.802-9853.423=-597.621
σ	1920.491-2133.213=-212.723
min	6531.126-6581.271=-50.145
max	12291.061-12287.497=3.565

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

*mean*	8687.000-9663.000=-976.000
σ	79.057-0.000=79.057
min	8662.000-9663.000=-1001.000
max	8912.000-9663.000=-751.000

*mean*	5.337-5.440=-0.103
σ	0.167-0.174=-0.007
min	5.155-5.141=0.015
max	5.595-5.668=-0.073

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

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

*mean*	8687.000-9663.000=-976.000
σ	79.057-0.000=79.057
min	8662.000-9663.000=-1001.000
max	8912.000-9663.000=-751.000

*mean*	5.220-5.441=-0.221
σ	0.202-0.287=-0.085
min	4.959-5.041=-0.082
max	5.570-6.119=-0.550

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

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

*mean*	8687.000-9663.000=-976.000
σ	79.057-0.000=79.057
min	8662.000-9663.000=-1001.000
max	8912.000-9663.000=-751.000

*mean*	5.250-5.366=-0.116
σ	0.272-0.202=0.070
min	4.926-4.997=-0.071
max	5.758-5.647=0.111

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*	8687.000-9663.000=-976.000
σ	79.057-0.000=79.057
min	8662.000-9663.000=-1001.000
max	8912.000-9663.000=-751.000

*mean*	5.239-5.342=-0.102
σ	0.220-0.122=0.098
min	4.930-5.096=-0.166
max	5.638-5.452=0.185

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.000
σ	0.002-0.004=-0.002
min	66.837-66.837=0.000
max	66.842-66.849=-0.007

*mean*	8912.000-9663.000=-751.000
σ	0.000
min	8912.000-9663.000=-751.000
max	8912.000-9663.000=-751.000

*mean*	147.485-269.753=-122.268
σ	16.100-396.082=-379.982
min	112.933-122.053=-9.120
max	163.791-1395.847=-1232.057

iterations=10

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

rows=200000

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

*mean*	8912.000-9663.000=-751.000
σ	0.000
min	8912.000-9663.000=-751.000
max	8912.000-9663.000=-751.000

*mean*	249.149-143.195=105.954
σ	235.034-18.923=216.112
min	113.753-118.395=-4.642
max	863.662-162.710=700.952

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-473.900=2.100
σ	0.000-0.316=-0.316
min	476.000-473.000=3.000
max	476.000-474.000=2.000

*mean*	399.537-401.387=-1.851
σ	6.077-5.392=0.684
min	383.337-392.833=-9.496
max	404.074-410.263=-6.189

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	561.000-559.000=2.000
σ	0.000
min	561.000-559.000=2.000
max	561.000-559.000=2.000

*mean*	724.420-780.731=-56.311
σ	58.539-21.772=36.767
min	617.058-732.063=-115.005
max	774.840-800.818=-25.979