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)
