even whitespace inside sql statement must be the same! so mind those
tabs/spaces in your code formatting...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Dave Watts wrote:
>> What if at the end of the process I ran the query using the same query name
>> and no caching. Would that actual
> What if at the end of the process I ran the query using the same query name
> and no caching. Would that actually get rid of the cached query?
That won't work, but you can flush a single query from the cache by
rerunning the query with only one change - set CACHEDWITHIN to
CreateTimeSpan(0, 0,
> I wonder if it also needs the same params, doesn't CF8 allow cached queries
> with cfqueryparam? Maybe change the param to something that'll return an
> empty result.
CF 8 does allow cached queries with CFQUERYPARAM. However, it requires
the bound parameter values to match before it uses the ca
uation?
Adrian
> -Original Message-
> From: Robert Harrison [mailto:rob...@austin-williams.com]
> Sent: 11 February 2009 16:23
> To: cf-talk
> Subject: RE: Query Caching Function: Clearing Cached Query
>
>
> I looked in the docs first.
>
> What if at the end of the
I looked in the docs first.
What if at the end of the process I ran the query using the same query name
and no caching. Would that actually get rid of the cached query?
Robert B. Harrison
Director of Interactive services
Austin & Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631
16:07
> To: cf-talk
> Subject: Query Caching Function: Clearing Cached Query
>
>
> I have a huge query that is used in a timed loop process completes. The
> process could take from a minute to 15 hours, and it runs the query
> each
> time is goes through a loop.
>
> If I
I have a huge query that is used in a timed loop process completes. The
process could take from a minute to 15 hours, and it runs the query each
time is goes through a loop.
If I cache the query (cached within the last 15 hours), it can save a lot of
re-querying processing... but what if the pro
7 matches
Mail list logo