Yes u can but then your ineffect just cach'ing a cached query - ( stored Proc )
And is in effect having the result set both in coldfusion mem and your DB server Mem - A bit of overkill tbh and possibly a unnessisary load if both the app server and dbserver are on the same machine - -----Original Message----- From: Justin [mailto:[EMAIL PROTECTED] Sent: 01 December 2003 12:18 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Stored Procedures Not directly, because cf can't tell what the resulting query string looks like after the proc executes. Of course you can use your own logic to cache it <cfset CacheID = 0001> <!--- A unique name of the query ----> <cfif (useCache) > <cfif IsInCache(CacheID ) > return the query from the cache <cfelse> <cfstoredproc .... <cfset ArrayPrepand(Application.Cache,query) = /> </cfif> </cfif> or you can do a QoQ and cache that. SELECT * FROM MYquery Justin -----Original Message----- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: 01 December 2003 11:36 To: CF - List Subject: [ cf-dev ] Stored Procedures Can you Cache a Stored Procedure? If so, how? The same as CFQUERY with CACHEDWITHIN 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.545 / Virus Database: 339 - Release Date: 27/11/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.545 / Virus Database: 339 - Release Date: 27/11/2003 -- ** 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]
