I would guess it's because you're trying to stick all that data into a variable in memory. I would bring down the number of records you're putting into ecount_file at a time, and then using append on cffile.
Russ -----Original Message----- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Monday, November 22, 2004 12:56 PM To: CF-Talk Subject: Write large amount of data to text.. I have a application that writes loads of data to a text file. I use SQL to format the text as I pull the data from the DB. But my problem is that this is loading 11,000+ rows into a text file. I believe this is timing out. I was wondering if there is a better way of putting this into a file than <cfsavecontent variable="ecount_file"> <cfloop query="fetchReferrals"> <cfoutput>#record_data#</cfoutput> </cfloop> </cfsavecontent> <cffile action="WRITE" file="#g_EcountFileDirectory#\#eCountFilename#" output="#ecount_header##ecount_file##ecount_footer#" addnewline="Yes"> The query takes only around 20 seconds to process but the page is still loading after 15 minutes. So I'm guessing it's timed out already. If I put endrow="5000" in the <cfloop tag it completes in a few minutes. Any ideas? -- Auxilium meum a Domino ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185046 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
