yeah we only use cfstoredproc calls when it's imperative to get 2 or more result sets back, which poses a problem for caching, if you go down the exec route, you can still cache, and gain benefits from both systems... :)
----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 11:19 AM Subject: RE: [ cf-dev ] Performance > 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] -- ** 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]
