Sending Multiple Mails

Brusca

Hi Guys,
I have setup the send of an html email to a group of people coming from my database. I have this working fine.

Basically I run thorugh a recordset from a database and pull out an email. For each row result I have a mail($email, $subject, $body, $headers) which sends to that specific email address in that row and it just runs through until there are no rows left to loop through.

Currently I have this setup for about 20 records in my database, but was wondering if this would still be a good solution if I had around 10,000 records i my databse??

Would this amount cause issues in any way? If so is there a better solution to send mass html emails from a datase??

Cheers Bruce

Frederick

most hosting has their php.ini configuration setup to 30 seconds

max_execution_time = 30

This setting can not be overwritten by ini_set() so your sending HTML emails will most likely end after about 100-150 emails.
Use plain text and you will get about a 250% inprovement.

Brusca

Well I am not totally sure but we may be able to control or change the max_execution_time in the php.ini file on our server.(pretty sure we have our own box) .

Would there be a recommendation for a max_executuon_time to send 10,000 html emails?

If this is still not a viable option is there anything out there on the web that we could use to send emails (html or text) to the 10,000 odd members on our database??

Cheers

Roger_Ramjet

Well, one way would be to concatenate the recipients into a bcc (blind copy) list and then let your mail server do the actual generation of the multiple emails, your script would then just have to send the one email and you would not have to worry about any time limits. You may however run into a limit on the number of bcc recipients your mail server will handle.