Well, as others have noted.... Caching a query is the daddy but if you want to ensure that code and pages are as up to date as humanly possible and also gain a speed advantage then go for SP's... We have been getting somewhere like 200% speed increase on some queries using SP's over the mutlitude of CFQUERY calls.
If you can use them, go for it....they are easier to manage and will give speed increases....they can be a bitch to debug though and I know from experience that CFSTOREDPROC has some issues with multiple resultsets coming back from CF so, as someone mentioned using exec may be a better path. -----Original Message----- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 10:33 To: CF - List 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]
