On 2/5/01, Willy Ray penned:
>Can I make an enormous cached query, and then query those results?
>Say, for example, I wanted to query all customers and all invoices
>at once, then display a list of customers with unpayed invoices,
>linked with URL variables to a detail page that would show the
>invoice details. Could I do this with one big query, cached at the
>beginning, and never hit my database again until the cache expired?
Yep. Of course if someone goes and pays their invoice after the query
is cached it won't show up until the query is refreshed.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
