Re: [WebDNA] Mass email using WebDNA
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 100836
interpreted = N
texte = I have a messaging system. It tracks when people open emails, but I did not finish developing the bounce back feature. I'm not necessarily offering my system to you, just some input. To track bounce backs you need to send from a POP3 address and have the messaging system POP that account and analyze the emails received. Here's my issue on why I haven't completed this. I currently have my WebDNA server set to deliver 10 emails a minute, which is 600 emails an hour. But that takes FOREVER to send out large lists. Has anyone here ever set the number of emails per minute to greater than 10? I've never tempted fate since the docs say something like "do do that unless your email server can handle it". Is that a warning from 10+ years ago when we had Intel 486 chips? As for the [spawn] I recently learned that [spawn] has a processing limitation. I created a script to parse through imported database records and import them into another database. The script dies whenever it processes more than 900 records. It took forever for me to figure out that the [spawn] routine was dying. I tried to figure out why by creating internal debug routines for the [spawn] but I was not able to figure out the exact cause. I assume it's a memory overflow or limitation of variables. Therefore, depending on the number of emails sent I would recommend creating an appropriate number of [spawn]s to complete this task. I can also tell you from personal experience that none of the EMailFolders like more than 2000 files at a time. The server or sandbox chokes to death! In my early attempts with this I tried process too many [sendmails] at a time and the server got caught in an endless loop of sending a single email over and over until I rebooted. I wrote a trigger that reorganizes the EMailFolders every night. It moves the done emails into another subfolder and prevents the choking I mentioned above. But if you want to send 400000 emails in a day you need to account for this issue. Matthew A Perosi | Psi Prime, Inc. | http://www.psiprime.com | http://en.wikipedia.org/wiki/Psi_Prime%2C_Inc | 323 Union Blvd. | Totowa, NJ 07512 | P: 973.413.8210 | F: 973.413.8217 | Donovan Brooke wrote: > Tom Duke wrote: > >> Hi all, >> >> I need to upgrade a mass email tool that I have built for a client. >> They are currently mailing to a list of about 7000. I was wondering >> if anyone else has built such a tool? >> >> Things I need to code in to the upgrade are: >> >> - the ability to mail to a list of up 400000 >> - the ability to track open rates for the email >> - some method of handling email bounces >> >> I figure I need to decide whether WebDNA can do all this or whether I >> need to look at something else like phpList. >> >> Thanks >> - Tom > > > Hi Tom, > I haven't built quite the robust system.. but why not.. I don't think > it is a question of whether or not WebDNA could do this, but whether > or not it's coded correctly... 400000 emails eh? I'm > not gonna qet more spam am I? ;-) > > I guess you'd have to build a robust system that not only plays well > with the CPU but accounts for errors. I would think 5 spawned threads > at a time? and make the general page a spawned function as well?.. > just guessing really. > > Maybe instead of one search through the database, your system > keeps track of the "max" and "startat" params... so you are always > sending a limited search that gives the system a break between searches?? > > then upon failure (if it were to happen), you would know what your > last startat was?? Just a couple thoughts. > > Good luck. > Donovan > > >
Associated Messages, from the most recent to the oldest:
I have a messaging system. It tracks when people open emails, but I did not finish developing the bounce back feature. I'm not necessarily offering my system to you, just some input. To track bounce backs you need to send from a POP3 address and have the messaging system POP that account and analyze the emails received. Here's my issue on why I haven't completed this. I currently have my WebDNA server set to deliver 10 emails a minute, which is 600 emails an hour. But that takes FOREVER to send out large lists. Has anyone here ever set the number of emails per minute to greater than 10? I've never tempted fate since the docs say something like "do do that unless your email server can handle it". Is that a warning from 10+ years ago when we had Intel 486 chips? As for the
[spawn] I recently learned that
[spawn] has a processing limitation. I created a script to parse through imported database records and import them into another database. The script dies whenever it processes more than 900 records. It took forever for me to figure out that the
[spawn] routine was dying. I tried to figure out why by creating internal debug routines for the
[spawn] but I was not able to figure out the exact cause. I assume it's a memory overflow or limitation of variables. Therefore, depending on the number of emails sent I would recommend creating an appropriate number of
[spawn]s to complete this task. I can also tell you from personal experience that none of the EMailFolders like more than 2000 files at a time. The server or sandbox chokes to death! In my early attempts with this I tried process too many [sendmails] at a time and the server got caught in an endless loop of sending a single email over and over until I rebooted. I wrote a trigger that reorganizes the EMailFolders every night. It moves the done emails into another subfolder and prevents the choking I mentioned above. But if you want to send 400000 emails in a day you need to account for this issue. Matthew A Perosi | Psi Prime, Inc. | http://www.psiprime.com | http://en.wikipedia.org/wiki/Psi_Prime%2C_Inc | 323 Union Blvd. | Totowa, NJ 07512 | P: 973.413.8210 | F: 973.413.8217 | Donovan Brooke wrote: > Tom Duke wrote: > >> Hi all, >> >> I need to upgrade a mass email tool that I have built for a client. >> They are currently mailing to a list of about 7000. I was wondering >> if anyone else has built such a tool? >> >> Things I need to code in to the upgrade are: >> >> - the ability to mail to a list of up 400000 >> - the ability to track open rates for the email >> - some method of handling email bounces >> >> I figure I need to decide whether WebDNA can do all this or whether I >> need to look at something else like phpList. >> >> Thanks >> - Tom > > > Hi Tom, > I haven't built quite the robust system.. but why not.. I don't think > it is a question of whether or not WebDNA could do this, but whether > or not it's coded correctly... 400000 emails eh? I'm > not gonna qet more spam am I? ;-) > > I guess you'd have to build a robust system that not only plays well > with the CPU but accounts for errors. I would think 5 spawned threads > at a time? and make the general page a spawned function as well?.. > just guessing really. > > Maybe instead of one search through the database, your system > keeps track of the "max" and "startat" params... so you are always > sending a limited search that gives the system a break between searches?? > > then upon failure (if it were to happen), you would know what your > last startat was?? Just a couple thoughts. > > Good luck. > Donovan > > >
"Psi Prime, Matthew A Perosi "
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:
possible, WebCat2.0 and checkboxes-restated (1997)
[Announce]: Web server security and password protection (1997)
NT Manual (1997)
Database of Tax Rates? (1997)
Database Connectivity (1999)
shipping with weigth (1998)
Help! WebCat2 bug (1997)
Carts & cookies (1999)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
More on [purchase] (1998)
nested context (1998)
emailer (1997)
[OT] (waaaay OT) (2004)
WebCatalog can't find database (1997)
& in Lookups (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
[WebDNA] SweepCartFrequency (2010)
Nutscrape Doesn't Render Right (2002)
A question about security (1998)
Physical Security for WebCatalog Directories (1997)