Hi All
I've been looking into the best way to send the occasional one-off
newsletter to 50-60,000 customers.
The e-mail addresses are stored in a MySQL database and I'm currently using
a PHP script which I can drop the HTML e-mail into which loops through using
PHP's mail() facility. It worked OK for the one time we needed to do it,
albeit a little slowly.
Now we've got a new server, a P3 with hardware RAID1 scsi disks, and I want
to get going with the bulk e-mails. Each e-mail is customised for each
customer. I want to get the send times as low as possible.
Two questions:
- For max. delivery speed, can I just up the concurrency-remote to, say, 400
(applying patch) - do I need to do anything else (Linux RedHat 7) eg. to do
with process limits etc?
- I need to track bounces, fails etc. is the best thing to call qmail-remote
directly, for each email, and then if it fails mark it in the database or
pass it to qmail-inject (if temporary)? Also I'm running qmail-scanner, so I
need to disable this for each e-mail. Could I potentially outweigh any speed
benefit by having to use MySQL update queries or by the fact I'm using PHP?
note: I would like to keep it in PHP as it's what i know ;)
Cheers
John