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?
I realise there could be many other factors in play and we have been
investigating various memory and GC settings in the cf instance - but
I'd like to know thoughts on that particular code (of which I am not
an author or fan).
Thanks in advance,
Dominic
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:321768
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
