We are trying to create a CSV file with about 250,000 rows with about 40 dynamic columns which we need to loop over so we can get the correct order.
We see an issue coming from the nested loops on the large dataset and the server is running out of memory. We took a step back on even doing a simple loop over over a large set of rows seems to have the same issues. Anyone have any ideas how to deal with this? If you run this code on watch the memory on the CF Server it will just keep climbing until garbage collection runs. <cfset outsideloop = 20000000> <cfloop from="1" to="#outsideloop#" index="x"> </cfloop> thanks, -- Sam ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
