You're right - from one of the Allaire guys that CF caches queries by name
and the full SQL query string.
So for sure use the same names.
One interesting point is - you should trim all dynamic parameters and field
names since a space difference will result in CF thinking the SQL is
different.
HTH,
Noam
----------
From: Fred T. Sanders [SMTP:[EMAIL PROTECTED]]
Sent: Friday, 28 July 2000 15:29
To: [EMAIL PROTECTED]
Subject: Re: CF Caching (was New Job..)
CF does dynamic caching, as I understand it what would happen if you
say
cached it to the application. scope is this, the query would remain
in
memory until one of the variables changed then would rerun from
memory and
retrieve the new results, only when a query was run that was exactly
the
same would it just use the previous results. I could be wrong as I
haven't
really studied it all that hard, but I believe the above to be a
relatively
accurate sumation.
----- Original Message -----
From: "paul smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 28, 2000 9:02 AM
Subject: CF Caching (was New Job..)
> So how does CF Query caching work in a Yellow Pages application?
>
> Consider the drill-down "List Headings by Alphabet".
>
> Only the WHERE changes in the Query, for example,
> WHERE Heading_Name LIKE 'A%'
> WHERE Heading_Name LIKE 'B%'
> etc.
>
> Will CF cache all 26 Queries if they all have the same name?
>
> Or would I have to name each queries different to get CF to cache
all 26?
>
> best, paul
>
> At 02:49 AM 7/28/00 -0700, you wrote:
> >I has a similar situation: periodic, dynamic generation of static
> >pages, for 9 similar sites (from an Access database). Most of
these
> >were drill-down search results.
> >
> >Anyway the 1,000 original pages were replaced by 30+ templates,
they
> >dynamically generate/populate pages from an SQL Server 7.0 db.
> >(didn't use fusebox, tho)
> >
> >I use CF qyery caching & under most situations the dynamic pages
> >outperformed he static pages.
>
>
--------------------------------------------------------------------------
----
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with
'unsubscribe' in
the body.
>
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
