>I have this:
> <cfset emailtowrite = "">
> <cfloop query="list">
> <cfset emailtowrite = list.email & chr(13) & chr(10)>
> <cffile action="append" file="#ExpandPath("users.lst")#"
>output="#emailtowrite#">
> </cfloop>
>It still takes forever. Is there a faster method?
Chris, any time you use cffile you're doing a read/write from the disk,
which is always going to be more process intensive. Somebody may chime in
with a "silver bullet" for your problem, but 22,000 of anything is *huge*
and you may want to run this as a scheduled job at night. How long is
"forever"?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
