Good advice. There's also a stored procedure in SQL Server that's supposed to be pretty good for mass mailings (sp_sendmail or something like that).
If you DO use CFMail (I can't talk to its performance in 5 or MX -- I had issues with it in 4.5.1), BCC each cfmail to 20 or so recipients at a time (instead of sending 1 per person). That'll take some strain off the CF mail spooler (giving more of the load to the mail server) and get things out faster. ETC -----Original Message----- From: Howie Hamlin [mailto:howie@;coolfusion.com] Sent: Monday, October 21, 2002 1:18 PM To: CF-Talk Subject: Re: cfmail tag and looping output If you are concerned about reliability then I would suggest that you have a look at iMS-SE. iMS-SE is a high-performance mail sending engine that allows you to send email without requiring an external mail server. iMS Pro is the mail sending engine behind this email list, BTW. More information and a comparison sheet are available from our web site (the direct links are in my signature, below). -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm ----- Original Message ----- From: "Jason Miller" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 21, 2002 4:11 PM Subject: cfmail tag and looping output > Hello List - One of my client has about 8,000 emails that have signed up > for sales letters and newsletters on his site. > > I have been testing a simply query that pulls from 3 tables - creates an > output that loops and executes the cfmail tag each time - using a ID > that is primary so no duplicates are being sent.. It surprisingly > doesn't take that long ( although I haven't tested on the full lot) BUT > i have heard > 1) Cfmail tag not being reliable > 2) their must be a more efficient way to code this. > > So I am looking to this list to find if there is any truth to cfmail > dropping results OR if there is other tags ( please hint) that I should > really be looking into. > > Client wants me to manage this through some simple scripts - and would > like to send html formated email. We are leaning away from purchasing > 3rd party solutions and installing special server software is not possible. > > thanks! > jason > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
