Thanks - beleive it or not though this client is still on access 2000 database - with 40,000 unique hits a week. Hope to update to SQL within a few months - just need to get some of these emails out -
Great idea on the BCC - I am not overly concerned with reliability becuase it is some initial mass mailings- once we cut through all the garabage mails - it would be nice that people expecting and depending on mail get it timely. Will look at 3rd party= but hesitant to go any perl (because I don't have much experience toying with perl) route which it seems most of there are in. thanks for the advice. jay miller Carlisle, Eric wrote: 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 <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 <http://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 <http://www.coolfusion.com/imssecomparison.cfm> ----- Original Message ----- From: "Jason Miller" <mailto:millerj@;etcnj.com> <[EMAIL PROTECTED]> To: "CF-Talk" <mailto:cf-talk@;houseoffusion.com> <[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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
