I don't know if it is possible with what you are doing, but you can do QUERY="..." with the CFMAIL tag instead of looping over and calling the tag over and over. I believe this is faster.
We have a need to send out a great many e-mails as well (about 3 times as many), and we are setting up a sort of round robin type process where mail will be sent out it chunks - perhaps you could look at that kind of process if the straight up mailing times out / fails. Cheers, Rob -----Original Message----- From: Jason Miller [mailto:millerj@;etcnj.com] Sent: Monday, October 21, 2002 1:11 PM To: CF-Talk 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.
