Subject | Re: [ib-support] Does Firebird use a cache for past sentences? |
---|---|
Author | Marco Lauria |
Post date | 2003-03-18T23:41:40Z |
At 20.28 18/03/2003 -0300, you wrote:
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]
>Hi all,AFAIK currently FB doesn't have a cache for past sentences,
> 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?
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]