On Sun, 14 Apr 2002 12:11:31 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> wrote:
> Does it cache all queries or just explicitly prepared ones?
Just explicitly prepared ones. Caching all queries opens a can of
worms that I'd rather not deal with at the moment (volunteers to
tackle this problem are welcome).
>
> Does is check for cached queries all the time or just explicitly EXECUTED
> ones?
A cached query plan is only used for EXECUTE queries -- it is
not used all the time. My gut feeling WRT to caching everything
is similar to my response to your first question.
Cheers,
Neil
--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC