> On Feb 9, 2015, at 11:52 AM, 'Leyne, Sean' Sean@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
>
>> What is your cache settings

[2048]

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

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.

It can't hurt to us a much larger cache.

Good luck,

Ann

>