On 3/4/2010 9:54 AM, sandeep saini wrote: > Thanks Randy. But yes, the resulted data will be different for all users, So > cf catchedin will not be useful. > > -sandeep >
The basic question you are asking here is where do you want to spend the cost of these large recordsets? You can spend the cost in CPU and Network time by having the data stored in the database and fetched whenever it is needed. Or you can spend the cost in memory where the record set could be stored in session scoped variables. You also maybe able to do something half and half. Such as where you grab the large data set the forms the basis of all the users sets and store it once in memory, then you would query this large set for the individual users set when those are needed. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:331354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm