I send out about 6k at a time. My work around, as I'm on windows and the mail server isn't as fast as I'd like, is to spool all the messages to disk, then have a scheduled task run once an hour to make sure the spool is cleared.
My bulk emails are all triggered by the scheduler. Perhaps you could give the user the option, or give no choice, and have the mail run set to run from the scheduler instead of expecting it to run there and then. Even if it was just 5 mins it would save them staring at a screen waiting for something to happen. jenny -----Original Message----- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: 03 September 2006 16:18 To: CF-Talk Subject: mass emailing from CF I've recently been handed a huge mess of a project to clean up. Apparently there have been major issues with a newsletter tool timing out due to the increased number of registrants. I'm just curious how most people are handling sending out massive amounts of in short periods of time. Right now it is basically... 1) Set the timeout to a ridiculously high number 2) Select all the 3) Loop over all users and cfmail the newsletter 4) when people complain about timeouts, increase ridiculously high timeout number I'm sure this worked fine when there were 100-200 people in the database but that number is now very near 10,000. I'm probably not thinking hard enough just yet but there has GOT to be a better/easier way. I'd appreciate any comments or suggestions. ..... This does need to be fully automated and I can't expect the user to open a meta refreshed page and let it run. (that would be too easy lol) Thanks ...:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.11.7/436 - Release Date: 9/1/2006 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251909 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
