Re: [Firebird-devel] Compiled statement cache

2022-02-26 Thread Adriano dos Santos Fernandes
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"

Re: [Firebird-devel] Compiled statement cache

2022-02-26 Thread Carlos H. Cantu
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

Re: [Firebird-devel] Compiled statement cache

2022-02-26 Thread Dmitry Yemanov
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

Re: [Firebird-devel] Compiled statement cache

2022-02-26 Thread Alex Peshkoff via Firebird-devel
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

Re: [Firebird-devel] Compiled statement cache

2022-02-26 Thread Adriano dos Santos Fernandes
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