Timespans are stored as number of days where the fractional part is the fraction of a day, e.g. 10.25 is 10 days 6 hours. So the original 20 in the cachedwithin setting meant 20 days.
A cached copy of a query will only be used if the current query is exactly the same as the cached copy in all respects, i.e. sql, db, username, password. If anything has changed (e.g. different search parameter so sql is different) then the query will be run and it will replace the cached copy. In other words, cached queries are only useful if the sql seldom changes. ----- Original Message ----- From: "Glenn Shukster" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 11:21 AM Subject: [CFTALKTor] CF cachedwithin question > Hi > In an application that I just took over there was a line of code in a > cfquery that said cachedwithin="20". I changed that to = > createtimespan(0,0,20,0). What would the 20 on its own be. Is that > minites, hours, days? > > I read a book on this area and it said: > "Cached queries are tied to all users accessing the same query. If any > one user modifies the query or its attributes, then the query is purged > from the cache." > > This doesn't make sense to me for I took away this line of code and that > page was taking over 12 sec to load on average. > Once I put that line back in it was down to under 7. > If every user shares the query and the query is not used unless someone > elses every user comes in with a different query then why would there be > such a dramatic difference? > -- > Cheers > Glenn Shukster (Logic Fundamentals Inc.) Thornhill, Ont. Canada > Phone:(905)771-6458 Fax:(905)771-6819 www.logicfundamentals.com > President of TDUG www.tdug.com > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: Glenn Shukster <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Bob Keleher" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
