I'm not sure about the dynamic variables issue. However, CF can store 100 cached queries (first in, first out), and to "refresh" a cached query set the timespan to 0.
--- Billy Cravens -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Schreck, Tom Sent: Wednesday, March 20, 2002 1:01 PM To: [EMAIL PROTECTED] Subject: caching question I'm using CF5 and have implemented a caching scheme for certain queries. How does the caching work in terms of passing dynamic values to a query resulting in different recordset? Does each recordset get cached? If so, are there performance issues? What's the max amount of cached queries in memory? Is there a certain way to clear out the cache of a particular recordset without wiping all the cache? Thanks - Tom Schreck [EMAIL PROTECTED] 817-252-4900 I have not failed. I've found 10,000 ways that won't work. - Thomas Edison ------------------------------------------------------------------------ - This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
