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.
Thanks!! 2015-09-05 23:36 GMT+02:00 [email protected] [firebird-support] < [email protected]>: > > > > ---In [email protected], <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 > > > -- -- Planatec Software S.L. ** <http://www.planatec.es> telf: +34 964 340 560 ** fax: +34 961 130 921
