Just a suggestion, but could you not just use Oracle to write the text file out? As you already format the text with SQL, this would bypass going to ColdFusion altogether and streamline the process.
Gavin -----Original Message----- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: 22 November 2004 17:56 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:185111 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
