Thanks Dan. By batch do you mean just set up a cfschedules to send X number at a time?
Here's the thought I had for cfschedules. 1) Give everyone a 'sent flag' in the database and initialize it to 0 (not sent) 2) Write a page that sends the newsletter to top X number of users whose 'sent flag' is 0. As they are sent, their 'sent flag' is set to 1 3) When the form to send out the emails is submitted - reset everyone's 'sent flag' to 0 - do a little math to find out how many batches to create - create that many cfschedules to hit the page from step 2 and separate them by say a minute or 2 If my messed up gorilla way of thinking is correct, that would make the processing of the 'send newsletter' tool much less strenuous and therefore much less likely to timeout. Do you (or anyone else) see anything wrong with that logic? Is that more or less what you meant by 'set up batches'? Thanks ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: D F [mailto:[EMAIL PROTECTED] Sent: Sunday, September 03, 2006 11:59 AM To: CF-Talk Subject: Re: mass emailing from CF Hi Bobby: We current send out around over 40-50k using CF and it runs like a champ. However we are using CF on Linux ( which since we switched from Windows based CF mailer runs much much much better ). I would say you need to set up batches of 1000 or similar number and make sure not to run the batches on top of each other as far as timing goes. It you need any more advice be glad to help. Dan >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:251898 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
