On Sun, 14 Apr 2002 12:11:31 +0800 "Christopher Kings-Lynne" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> PGP Key ID: DB3C29FC ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]