On Mon, 29 Oct 2001, Justin Scott wrote:
> 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.
Hmm i'm wondering why you think CFFILE would be any better. If the
corruption comes from writing the email message to the drive over and over
again, I don't see how the situation would change. Hmmmm. A different
drive would get corrupted that way? :)
Ok 3 new questions:
1 - What method does House of Fusion use? CFMAIL or CFFILE?
2 - Anyone from Macromedia have any light they can shed on this situation?
3 - Does anyone do a huge mailing list on their (a client's) server that
hasn't corrupted the disk over time?
> 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.
Thanks Justin, i'll keep this company for reference just in case this
issue can't be solved on a local level.
--------------------------------------------------------------------------
Bryant Tyson, WEB DEVELOPER
http://webtys.com
WebTY's, The Educated Choice.
> -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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.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
