On Apr 8, 2005 2:00 AM, Protoculture <[EMAIL PROTECTED]> wrote: > I would take a guess that the queries that search for related data to a > specific client is what is slowing the whole thing down.
As Jochem says, guessing isn't good enough. You need to measure things properly to find out where the bottleneck is. > ( It seems to take the better part of a day to send out 40,000+ ) emails.... Benchmarks on Enterprise Edition have shown throughput of 1,000,000 messages an HOUR: http://www.macromedia.com/devnet/mx/coldfusion/articles/intro_61.html "Improved CFMAIL Tag The most popular Internet protocol tag must be the CFMAIL tag, and Macromedia has dramatically enhanced it, too. For starters, in ColdFusion MX 6.1 Enterprise, it is possible to allocate multiple mail delivery threads and also keep SMTP connections open. The combination of these two features introduces mail delivery throughput that exceeds anything possible in prior versions of ColdFusion. On test boxes, the CFMAIL tag has been clocking delivery of over 1,000,000 messages an hour!" Of course, you're not using Enterprise but the performance improvement might be a good justification for upgrading. > As I've mentioned before, the way this has been set up is on CF Developer > Edition along with scheduled tasks for each group of 1000 clients. This is > the system that I have inherited. As Jochem observed, that is in violation of the license agreement: "(h) You shall not (A) use the Developer Version for any application deployment in a live or stand-by production environment or staging environment, in each case, including, without limitation, in any environment accessed by application end-users including but not limited to servers, workstations, kiosks, and mobile computers" You definitely need to talk to your boss about coming into compliance as soon as possible. As noted, there are several Macromedians on this list, including ColdFusion product team folks... -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201986 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
