> Hi all, we are getting the following error when sending a bulk > newsletter with cfmail (130,000 emails), "GC overhead limit exceeded" > (java out of memory error), followed by "Heap space" errors on > subsequent requests to the server. On this legacy system, we are > sending 1,000 emails at a time using cfmail as follows: > > <cfmail to="#LCase(Trim(Replace(email,' ','','All')))#" > from="#trim(qry_getnewslettertype.returnEmail)#" > subject="#Replace(Replace(qry_getnewslettertype.subject,'[TheUsersFirstName]',Trim(firstName),'all'),'theUserID',Val(userID),'all')#" > query="getHTMLusers" > maxrows="#getHTMLusers.recordcount#" > startrow="1" > > type="html">#Replace(Replace(Replace(Replace(outputted_html_text, > '|0000', '|#Val(userID)#', > 'ALL'),'[TheUsersFirstName]',Trim(firstName),'All'),'theUserID',Val(userID),'All'),'tempUserID',Val(userID),'All')# > </cfmail> > > Apologies for the readability. I suspect that all those Replace()es > that are executing on every iteration may be causing the issue with CF > not cleaning up the strings nicely. Does this make sense?
It's possible that this is contributing to the problem. You could try the ReplaceList function instead, which should get you to the same place. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321770 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
