Allan, Stored procedures don't improve speed that much unless you are doing multiple queries in one page. This is then a better example for using stored procs because of the lack of client server handshaking needed after each query.
Cached queries however are much faster but beware that you don't get confused about updates not appearing straight away. The way around this is run the query straight after updating with a timespan of less than 0 for example CreateTimeSpan(0,0,0,-1) Sorry if I have repeated what everyone else has said but my computer has been out of action for most of the day due to my antivirus picking up a bug and eliminating it rather radically. -----Original Message----- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 10:33 To: CF - List 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]
