Hate to say it... Fix the database. Fixing the database almost always shows a better speed increase and processing than refactoring CF code. That is if the database is a mess in the first place.
I've just started reading Joe Celko's SQL for Smarties, and in the first chapter I've found stuff I've been doing wrong for years. A few db changes and a different mindset and things are starting to go faster for me. Steve -----Original Message----- From: sandeep saini [mailto:[email protected]] Sent: Thursday, March 04, 2010 12:55 PM To: cf-talk Subject: Re: How to handle large ResultSet, so that it can also be reused? Thanks Randy. But yes, the resulted data will be different for all users, So cf catchedin will not be useful. -sandeep ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:331353 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
