You'd probably be better off storing the recordset in the current user's session, since they will undoubtedly user-specific. Then you can just do QofQs to get the partial display sets. Caching the query in the server's query cache could interfere with other cached queries, and might require a single user to hit the DB more than once if his recordset is bumped from the pool before he's done looking through it.
Of course, if you manually cache in the session, you'll have to make sure that you clear that data when you're done, or you'll just eat up all your memory. Another option, if the total result (all possibel records) isn't overly large, and doesn't change frequently, woudl be to cache the whole thing in memory, and then run QofQs on that recordset for user searches. That'll skip the database interaction as well. barneyb > -----Original Message----- > From: Clint [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 19, 2003 10:45 AM > To: CF-Talk > Subject: Re: Large Recordset Display Problem > > > Try caching the query. That will keep it from hitting the database again. > > Clint > > ----- Original Message ----- > From: "admin" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, March 19, 2003 12:35 PM > Subject: Large Recordset Display Problem > > > > I have a query that returns the results of a search. Potentially this > could be a few hundred records. What I want to be able to do is > execute the > query once (as it's a slow query) but then only display a limited > number of > records per page (25 or so) and have some navigation to move thru the > results, but with out re-doing the search. > > > > Any thoughts ? > > > > TIA > > > > Richard > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
