As ar as creating the XML that gets sent out to the webservice, I'm simply using a <cfxml variable="mstring"> blah blah blah </cfxml> followed by a call to TOSTRING
I ripped out all of the code that created the intermediate query, and so far memory usage is staying under 100mb, as opposed to 1200+ MB that it was doing previously. So I guess it was all of those calls to set the contents of each cell in the query. Which might also point to having debugging enabled. BUT, I thought that I read/heard when CF MX7 came out that the overhead of having debugging enabled was drastically reduced from what it had been in previous versions - that CF was now checking the debugging IP list before storing debugging information during execution, rather than the old method of always storing the info and only checking the IP list at the end of the request to see if it needed to be displayed. Am I imagining that? thanks, Reed >Hmm... How are you building the xml doc? If you are appending to it 10 >times and not using Java, I believe it creates a new variable every time you >append (and most likely it won't be GC'ed until your script has finished >running). > >Calling the GC directly will not always have an effect, as it's not a >command but more of a suggesting to the GC to do garbage collection. > >There are certain flags you can turn on in your config file for the jdk, >something like ++AggressiveGC I believe, but I'm not sure if that will help >you out. > >If you are building the string inefficiently, try optimizing that. You also >might want to put in a few sleep calls to allow the GC to run. (I've never >tried this, but it just might work). > >Russ > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

