The cfquery tag cachedWithin attribute tells ColdFusion to save the results of a database query for a specific period of time. This way, ColdFusion accesses the database on the first page request, and does not query the database on further requests until the specified time expires.
The cfstoredproc tag on the other hand lets ColdFusion use stored procedures in you database management system and access the stored query code on the db Since One is managed by the database and the other coldfusion remebering a database query - stored procedures themselves can encapsulate programming logic in SQL statements, and database systems are optimized to execute stored procedures efficiently. Sp's them selfs have there own Cache and this cache is an area of memory where SQL Server keeps the compiled execution plans. Once a stored procedure has been executed, the execution remains in memory, so the subsequent users; each with a different execution context (including parameters and variables) can share one copy of the procedure in memory. SQL Server 2000 has one unified cache, where it stores data pages with the stored procedures and queries plans. Because SQL Server 2000 can dynamically allocate more memory when it is needed, the execution plan can stay in the cache as long as it is useful. However, if there is no enough memory for the current SQL Server work, the older plans could be deleted from the cache to free up memory. -----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 --- 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]
