Have you tried moving this job off to th db server and taking cf out of the loop. Use stored procs etc.
Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Jan 30, 2013 10:27 AM, "Helwig, Till Helge" <till.hel...@saxsys.de> wrote: > > Hi, > > I'm working on a very old and very badly coded CF application at the > moment. It contains servertasks that do a lot of batch processing where > huge data sets are queried from a database, processed and the results > written back to the DB. Unfortunately by now the jobs have become so large > that we frequently get heap space errors. I'm trying to figure out why the > process takes up so much memory and I've reached a point where I just don't > know what to look for anymore. When looking at the memory monitor it looks > to me like in every loop iteration he accumulated about 100 MB of data, > procceses it and throws it away, but not entirely. A small piece stays in > the memory every time and in the end it clutters up all the heap space. > > What I already did: > > - Adding "var" to local variables > > - Replacing literals in queries with cfqueryparams > > - Replacing StructNew() at the beginning of loops with > StructClear() > > - Replacing query-loops with index-loops > > I also started looking at dumps of the Java heap shortly before the > process crashes, but I'm not really getting any wiser from that. I see that > there are millions of objects in the memory and many of them are LoopTags > and QueryTags, but other than that I have no idea what to make of it. > > I've read that placing the code of the loop within its own thread might > help, but that's impossible because our task already runs in its own thread > and apparently CF can't spawn threads from within threads. > > If you have any ideas for me where to look for memory leaks, what else to > try or an explanation for what might cause the problem, I would be really > really thankful! > > Greetings, > Till Helge > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354116 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm