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.
