Hello all -
I've got a interesting delimma...We run a insurance agent web application on our server using MySQL database, PHP 4.3.2, and Apache 1.3.27. The server is a Sun E250 running Solaris 8.
A feature of the site allows agents to send birthday/news/info emails to some or all policy holders and leads. Some agents have over 100,000 clients.
We run a script that pulls the client email from the database, builds a html based email, then sends the email via sendmail. If the agents sends to all clients this could be a large for loop.
Anyway, to send 100,000 emails it takes about 24 hours. Is there a way to speed this up? Is the lag caused by the for loop, sendmail, or the php mail function?
Thanks...
Jon
