Thanks.
Patrick actually wrote to me and said that on larger forums, this can slow down. I didn't write the original workings to this, as it's based on Lunatik's Subscriber Emailer Hack. I simply used it and added a "switch" to allow people do get either digest or subscription.
The original hack uses a query which Patrick's host told him was pretty inefficient.
$query = "
SELECT U_Email,
U_Language
FROM {$config['tbprefix']}Users
LEFT JOIN {$config['tbprefix']}Subscribe ON S_UID = U_Number
WHERE S_UID = U_Number
AND S_Board = '$Board_q'
AND U_EmailDigest = 'no'
";
Can anyone see a way that the query might be done so that it's faster to complete the post on larger boards?
I'm really not familiar with the use of LEFT JOIN so I'm not sure if that's good or not. LOL
Thanks.