Re: [Firebird-devel] Compiled statement cache
On 26/02/2022 14:43, Dmitry Yemanov wrote: > 26.02.2022 17:14, Adriano dos Santos Fernandes wrote: >> >> I do want to define default cache size. >> >> I'm thinking in 2M. >> >> Comments? > > We need to start with something, so why not. However, it would be > helpful to know what are the "common" statement sizes for tables, > procedures, etc. Of course, table with one column much differs from > table with 100 computed columns, as well as a one-liner procedure > differs from a 1MB-BLR one. But maybe you have more or less real > databases to get these estimations from. > Procedure body does not count on this cache, as only the user issued statements counts, not recursively counting others called routines. But amount of parameters count. So as complex EXECUTE BLOCK. And EXECUTE BLOCK' sub routines. But memory size of statement is not always related to compile time, and cache is important for time-consuming compilation too. A situation I'd think here is when there are many indices to analyze. I have seem that very simple selects would have a size of few KBs. So my reason to think in 2M is that even a database with many connections (say 100) will not have a very memory-consuming cache if default is not changed. I will report back some numbers (memory, prepare times). Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Compiled statement cache
Maybe IBSurgeon can help with this, since HQBird monitor statements and they have lots of customers using it... probably an average can be calculated based on them. []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br DY> 26.02.2022 17:14, Adriano dos Santos Fernandes wrote: >> > I do want to define default cache size. >> > I'm thinking in 2M. >> > Comments? DY> We need to start with something, so why not. However, it would be helpful to know what are the "common" statement sizes for tables, procedures, etc. Of course, table with one column much differs from table with 100 computed columns, as well as a one-liner procedure differs from a 1MB-BLR one. But maybe you have more or less real databases to get these estimations from. DY> Dmitry DY> Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Compiled statement cache
26.02.2022 17:14, Adriano dos Santos Fernandes wrote: I do want to define default cache size. I'm thinking in 2M. Comments? We need to start with something, so why not. However, it would be helpful to know what are the "common" statement sizes for tables, procedures, etc. Of course, table with one column much differs from table with 100 computed columns, as well as a one-liner procedure differs from a 1MB-BLR one. But maybe you have more or less real databases to get these estimations from. Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Compiled statement cache
On 2/26/22 17:14, Adriano dos Santos Fernandes wrote: Hi! I do want to define default cache size. I'm thinking in 2M. Comments? As long as it's one_place_change constant - any value is OK for begining. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Compiled statement cache
Hi! I do want to define default cache size. I'm thinking in 2M. Comments? Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel