This sounds like a good solution. Do you just call the same page over and over with the cfhttp at the bottom passing a record variable until you reach the end of file or you doing something different?
-----Original Message----- From: Mark Mandel [mailto:mark.man...@gmail.com] Sent: Wednesday, March 09, 2011 9:03 PM To: cf-talk Subject: Re: Performance Issue with CFLOOP Batch stuff like this, I tend to break into chunks, and call each chunk via a cfhttp call. (maybe 1000 records or so per chunk?) That way you get a single request, that can be entirely gc'd after each request. Worked well for me in the past. Mark On Thu, Mar 10, 2011 at 10:26 AM, Michael Grant <mgr...@modus.bz> wrote: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342877 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm