Do you have an need to worry about current data? Because if you hold that
large data set too long how long is it before it becomes outdated and
invalid? or does it stay static?
I could see that as a great thing if it was static all the time but I dont
see you are being able to use that all the time for any longer then you can
safely say this data has not been changed yet.
Bill Wheatley
Director of Development
AEPS INC
Allaire ColdFusion Consulting Partner
Allaire Certified ColdFusion Developer
http://www.aeps.com
ICQ: 417645
http://www.aeps2000.com
954-472-6684 X303
IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee. It is confidential and may contain legally privileged
information. No confidentiality or privilege is waived or lost by any
mistaken transmission to you. If you receive this e-mail in error, please
immediately delete it from your system and notify the sender. You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient. The RTA is not responsible for any unauthorized alterations to
this e-mail or attachment to it
----- Original Message -----
From: "Daniel Kemp" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 10:46 AM
Subject: RE: The BETA IS OUT!!! (query a query)
> > I'm not questioning whether it's a nice feature or not. I'm just
> > looking for a nice application to put it to good use.
>
> Ok, here's how I'm kinda planning on putting it to use, and I'm happy to
> burn the ram on it.
>
> I have 16 zillion records or so, maybe a few less, and I need to grab
> subsets of data from them all over the place. "Get me these records which
> match such-and-such, a few more which are like something else, and a
couple
> more records where something really odd matches."
>
> So I'm looking at 3 queries here, but wait I'll stick 'em in a loop too,
> just to really snafu things up. Worse, the criteria I use to search by
> changes all the time, guess that's caching out the window.
>
> But now, with super new CF5 I run one query which selects all the fields
I'm
> ever going to need for *all the records* and, get this, *cache that
query*,
> now I run all my other queries against that large query. Note that I now
> only hit the database *once* for the first big assed query, a big hit
sure,
> but now it's cached.
>
> So next time I call the page, I don't hit the database at all, my smaller
> queries with their every changing criteria, are querying a cached query.
>
> Very much like being able to query a structure (which I suspect is what's
> going on here anyway).
>
> It's certainly going to speed up a number of projects I'm working on.
>
> R'grds,
> Dan.
>
>
>
> This message is intended only for the use of the person(s) ("the intended
recipient(s)") to whom it is addressed.
>
> It may contain information which is privileged and confidential within the
meaning of the applicable law.
> If you are not the intended recipient, please contact the sender as soon
as possible.
> The views expressed in this communication may not necessarily be the views
held by Live Information Systems Limited.
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
