Subject Re: [firebird-support] About firebird performance
> ---In, <hector@...> wrote :
> I discovered something else quite interesting:
> 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.
  Carefully read firebird.conf. Especially FileSystemCacheThreshold setting.

  You've set page cache for database above default value of FileSystemCacheThreshold (100K > 64K) thus disable file system caching for that database.

  If you really need both page cache of 100K pages and file system cache, raise FileSystemCacheThreshold value to be more than 100K