Subject Re: [ib-support] Does Firebird use a cache for past sentences?
Author Milan Babuskov
Marco Lauria wrote:
> At 20.28 18/03/2003 -0300, you wrote:
>>Hi all,
>> If I issue a Select that gets say a 1000 records, and then send the same
>>select (from the same or another client)... does the server 'remember' that
>>previous sentence and its result, or does it re-get the 1000 records from
>>the disk?
> AFAIK currently FB doesn't have a cache for past sentences,
> also you should be aware that such a cache
> would be dangerous in a multi-transaction environment.
> So the answer is FB will re-get the 1000 records from the disk.

I thought that the disk pages containing this records would still be in
memory and FB would re-read data from memory.

Milan Babuskov