Thanks for all the info, Mary Jo! It's been ( and will be ) a big help!
Rick > -----Original Message----- > From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] > Sent: Friday, April 25, 2008 2:24 PM > To: CF-Talk > Subject: Re: Need some advice on speeding up query... > > Oops, sorry about that partial post.... > > To reiterate, don't stick the entire query in there, it should be out in a > CFC, or at the very least, in > a separate template so if you make any changes, you aren't updating it in > multiple files. You would just > use a variable for the cachedwithin time sort of like this: > > <cfparam name="Request.CacheTime" default="#CreateTimeSpan(0, 1, 0, 0)#"> > > <cfquery name="ReallyBigQuery" datasource="MyDS" > cachedwithin="#Request.CacheTime#"> > SQL Here > </cfquery> > > > And then in your cfthread you would just have something like this, which > calls the above code (you > wouldn't necessarily need a request variable, depending on your application): > > <cfthread action="run" name="refresh_cached_query"> > <cfset Request.CacheTime = 0> > <cfinclude template = "path_to_query_page.cfm"> > </cfthread> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
