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.