RE: Caching a Query: How To?

2001-01-13 Thread Philip Arnold - ASP
I was under the impression that cachedafter was just what it says. Cache the query *after* a date for all eternity. Why would you "cache until" a date when cachedwithin already does that? ;) Sort of - It's useful if you know that you've got a cached query that will never change, such as a

Caching a Query: How To?

2001-01-12 Thread James Taavon
I have three different queries on page that the only difference among them is what the results are ordered by. I suppose that I can cache the query the so when the user selects how they want the list sorted, the process time will be decreased. My question is I need help because I have never done

RE: Caching a Query: How To?

2001-01-12 Thread Christopher Olive, CIO
] http://www.crescotech.com -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 11:00 AM To: CF-Talk Subject: Caching a Query: How To? I have three different queries on page that the only difference among them is what the results are ordered

RE: Caching a Query: How To?

2001-01-12 Thread Philip Arnold - ASP
I have three different queries on page that the only difference among them is what the results are ordered by. I suppose that I can cache the query the so when the user selects how they want the list sorted, the process time will be decreased. My question is I need help because I have never

RE: Caching a Query: How To?

2001-01-12 Thread Robert Segal
Use the cachedwithin (relative time) or cachedafter (absolute time) attributes of the cfquery tag. -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 11:00 AM To: CF-Talk Subject: Caching a Query: How To? I have three different queries

RE: Caching a Query: How To?

2001-01-12 Thread Peter Theobald
Shouldn't CachedAfter really be called CachedBefore? You are telling it to cache the query UNTIL a specified date/time, right? At 05:27 PM 1/12/01 +, Philip Arnold - ASP wrote: I have three different queries on page that the only difference among them is what the results are ordered by. I

RE: Caching a Query: How To?

2001-01-12 Thread Dick Applebaum
The CachedAfter parameter actually caches the query any time *After* the date/time given. The query remains in the cache *until* the query is reissued with a later date /time. (Assuming the query is not purged because of it being LRU and cache space is needed) This is very useful to cause

Re: Caching a Query: How To?

2001-01-12 Thread t nelson
luck, nelson Original Message Follows From: James Taavon [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Caching a Query: How To? Date: Fri, 12 Jan 2001 11:00:07 -0500 Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id MHotMailBC287BC70067

RE: Caching a Query: How To?

2001-01-12 Thread Dave Watts
Shouldn't CachedAfter really be called CachedBefore? "CACHEDUNTIL" would be more accurate than either. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with

Re: Caching a Query: How To?

2001-01-12 Thread CF
To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 12, 2001 5:21 PM Subject: RE: Caching a Query: How To? Shouldn't CachedAfter really be called CachedBefore? You are telling it to cache the query UNTIL a specified date/time, right? At 05:27 PM 1/12/01 +, Philip Arnold - ASP w