I have a forum in which users can subscribe to particular threads. When other users make replies, all users who are subscribed to the thread will receive an email (basic stuff, I know).
My question is regarding what the best practice for handling this mailing should be. Currently, I am querying my db to get the emails of subscribed users. Using the listAppend function, I create a list of emails and pass it into the bcc field (I don't want every user to get the emails of every other subscribed user). Right now, this is not a problem as the user base is small. However, if it increases (and I expect it to very soon), I am wondering if this is the best way to do this. So my question is this: Would it be best to continue with what I am doing (list of addresses), and is there a certain limit to the number of addresses that can be in the bcc field? Or...should I loop over the cfmail tag itself, running the tag the same number of times as there are subscribed users? In this option, are there going to be significant performance issues if, say, there are 500 subscribed users (thus the cfmail tag running 500 times?) And, of course, there may be other ways to do this entirely that are better than either of these options. I am definitely open to those as well. Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by AdobeĀ® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277717 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4