Title
#users-public
j

Jack

08/23/2022, 7:04 PM
Evening - just interested if there are any stats on what improvements you would see on a query if you enable "cairo.default.symbol.cache.flag"?
Bolek Ziobrowski

Bolek Ziobrowski

08/24/2022, 7:19 AM
It's on/true by default .
8:17 AM
I did some quick tests and looks like when symbol is cached adding values can be visibly faster .
create table symtest ( s symbol);
insert into symtest select 's' || (x%50000) from long_sequence(10000000);
--4 seconds 

create table symtest2 ( s symbol nocache );
insert into symtest2 select 's' || (x%50000) from long_sequence(10000000);
--62 seconds
j

Jack

08/24/2022, 8:18 AM
ah it's on by default? The docs indicated it was set to false
Bolek Ziobrowski

Bolek Ziobrowski

08/24/2022, 8:20 AM
Guess it's time to update docs 🙂
j

Jack

08/24/2022, 8:21 AM
I only ask because I saw it in the docs and got excited at making queries faster - we're all good!
8:31 AM
thanks!
Pei

Pei

08/24/2022, 8:36 AM
cc @Amy Wang
Bolek Ziobrowski

Bolek Ziobrowski

08/24/2022, 8:43 AM
@Jack Turns out when caching is disabled symbol column is more 'sensitive' to capacity parameter :
create table symtest3 ( s symbol capacity 100000 nocache );
insert into symtest3 select 's' || (x%50000) from long_sequence(10000000);
--2 seconds