Can simply increasing the size of the JVM max heap fix this? Problem is when this loop slows down all of the CFM pages seems to slow down and timeouts start to occur.
-----Original Message----- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Wednesday, March 09, 2011 4:14 PM To: cf-talk Subject: Re: Performance Issue with CFLOOP Yes, it will slow down with a query of that size. This is totally natural and completely expected behavior, because you are loading up the JVM. The closer you get to reaching its max threshold, the slower things will become. Is there any reason why you are not doing this in smaller segments? Also, what about doing it on the db server instead of CF? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:342857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm