We ship out about 13-20k in one big swoop in a similar method as you described...
The actual program never takes much time... It's the CFMAIL spooling that takes a long time... I can't verify that CFMAIL drops stuff... I know though that you will end up with erroneous entries in your UNDELIVERABLE mail folder under CFUSION... To fix that we run the resend undeliverable tag found in the Developer's Exchange... it works fine for us... AS far as other related problems... Time is probably the largest issue... Cause CF runs that query.. and then starts parsing emails to the CF mail directory... then the CF server at maximum once per minute tries sending a batch of them to your SMTP server, where they then sit and wait for the mail server to process them to the outside world... There is Jochem's tag which allows you to write the files directly to your mailservers pickup directory... That is an interesting thing to look at... There is also a third party mail replacement that someone on the list sells and is highly recommended... Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] -----Original Message----- From: Jason Miller <[EMAIL PROTECTED]> Date: Mon, 21 Oct 2002 13:11:09 -0700 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
