sending newsletters via php & mysqld

Hi,
I have a script for sending newsletters.

my ISP has advised me to set a sleep command of 10seconds every 50 emalis so as to batch them and avoid a few issues.

I'm findng this can lock the browser

One suiggestion
Create a cronjob that runs every 30 mins
It searches a database for newslettter requests
After executing the script to send newsletters,  it deletes the records

In my script, I'd create the record with any variables before returning control to my browser
then wait for the cronjob

Can anyone highllight issues with this approach and/or offer better options
thanks
joomlaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
EMB01Connect With a Mentor Commented:
Instead of deleting newsletters after it send them, just add another field called "sent" and update the records once they are sent.  When you send you newsletters, only records that have not yet been sent will be sent.  I created a mass mailer and it worked very well, and it didn't cost me anything but hosting and my time.  I had a pretty good click-through rate, too.
0
 
Beverley PortlockCommented:
Your basic approach is correct, but I would add these comments

1) If anything goes wrong it sounds like your ISP will not be best pleased. You may breach the Acceptable Use Policy

2) Use ConstantContact or GraphicMail. They will both do this job for you and the statistical analysis tools are good. The emails are very cheap to send. Both companies offer demo accounts for free.

These companies have already solved the email campaign as a problem and they are very, very cost effective. Don't waste your valuable time reinventing the wheel and trying to save a few pennies.
0
 
joomlaAuthor Commented:
thanks for your feedback EMB01
not sure it's worth 250 points.
Are there any limitations you can think of or spam guidelines I need to consider

Will cronjob set to 30mins be too resource intensive?
htnaks
0
 
EMB01Commented:
>>  not sure it's worth 250 points.

Thanks, buddy!

>>  Are there any limitations you can think of or spam guidelines I need to consider

Check the SPF and domain keys for your sending IP.

Will cronjob set to 30mins be too resource intensive?

>>  Depends on your server requirements.  The server I sent from didn't have much traffic, so I maxed her out when sending emails.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.