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
http://fbexport.sourceforge.net