Yeah, the DBA and I talked about this some time ago. Writing the file this way is working for now. If this happens again I may have to find out how to do this or hit him up for some help. Thank for all your suggestions.
On Tue, 23 Nov 2004 08:46:25 -0000, Gavin Brook <[EMAIL PROTECTED]> wrote: > 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:185178 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
