Tac, Regarding point (2), what do you mean by "My solution to this was to write to a network drive that was on a different machine than IMS." Do you mean iMS resides on a different box than your CF server? Or that your bounced backs go to a different server? Just trying to learn since I'm doing email blasts of about 50k and I'm experiencing sluggishness on the server.
thanks, Jose -----Original Message----- From: Tac [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 4:16 PM To: inFusion Support List Subject: Re: [iMS] Loop list Vs query speed Mark, I used to loop over a query and mark each address as being sent, for exactly the same reasons. Using the query= attribute in the cfx_imsmail tag is much faster, but has the following drawbacks: (1) The windows OS slows down when there are 60k files (30k .mail and 30k .mbx) in a single directory. (2) If there are a lot of bounce-backs because of bad email addresses, the system can become very, very slow, and the POST processor takes 100% of the CPU. This can block the cfml loop from creating the email, since the machine it's being created on is busy with the POST process. My solution to this was to write to a network drive that was on a different machine than IMS. (3) You can't set a dynamic failto tag, and reportpoststatus only returns list of failures, not the specific reasons for a failure. This will be addressed in IMS 2.5. Currently, I use the query= method, but I'm in the process of rewriting that section of the code and am considering going back to the looping method to better handle bounce-backs, at least until 2.5 comes out. Please post back to the list if you find anything interesting, as my list mail is about the same size, and I'm curious if looping over a query works ok for you. Tac ----- Original Message ----- From: "Howie Hamlin" <[EMAIL PROTECTED]> To: "inFusion Support List" <[EMAIL PROTECTED]> Sent: Thursday, June 20, 2002 3:58 PM Subject: Re: [iMS] Loop list Vs query speed > I usually suggest using the CFX with a query as opposed to looping over it. Using a query is faster but i don't have > any benchmarks fot that. > > I have also heard from other users that using pure CFML is also faster than the cfx tag. I have some code that was > given to me and I could forward it to you if you want it. > > Regards, > > Howie > > ----- Original Message ----- > From: "Mark W. Breneman" <[EMAIL PROTECTED]> > To: "inFusion Support List" <[EMAIL PROTECTED]> > Sent: Thursday, June 20, 2002 3:56 PM > Subject: [iMS] Loop list Vs query speed > > > > I have about 30K e-mails address that I retrieve from a database and then > > loop over currently the cfmail tag. I have seen the light and I am > > upgrading to IMS-se mail. > > > > Would it be quicker to loop over the cfx_iMSMail (many times) Vs using the > > query="test" queryfield="email" method. I am guessing that the query method > > would be faster. If so, how much? > > > > Why I build the loop is that I mark address as sent after the message are > > sent. So if my server would crash in the middle of a send I could restart > > the mail and not worry about sending duplicate messages out. > > > > Any thoughts? > > > > > > > > Mark W. Breneman > > -Macromedia Certified ColdFusion 5 Developer > > -Network / Web Server Administrator > > Vivid Media > > [EMAIL PROTECTED] > > www.vividmedia.com > > 608.270.9770 > > ==^======================================================= This list server is Powered by iMS "The Swiss Army Knife of Mail Servers" -------------------------------------- To leave this list please complete the form at http://www.coolfusion.com/iMSSupport.cfm Need an iMS Developer license? Sign up for a free license here: http://www.coolfusion.com/iMSDevelopers.cfm List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/ Note: You are subscribed as [email protected] ==^=======================================================
