BTW this specific server is CF5.0 with Oracle.
On Mon, 22 Nov 2004 11:55:53 -0600, Greg Morphis <[EMAIL PROTECTED]> wrote: > 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 > -- 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:185044 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
