Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
Loopy Loop & Fast SOLVED
Author: Chris Edwards
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:22829#115071
Thanks for all the help.
Takes ~ 14 seconds. Down from the original ~180
<!--- get email list --->
<cfquery name="list" datasource="#Request.App.Db#">
SELECT DISTINCT CONCAT(email,'\r\n') AS email
FROM `mail_subscriptions`
#optlist#
</cfquery>
<cffile action="write" file="#ExpandPath("users.lst")#"
output="#valuelist(list.email,"")#">
Once again, the DB shines through as the savior. Thanks Doug for reminding
me.
--
Chris Edwards
Web Application Developer
Outer Banks Internet, Inc.
252-441-6698
chris.edwards@obinet.com
http://www.OuterBanksInternet.com
|
May 24, 2013
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
