|Subject||Re: [firebird-support] About firebird performance|
Thanks Vlad...you 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] <firstname.lastname@example.org>:
> ---In email@example.com, <hector@...> wrote :>> 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.
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. ** <http://www.planatec.es>
telf: +34 964 340 560 ** fax: +34 961 130 921