here is my situation:
i have a client (travel agency) that has built up thier member database to over 450,000 members (that have requested to be e-mailed of updates etc... - the reason i mention this is because the news groups wouldnt help because they insisted i was doing spam). we have a custom built smtp engine to handle large volume e-mails that we wrote specifically for this client. the member info is stored in a mysql databse on a freebsd box. we ran a test with 15,000 of the e-mails and everything was sent and received in less than 4 minutes (roughly 220,000/hour). i am opening a socket to our smtp server and issuing smtp commands instead of using php's mail function as i don't want to open un-needed connections. so with 15,000 everything worked fine.
then we tried 80,000. php keeps timing out. i executed the sql statement:
SELECT DISTINCT email_address FROM master_list
at the sql command prompt and it returned in a couple seconds.
if i execute the following php code:
$sSql = "SELECT DISTINCT email_address FROM master_list";
$iRes = mysql_query($sSql);
it times out. i guess i could break it into batches of 15,000 but i would like to grab all of the e-mails in one query. does anyone know of a way around this or to handle this?
again, i am NOT spamming. if i were, i would use majordomo or something already written instead of wasting my time coding this from scratch. however, it is critical that we code this our clients specs so that it will function seamlessly with the rest of the site.