Re: Mondo amounts of Mail [long]
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 25257
interpreted = N
texte = At 9:11 AM 12/8/99, Michael O Shea wrote:>> Well written Aran! Listen are the e-mail addresses in a .db? If so>> why not write some webcat code to send the mail in batches of say>> 100? That way you will not kill your server.I crashed my server trying to send e-mail to ~5,000 users. Since then myusers database has grown to 10,000.I have a few extra fields in my database for random purposes.I have one template which sets one of these extra fields to NO on all therecords.Then I search the database neFIELD1data=YES&max=300 in founditems, I write my email message to a file in the sims submittedfolder and set FIELD1 to YES.This first time I ran it I then hit that template every 5 minutes. (Seemsthat the SIMS activity as measured by the twinkling lights on my routerquieted down after about 3 minutes)The next time I try this I will set a trigger after each pass and set thetrigger to re-run the template again in five minutes until the [numfound]=0then I'll send my self an e-mail to tell me it's all done.Thanks to Mike_Davis who suggested the concept.___Joe____________________________________________________Joseph D'Andrea JoeDan@West21.comWEST21.com Internet services for the 21st Century http://www.west21.com/_________________________________________________-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
At 9:11 AM 12/8/99, Michael O Shea wrote:>> Well written Aran! Listen are the e-mail addresses in a .db? If so>> why not write some webcat code to send the mail in batches of say>> 100? That way you will not kill your server.I crashed my server trying to send e-mail to ~5,000 users. Since then myusers database has grown to 10,000.I have a few extra fields in my database for random purposes.I have one template which sets one of these extra fields to NO on all therecords.Then I search the database neFIELD1data=YES&max=300 in founditems, I write my email message to a file in the sims submittedfolder and set FIELD1 to YES.This first time I ran it I then hit that template every 5 minutes. (Seemsthat the SIMS activity as measured by the twinkling lights on my routerquieted down after about 3 minutes)The next time I try this I will set a trigger after each pass and set thetrigger to re-run the template again in five minutes until the [numfound]=0then I'll send my self an e-mail to tell me it's all done.Thanks to Mike_Davis who suggested the concept.___Joe____________________________________________________Joseph D'Andrea JoeDan@West21.comWEST21.com Internet services for the 21st Century http://www.west21.com/_________________________________________________-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Joseph D'Andrea
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
NT or Mac (1998)
Inconsistent Code (2006)
Setting up WebCatalog with Retail Pro data (1996)
Trouble with my database (1998)
possible, WebCat2.0 and checkboxes-restated (1997)
founditems (2000)
Country & Ship-to address & other fields ? (1997)
Sendmail reply-to header? (2001)
[WebDNA] Stores (2013)
Date comparison using showif (2003)
More on the email templates (1997)
[WebDNA] An unknown error occured // Deadlock avoided (2011)
Limitations on fields? Server is crashing (1997)
problems with 2 tags (1997)
shrink-wrapped version out yet? (1997)
variables in or out of includes (2001)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
[setcookie] & [redirect] (1998)
[offtopic]P1: How to make webcatalog more stable. - LONG (1999)
WebCat2b15MacPlugin - showing [math] (1997)