storedprocs are great as the are semi precompiled but if the datapath changes on each query you wont see much performance enhancement
one way to increase performance is to cffile the most visited pages down to HTML pages and serve those up instead of the CFML if no updates have occured since the last page request *not too sure how its done but I know it can be Matt ----- Original Message ----- From: "Allan Cliff" <[EMAIL PROTECTED]> To: "CF - List" <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 11: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]
