Subject Re: [firebird-support] About firebird performance
Author Hector Sánchez
Thanks found the problem!! I set  FileSystemCacheThreshold to 500000 and it works like a charm...I got chache for the db and works really fast...even in the VM.


2015-09-05 23:36 GMT+02:00 hvlad@... [firebird-support] <>:

> ---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


Planatec Software S.L. ** <>
telf: +34 964 340 560 ** fax: +34 961 130 921