Naming does matter..depend on weather you are using implicit or explicit caching...
--- Patrick Trongo <[EMAIL PROTECTED]> wrote:
> Different names Paul
> --- paul smith <[EMAIL PROTECTED]> wrote:
> > 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.
>
>
> =====
> Patrick Trongo
> Sr Programmer/Analyst
> 4Anything Network (www.4anything.com)
> 487 Devon Park Road Suite 204
> Wayne, PA 19087
> Telephone: 610-768-1444 Ext 204
> Fax: 610-592-1094
>
> __________________________________________________
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
> http://invites.yahoo.com/
> ------------------------------------------------------------------------------
> 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.
=====
Patrick Trongo
Sr Programmer/Analyst
4Anything Network (www.4anything.com)
487 Devon Park Road Suite 204
Wayne, PA 19087
Telephone: 610-768-1444 Ext 204
Fax: 610-592-1094
__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
------------------------------------------------------------------------------
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.
