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]
