|Subject||Re: [firebird-support] About firebird performance|
> ---In email@example.com, <hector@...> wrote :You've set page cache for database above default value of FileSystemCacheThreshold (100K > 64K) thus disable file system caching for that database.>> I discovered something else quite interesting:Carefully read firebird.conf. Especially FileSystemCacheThreshold setting.>> I realized both IB and FB dbs have pagebuffers set to 100.000. I changed FB to 0 and now it works like I
> expected!!..Same query now completes on FB on 50 sec. It seems this is the problem although I don't
> understand why.
If you really need both page cache of 100K pages and file system cache, raise FileSystemCacheThreshold value to be more than 100K