If you want to reuse the results of a single query then your only option is to store it in memory. I'd say you need to ask yourself whether the results will be different from user to user, or for the entire application. That will determine how you store the query.
If it's consistent across all users then you might be able to cache the query on the server side. Alternately you could look at possibly storing it in the Application or Server scopes. I'm sure other, more experienced, developers have better suggestions. andy -----Original Message----- From: sandeep saini [mailto:[email protected]] Sent: Thursday, March 04, 2010 11:22 AM To: cf-talk Subject: How to handle large ResultSet, so that it can also be reused? Hey Guys! I am creating a Reporting website in which we may get huge(ten of thousands of records) data in query ResultSet. I may want to re-use this data as well. So what is the best and efficient way to handle(store and retrive?) such a resultset? FYI- 1. I am using Mach II framework. Can Mach II caching can help? If yes, how and how much? I also have some basic knowledge of TransferORM. 2. The database(oracle) we have is hugh and is really dirty(cant even create ERD using some tools). Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
