Yes I am using CF8. On Wed, Jun 25, 2008 at 6:26 PM, Dan Vega <[EMAIL PROTECTED]> wrote:
> Are you using CF8 because they made many improvements to this very problem > in 8. > > Dan > > > On Wed, Jun 25, 2008 at 9:17 PM, Sam Roach <[EMAIL PROTECTED]> > wrote: > > > 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:308169 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4