Yup about the caching... only 100 default. I seem to rememebr a useful thing in caching is to cache a query for a long period of time and when content is updated in your cfm to run that query on the frontend so that the query basically only ever operates when you make changes... is useful in some instances anyway.
----- Original Message ----- From: "Tomo Smith" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 10:46 AM Subject: Re: [ cf-dev ] Performance > I found using a mixture of SP and cached queries was the daddy, although > Matt's idea certainly has promise, and is something I've had a look at > myself:) I also found that there's absolutely no point in caching things > that run very rarely as you wont get any gains from that. It's also not a > good plan to cache admin areas. > > Also remember that CF admin by default will only cache a certain number of > queries (100 by default) - this can be changed through cfadmin though. If > you're on a shared server, you'll be sharing the cache with other sites. > > HTH > > Tom > ----- Original Message ----- > From: "Allan Cliff" <[EMAIL PROTECTED]> > To: "CF - List" <[EMAIL PROTECTED]> > Sent: Wednesday, October 22, 2003 10:32 AM > Subject: [ cf-dev ] Performance > > > Anyone like to share their opinion on improving coldfusion speed either by > using stored procedures or caching queries? > > Which one is better? Or does it depend on the query. > > At the moment I have a mixture of them both with dynamic queries as SP and > basic queries q_GetCountries and q_GetStates as CachedWithin. > > Any comments? > > Thanks > > Allan > > > -- > ** 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]
