|Subject||Re: [firebird-support] Re: Speed issues|
> On Feb 9, 2015, at 11:52 AM, 'Leyne, Sean' Sean@... [firebird-support] <firstname.lastname@example.org> wrote:
>> What is your cache settings
>A 2048 page cache may be small enough that it would cause problems even during loading, given the size of his database and the tables involved. Having to reload the same pointer pages would exacerbate his problems. Given that the access is indexed, pointer pages and intermediate index pages may need to be loaded several times after they've forced all the metadata pages out.
> Zoran's complaint is about the first time the query is executed. In that case, nothing would be in cache and everything would still need to be loaded from disk.
It can't hurt to us a much larger cache.