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:308170 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
