> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
