Sorry, I should have been more clear. The server only stores 100 cached queries at any one time. If a new cached query is run, the oldest will be knocked off the list of 100 stored and so is no longer cached. It will only be cached once it is run again. This is why on a server with many applications you will not get a huge performance increase from cached queries. Dumping the query into a session or application scope is entirely seperate from the caching process.
I assume that a QofQ is identical to a query as far as caching goes -- it's relationship to another query would not be cached, just the query itself. HTH ----- Original Message ----- From: "Beattie, Barry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 13, 2003 11:57 AM Subject: RE: [ cf-dev ] Query cacheing > > > >> - and only 100 per server > > is that even if you dump the cached queries into session or application > scope? > only 100 avail for Q-of-Q? > > cheers > barry.b > > > -----Original Message----- > From: Damian Watson [mailto:[EMAIL PROTECTED] > Sent: Thursday, 13 November 2003 8:20 PM > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] Query cacheing > > > Yup, server-wide -- and only 100 per server is the setting so on a server > with a lot of sites the gains are rather minimal... > > ----- Original Message ----- > From: "Aidan Whitehall" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, November 13, 2003 9:50 AM > Subject: RE: [ cf-dev ] Query cacheing > > > > Cached queries are application-specific rather than session-specific? > > Just done a test, and they aren't application specific but server wide. > > > > -- > Aidan Whitehall <mailto:[EMAIL PROTECTED]> > Macromedia ColdFusion Developer > Fairbanks Environmental Ltd +44 (0)1695 51775 > Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards> > > ________________________________________________________________________ > This e-mail has been scanned for all viruses by Star Internet. The > service is powered by MessageLabs. For more information on a proactive > anti-virus service working around the clock, around the globe, visit: > http://www.star.net.uk > ________________________________________________________________________ > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
