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:185043
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
