Eek! Sorry to hear about your bad luck! I can tell you that if you're sending out THAT many e-mails, you're better off...
1) Getting a separate server dedicated to handling SMTP spooling, then use CFFILE to write the messages directly to the spooler pickup directory instead of using CFMAIL. 2) Outsource your mailings to a company that specializes in this type of thing, such as Postmaster General (http://www.postmastergeneral.com/). One of our clients used them to do a weekly mailing to about a million subcribers without a hitch. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com ----- Original Message ----- From: "Bryant Tyson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 12:43 AM Subject: CFmail Recount > Thenks for the info Critter. Much appreciated. :) > > Now for a little story about what happened today. I created a newsletter > page so that a registered base of 150,000+ subscribers would get it on > what would most likely be a weekly basis. On its first run today however, > it sent out approximately 2000 emails and then... exploded. It didn't just > stop sending emails though, instead the entire server got fried! > > I called up the ISP and they say there's massive corruption throughout the > harddrive!?!?! WTF? Since the only thing that happened out of the > oridinary was the newsletter mailing today, they surmised that it was the > cause of the meltdown. Once again I ask... WTF?! Is ColdFusion unstable to > the point that sending out a newsletter would fry the server?!? One theory > is that messages got bounced back to the server and it couldn't handle the > load of outgoing and incoming. Ok fine, i'll buy that partially. Maybe it > was indeed a wussy server. But corruption? File corruption from > getting/sending emails? Hell the server wont even boot up now! > > Has anyone else had this happen to them? > > So here's a word of caution to anyone doing a newsletter from me. Try not > to fry your server in the process. *laugh* I still can't believe this > happened. > > Oh yeah, for those interrested in the code that allegedly melted down the > server, here it is: > > <cfquery datasource="zzz" name="newsletter"> > SELECT date, slug, content > FROM newsletter > WHERE newsletter_id=#form.tid# > </cfquery> > > <cfquery datasource="zzz" name="receivers"> > SELECT email_address > FROM members > WHERE newsletter_flag=-1 > </cfquery> > > <cfmail TO="#receivers.email_address#" > FROM="[EMAIL PROTECTED]" > BCC="[EMAIL PROTECTED]" > QUERY="receivers" > SUBJECT="#newsletter.slug#"> > ZZZ Newsletter > #DateFormat(newsletter.date, "DDDD, MMMM D YYYY")# > #receivers.email_address# > ================================================================= > > #newsletter.content# > > ================================================================= > UNSUBSCRIBE > Here's how to unsubscribe or change your settings. > http://www.zzz.com/updateprofile.asp > </cfmail> > > .. and yes, that's how I know 2000 emails got sent out, because I got > 2000+ blind CC's. Left it in there from the testing phase. Ugh. > > -------------------------------------------------------------------------- > Bryant Tyson, WEB DEVELOPER > http://webtys.com > WebTY's, The Educated Choice. > > On Sun, 28 Oct 2001, Critz wrote: > > > oi Bryant!! > > > > > > CHR(13)& CHR(10) is carriage return, line feed > > > > -- > > Best regards, > > > > Critter [critz.org] > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
