This is the code I use. I've found (and I don't know why) it works best when
I send batches of 8,000 at a time. 8,000 will spool to the mail server in
less than 3 minutes.
--Dylan
---------------------------------------------------------------
<CFQUERY NAME="[query]" DATASOURCE="[DSN]">
SELECT
email_address
FROM
[table]
</CFQUERY>
<!--- Starting time stamp ---->
<CFOUTPUT>
#TimeFormat(Now(), 'hh:mm:ss')#
</CFOUTPUT>
<BR>
<CFLOOP QUERY="get_email" STARTROW="1" ENDROW="8000">
<CFMAIL
FROM="[from]"
TO="#email_address#"
SUBJECT="[subject]">
Mail Body
</CFMAIL>
</CFLOOP>
<BR><BR>
<!--- Ending time stamp --->
<CFOUTPUT>
#TimeFormat(Now(), 'hh:mm:ss')#
</CFOUTPUT>
---------------------------------------------------------------
-----Original Message-----
From: tom muck [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 6:47 AM
To: CF-Talk
Subject: Re: CFMAIL practical limits
Have you found a setting that allows you to spool more than 100 messages
every 15 seconds? With those limits set by the CF Administrator we've only
been able to dump 24,000 messages per hour to our mail server.
tom
"Dylan Bromby" <[EMAIL PROTECTED]> wrote in message
000301c0ff30$3c59b900$6401a8c0@bromby">news:000301c0ff30$3c59b900$6401a8c0@bromby...
> I use CFMAIL to send 50,000 emails a pop and it takes less than 30 minutes
> to send them all to the mail server (IMail 6.0.x).
>
> --Dylan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
