> the number of cached queries can be altered in CF Admin Ah yeah... I was going to ask about that. Do you have any ideas of the performance issues of ramping it up? I seem to remember being advised against doing it...
----- Original Message ----- From: "Lovelock, Richard J" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 13, 2003 12:10 PM Subject: RE: [ cf-dev ] Query cacheing > >>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. > > i believe that is correct about the caching of QofQ > > the number of cached queries can be altered in CF Admin > > _______________________________________________________ > * Regards, > Richard Lovelock > Westminster City Council - Web Support > Cap Gemini Ernst & Young > Southbank > 95 Wandsworth Road > London > SW8 2HG > ( 0870 906 7482 > > _______________________________________________________ > > > -----Original Message----- > From: Damian Watson [mailto:[EMAIL PROTECTED] > Sent: 13 November 2003 12:08 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] Query cacheing > > > 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] > > > ======================================================= > This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst & Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, youare not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. > ======================================================= > > > -- > ** 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]
