> ---In firebird-support@yahoogroups.com, <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

Regards,
Vlad