How about using a scheduled task to run a series of mail sends
of 250 each, the as part of the task, schedules another task
5-10 minutes later to send another task. Repeat as needed.
Here's what part of a scheduled task would look like that I used
to process a Real Estate data download every morning:
<cfthread action="run" name="schedule_01i_hilly_peterson_concierge_processing">
<!--- [ set up the delay routine ] --->
<cfset cfthread.sleepTime = 0>
<cfset cfthread.initialized = false>
<!--- [ the cfloop continues to loop until the status of the previous
cfthred, in that case named "email_results" is "completed"
or "terminated" (due to a failure) ] --->
<cfloop condition="cfthread.email_results.status neq 'completed' and
cfthread.email_results.status neq 'terminated'">
<cfset sleep(10000) />
<cfset cfthread.sleeptime++ />
</cfloop>
<cfschedule action = "update"
task = "vds_01i_hilly_peterson_concierge_processing"
operation = "HTTPRequest"
url =
"http://localhost/scheduledTasks/vds/01i_hilly_peterson_concierge_processing_vds";
startdate = "#DateFormat(Now(), 'm/d/yyyy')#"
starttime = "#TimeFormat(DateAdd('n', 2, now()), 'h:mm
tt')#"
interval = "once" >
<!--- [ the following cfmail is just to notify me that the task has run
and has set up the next task ] --->
<cfmail to = "r...@whitestonemedia.com"
from =
"conciergepropertyprocess...@whitestonemedia.com"
subject = "vds_01i_hilly_peterson_concierge_processing
has been scheduled.">
Schedule Task,
"whitestone_01i_hilly_peterson_concierge_processing,
will run in 2 minutes.
</cfmail>
</cfthread>
Rick
-----Original Message-----
From: Rick Sanders [mailto:r...@webenergy.ca]
Sent: Monday, August 19, 2013 10:55 AM
To: cf-talk
Subject: Pausing a loop or query
Here's the situation. A client of mine has an email list he sends a flyer to
once a month to about 5000
addresses. I need to pause after sending 250 so the server doesn't get flagged
for spamming. What's the best
way to do this?
It's easy to do multiple queries of 250 rows each, but how can I pause for say
5 or 10mins in between?
Kind Regards,
Rick Sanders
T: 902-401-7689
W: www.webenergy.ca<http://www.webenergy.ca/>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356499
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
