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