Subject Re: [ib-support] Does Firebird use a cache for past sentences?
Author Marco Lauria
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.
Regards
Marco

Best Regards,
Marco Lauria
STARMAX s.a.s.
TEL. +39-091-6880476
FAX. +39-091-6887202
MOB. +39-348-3547034

[Non-text portions of this message have been removed]