I've recently been handed a huge mess of a project to clean up. Apparently there have been major issues with a newsletter tool timing out due to the increased number of registrants.
I'm just curious how most people are handling sending out massive amounts of in short periods of time. Right now it is basically... 1) Set the timeout to a ridiculously high number 2) Select all the 3) Loop over all users and cfmail the newsletter 4) when people complain about timeouts, increase ridiculously high timeout number I'm sure this worked fine when there were 100-200 people in the database but that number is now very near 10,000. I'm probably not thinking hard enough just yet but there has GOT to be a better/easier way. I'd appreciate any comments or suggestions. .... This does need to be fully automated and I can't expect the user to open a meta refreshed page and let it run. (that would be too easy lol) Thanks ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.11.7/436 - Release Date: 9/1/2006 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251890 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
