Alex (Skinner) may be able to advise but taken from CF Admin course notes: "Do not limit the number of cached queries on the server, as caching queries can be a fundamental performance booster. I would set this to 9999. When CF runs out of memory it will simpy drop the oldest query from the cache"
but Following article http://www.defusion.com/articles/index.cfm?articleid=130 says: In ColdFusion 4.5 the number of cached queries that you can have on the server is only really limited by the amount of physical memory you have in your machine. This setting is provided as a way for you to limit yourself, so that you don't get carried away and eat up all of your server resources storing cached query results. Also keep in mind the size of the result sets for the queries you are caching. This setting will allow you to limit the NUMBER of cached queries, but that has nothing to do with the total SIZE of all of the cached queries combined. Looks like there is an impact on server resources but can also dramatically help performance. I know that I where I have experimented with cached and uncached - the cached query pages are significantly quicker not sure if that helps :o/ _______________________________________________________ * 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:17 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Query cacheing > 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] ======================================================= 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]
