Can you post the code? Because a loop tag itself woudn't be causing memory to spike. It has to be something inside the loop tag.
On Thu, Jun 26, 2008 at 2:35 AM, Sam Roach <[EMAIL PROTECTED]> wrote: > I'm using a java stringbuffer which works great for the portion of the > code, > but the main issue is with the cfloop tag. > > > On Wed, Jun 25, 2008 at 6:51 PM, Brian Kotek <[EMAIL PROTECTED]> wrote: > > > If you aren't, use a Java StringBuffer or StringBuilder to build up the > > CSV. > > If you do the concatenation using CF you'll use large amounts of memory > > because every concatenation creates a new String object. > > > > On Wed, Jun 25, 2008 at 9: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:308181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
