we do this as well.. We have mail-outs of 100,000+, and we break them down to 5000 chunks. The Scheduled task just keeps sending emails until something like: CurrentRow = Total Row.. On each mailout, we record the "CurrentRow" in a Table, and when the task runs again it just starts from the "currentrow" value.
Here's another Question... 1) How much cfmail files can ColdFusion process into the SPOOL before being hung out to dry? 2) What are the filesystem limits (Win2k/Linux, etc)? 3) Is the Windows SMTP Server really a good option to send the CFMail to? thoughts? kev. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: January 22, 2002 8:17 AM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] mailing list manager mailing list managerI have written such. With volumes over 10,000 per run, I have found that memory and CPU is a problem, sometimes forcing the jobs to be broken into smaller (5000) lots. Having your own dedicated server may eliminate this problem. (My largest application had 17,000 total send runs) Other than the timeout problem, (which may be tuned I think with your own server -instead of ISP provided), it works well. I have not included bounce handle, but did include unsubscribe. The application also included a basic input form with options for image(s) upload, and basic font and colour choices. It also has to ability to review and resubmit (or copy) previously posted issues as well as a search capability for specific db criteria. My application is not commercial grade since it was written for a specific requirements and database contact list, but I would be happy to answer any questions. -alan ----- Original Message ----- From: Cordiner, James To: [EMAIL PROTECTED] Sent: Monday, January 21, 2002 2:19 PM Subject: [CFTALKTor] mailing list manager Hi, Does anyone have any experiences they could share with a CF based mailing list manager? We are looking for an announcement only style list (ie. not a discussion list) where users will opt-in via the site. We are not sure of the size but it will be in the order of 10,000 subscribers or more. Some desired features might be to have multiple lists from the same user database, an HTML/text only preference, bounce handling and some kind of import/export features. The code would have to be open so that we could add features or modify if needed. We are considering other non CF products and a build-our-own solution and would be happy to hear any experiences that others might have had with those scenarios as well. All input welcome, thanks! jms. James Cordiner New Media Developer/Programmer Art Gallery of Ontario 317 Dundas Street West Toronto, Canada M5T 1G4 http://www.ago.net tel: 416-979-6660 ext.266 fax: 416-204-2709 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Kevin Towes" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
