I'm using cfmail to send a multi-part message to
approximately 10,000 recipients. CFMAIL loops over the list of
recipients from a query. The problem is that as the template
processes it keeps chewing up memory and at some point chews it all
up and throws a 'jrun closed connection' error. It seems to max out
around 800 emails before it bombs out.
Is there a way to make the template release memory as it
runs? Something like 'Send 500 emails, flush the memory, send 500
more emails, flush the memory...'
I intend to add a couple more GB's of RAM to the server
(there's 1GB now) but as our subscriber list grows I see the same
problem occuring again in the future. Any advice would be
Right, you can split your query, 500 should be nice, a
looping page until max has been reached could be a solution...
Don't know which version you own, but I personnaly don't use
cfmail for large mailing list. ASPmail or Activmail work great.