Ok, this is a weird one. I'm hoping it's a bug or someone can explain the reasoning behind it. We have a CF7 Enterprise installation on a UNIX box and we just sent out an email to all of the users of our site. The email had an 3 attachments (totaling about 150k) and went out to about 4,000 members. We fired the email off and the noticed we were getting the mail multiple times. We deleted all of the .cfmail files from the spool directory and went back to look at our mailsent logs and found some strange patterns. First of all, the spooler seemed to loop through all of the cfmail files to send the emails and had gotten through about 5 iterations and didn't seem to be deleting any of the .cfmail files. After further examination, it seemed like each time the spooler came in and started sending mail it deleted the first .cfmail file after it started it's loop. Therefore, the first guy on the list, got the email only once, the second guy got it twice, the third guy three time and so on. So, to my questions: 1. How does the spooler/cleanup work? Is it the same process that sends the mail and then deletes the file or is there a separate cleanup process to remove old mail? 2. The developer who wrote the script to do this grabbed a query of email address and did a <cfoutput query="..."> around a single <cfmail> tag. I know it's been talked about before on the list how <cfmail> with the QUERY attribute performs faster. Is this the sort of problem that can be solved? 3. Because of the <cfmail> nested in the <cfoutput query="..."> I'm guessing the server has to create a separate temp file for the attachments each time, then delete them. Does it just do it once if you use <cfmail query="..."> instead? Any insite or suggestions or places to look would be EXTREMELY helpful. Thanks a ton! John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225266 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
