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.003-0.002=0.001
min	36.780-36.781=-0.001
max	36.788-36.785=0.003

*mean*	8991.900-8552.400=439.500
σ	28.144-34.574=-6.430
min	8983.000-8536.000=447.000
max	9072.000-8618.000=454.000

*mean*	108.393-12.481=95.912
σ	301.863-0.405=301.457
min	12.515-11.836=0.678
max	967.509-13.093=954.416

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.782-36.783=-0.001
σ	0.002-0.002=-0.000
min	36.780-36.781=-0.001
max	36.784-36.785=-0.001

*mean*	8991.900-8552.400=439.500
σ	28.144-34.574=-6.430
min	8983.000-8536.000=447.000
max	9072.000-8618.000=454.000

*mean*	13.420-13.166=0.254
σ	1.329-0.371=0.958
min	12.024-12.407=-0.384
max	16.325-13.773=2.552

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

*mean*	5240.600-5039.600=201.000
σ	2594.861-2527.648=67.213
min	1270.000-1291.000=-21.000
max	8670.000-8536.000=134.000

*mean*	98.607-104.842=-6.236
σ	19.064-10.655=8.408
min	61.182-88.959=-27.777
max	113.487-115.408=-1.921

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

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

*mean*	8983.000-8536.000=447.000
σ	0.000
min	8983.000-8536.000=447.000
max	8983.000-8536.000=447.000

*mean*	131.451-136.856=-5.404
σ	11.696-7.692=4.004
min	114.994-121.183=-6.189
max	145.732-143.421=2.312

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.843=-0.000
σ	3.992-3.993=-0.000
min	15108.577-15108.577=-0.001
max	15121.204-15121.206=-0.001

*mean*	5240.600-5039.600=201.000
σ	2594.861-2527.648=67.213
min	1270.000-1291.000=-21.000
max	8670.000-8536.000=134.000

*mean*	9478.975-9905.669=-426.694
σ	1681.659-1921.589=-239.930
min	6712.255-6536.787=175.467
max	12417.818-11781.621=636.197

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.903-14060.903=0.000
σ	0.004-0.004=0.000
min	14060.897-14060.898=-0.001
max	14060.908-14060.912=-0.004

*mean*	8983.000-8536.000=447.000
σ	0.000
min	8983.000-8536.000=447.000
max	8983.000-8536.000=447.000

*mean*	7083.731-8032.540=-948.809
σ	2038.791-1990.150=48.641
min	5454.342-5374.391=79.950
max	11108.659-11098.012=10.647

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-8744.667=-0.000
σ	0.419-0.418=0.001
min	8744.531
max	8745.858-8745.857=0.001

*mean*	4863.800-4771.000=92.800
σ	2527.720-2500.101=27.619
min	1044.000-1049.000=-5.000
max	8670.000-8536.000=134.000

*mean*	4225.010-5127.065=-902.055
σ	1070.523-1757.715=-687.192
min	3495.639-3458.145=37.494
max	6922.236-7605.003=-682.767

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.582-2524.583=-0.001
σ	0.004-0.004=0.000
min	2524.579-2524.579=-0.000
max	2524.592-2524.589=0.003

*mean*	8983.000-8536.000=447.000
σ	0.000
min	8983.000-8536.000=447.000
max	8983.000-8536.000=447.000

*mean*	1377.176-1562.869=-185.693
σ	910.142-791.375=118.768
min	1034.016-1034.072=-0.056
max	3936.024-3197.306=738.718

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

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

*mean*	8983.000-8536.000=447.000
σ	0.000
min	8983.000-8536.000=447.000
max	8983.000-8536.000=447.000

*mean*	13.795-13.942=-0.147
σ	1.713-1.619=0.094
min	11.407-11.346=0.061
max	15.480-15.232=0.249

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	42.067-42.067=-0.001
σ	0.002-0.002=0.000
min	42.065-42.066=-0.001
max	42.070-42.071=-0.000

*mean*	8701.300-8536.000=165.300
σ	98.979-0.000=98.979
min	8670.000-8536.000=134.000
max	8983.000-8536.000=447.000

*mean*	14.630-12.677=1.953
σ	1.577-1.785=-0.208
min	11.285-11.117=0.169
max	16.200-15.099=1.101

CSV - table_records(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

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

*mean*	8701.300-8536.000=165.300
σ	98.979-0.000=98.979
min	8670.000-8536.000=134.000
max	8983.000-8536.000=447.000

*mean*	9783.298-9494.119=289.179
σ	1825.428-2512.452=-687.024
min	6582.803-6509.324=73.479
max	12216.358-12395.935=-179.577

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

*mean*	5240.600-5039.600=201.000
σ	2594.861-2527.648=67.213
min	1270.000-1291.000=-21.000
max	8670.000-8536.000=134.000

*mean*	7.044-7.170=-0.126
σ	0.594-0.281=0.313
min	6.088-6.683=-0.595
max	7.861-7.523=0.338

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-41.111=-0.001
σ	0.002-0.002=-0.000
min	41.109-41.110=-0.001
max	41.114-41.115=-0.001

*mean*	8983.000-8536.000=447.000
σ	0.000
min	8983.000-8536.000=447.000
max	8983.000-8536.000=447.000

*mean*	91.042-93.836=-2.794
σ	18.768-15.959=2.808
min	63.737-66.574=-2.837
max	108.183-106.685=1.498

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	41.111-41.112=-0.001
σ	0.002-0.003=-0.001
min	41.109-41.110=-0.001
max	41.113-41.117=-0.004

*mean*	8983.000-8536.000=447.000
σ	0.000
min	8983.000-8536.000=447.000
max	8983.000-8536.000=447.000

*mean*	91.095-184.757=-93.661
σ	18.705-293.087=-274.382
min	64.116-66.463=-2.347
max	108.117-1017.636=-909.519

iterations=10

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

rows=200000

*mean*	41.116-41.117=-0.001
σ	0.002-0.002=0.000
min	41.114-41.115=-0.001
max	41.118-41.119=-0.001

*mean*	8983.000-8536.000=447.000
σ	0.000
min	8983.000-8536.000=447.000
max	8983.000-8536.000=447.000

*mean*	91.298-95.214=-3.916
σ	18.790-14.359=4.430
min	64.188-67.375=-3.187
max	108.988-106.725=2.264

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-27.771=-0.001
σ	0.002
min	27.768-27.769=-0.001
max	27.773-27.774=-0.001

*mean*	5240.600-5039.600=201.000
σ	2594.861-2527.648=67.213
min	1270.000-1291.000=-21.000
max	8670.000-8536.000=134.000

*mean*	9.834-9.725=0.110
σ	0.576-0.600=-0.023
min	8.767-8.777=-0.010
max	10.332-10.323=0.009

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

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

*mean*	8983.000-8536.000=447.000
σ	0.000
min	8983.000-8536.000=447.000
max	8983.000-8536.000=447.000

*mean*	91.310-127.408=-36.099
σ	18.821-99.743=-80.923
min	64.605-66.179=-1.574
max	108.496-408.323=-299.826

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.001
σ	0.041-0.040=0.001
min	15074.105-15074.106=-0.001
max	15074.239-15074.235=0.003

*mean*	8991.900-8552.400=439.500
σ	28.144-34.574=-6.430
min	8983.000-8536.000=447.000
max	9072.000-8618.000=454.000

*mean*	9779.729-9912.240=-132.510
σ	1827.546-2304.454=-476.908
min	6578.892-6536.337=42.555
max	12514.146-12511.799=2.347

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.800=-0.001
σ	0.002-0.002=0.000
min	25.798-25.798=-0.001
max	25.802-25.802=-0.001

*mean*	8701.300-8536.000=165.300
σ	98.979-0.000=98.979
min	8670.000-8536.000=134.000
max	8983.000-8536.000=447.000

*mean*	5.242-5.291=-0.049
σ	0.177-0.099=0.077
min	5.034-5.084=-0.050
max	5.513-5.430=0.083

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.001
max	25.797-25.797=-0.001

*mean*	8701.300-8536.000=165.300
σ	98.979-0.000=98.979
min	8670.000-8536.000=134.000
max	8983.000-8536.000=447.000

*mean*	5.193-5.163=0.030
σ	0.167-0.092=0.074
min	4.964-5.040=-0.076
max	5.413-5.346=0.067

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	26.100-26.101=-0.001
σ	0.003-0.003=-0.001
min	26.096-26.097=-0.001
max	26.104-26.106=-0.002

*mean*	8701.300-8536.000=165.300
σ	98.979-0.000=98.979
min	8670.000-8536.000=134.000
max	8983.000-8536.000=447.000

*mean*	5.209-5.175=0.035
σ	0.181-0.093=0.088
min	5.045-4.988=0.057
max	5.602-5.328=0.274

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.096-26.097=-0.001
max	26.101-26.101=-0.000

*mean*	8701.300-8536.000=165.300
σ	98.979-0.000=98.979
min	8670.000-8536.000=134.000
max	8983.000-8536.000=447.000

*mean*	5.187-5.107=0.080
σ	0.171-0.086=0.086
min	4.991-5.029=-0.037
max	5.521-5.285=0.236

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.002-0.002=-0.000
min	66.836-66.837=-0.001
max	66.841-66.842=-0.001

*mean*	8983.000-8536.000=447.000
σ	0.000
min	8983.000-8536.000=447.000
max	8983.000-8536.000=447.000

*mean*	141.433-142.147=-0.714
σ	25.483-23.258=2.226
min	104.549-106.944=-2.395
max	164.930-165.702=-0.772

iterations=10

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

rows=200000

*mean*	66.838-66.838=-0.001
σ	0.003-0.002=0.001
min	66.836-66.837=-0.001
max	66.845-66.841=0.004

*mean*	8983.000-8536.000=447.000
σ	0.000
min	8983.000-8536.000=447.000
max	8983.000-8536.000=447.000

*mean*	209.159-172.169=36.990
σ	220.047-89.248=130.799
min	106.206-107.750=-1.543
max	831.472-417.859=413.614

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-473.500=2.200
σ	0.483-0.527=-0.044
min	475.000-473.000=2.000
max	476.000-474.000=2.000

*mean*	380.813-384.299=-3.487
σ	32.406-32.970=-0.565
min	304.766-321.968=-17.202
max	404.073-402.416=1.657

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	561.000-560.000=1.000
σ	0.000
min	561.000-560.000=1.000
max	561.000-560.000=1.000

*mean*	738.910-749.202=-10.293
σ	62.416-59.817=2.599
min	636.010-656.577=-20.567
max	790.352-800.211=-9.860