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
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
Sam Roach 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
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
This empty loop as posted here will cause the same memory spikes. You can
create just a simple .cfm page and run this and watch the memory go out of
control.
Maybe it is a Coldfusion bug?
cfset outsideloop = 2000
cfloop from=1 to=#outsideloop# index=x
/cfloop
thanks,
-- Sam
On Thu, Jun
Well I'm not sure it is a bug, you're talking about 20 MILLION loop
iterations. If nothing else you're going to get 20 million carriage returns
in the output buffer. You could try wrapping it in cfsetting
enablecfoutputonly=true and, assuming you aren't in a cfoutput block, see
if that makes any
By the way, this runs in about 5 seconds and uses no memory on my machine.
cfsilent
cfset outsideloop = 2000
cfloop from=1 to=#outsideloop# index=x
/cfloop
/cfsilent
On Thu, Jun 26, 2008 at 1:02 PM, Brian Kotek [EMAIL PROTECTED] wrote:
Well I'm not sure it is a bug, you're talking about 20
Thanks, the cfsilent did the trick..
-- Sam
On Thu, Jun 26, 2008 at 10:04 AM, Brian Kotek [EMAIL PROTECTED] wrote:
By the way, this runs in about 5 seconds and uses no memory on my machine.
cfsilent
cfset outsideloop = 2000
cfloop from=1 to=#outsideloop# index=x
/cfloop
/cfsilent
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
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
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
11 matches
Mail list logo