Brian-- Thanks for your quick response.
Currently, I am building the XML variable with <cfxml>, looping over the query for the appropriate nodes. I will definitely check out the links you suggested. Thanks again! Joel Watson http://singularityconcepts.com >How are you creating the XML variable? Becuase if you are building it up >manually by concatenating strings together this is common. This is because >every time you concatenate a string it creates a new Java String instance, >which means you have (depending on how many columns you have) hundreds of >thousands or even millions of String instances that won't be garbage >collected until after the request is over and all references to them are >gone. > >Use a Java StringBuffer (or if you're on Java 5 or 6, a StringBuilder) to >build up the XML string, as these are specifically for building up large >strings without constantly creating new instances. You can find easy CFC >wrappers for these and other Java classes at >http://www.informationsavvy.com/coldfusion/. > >On Tue, Apr 15, 2008 at 10:51 AM, Joel Watson <[EMAIL PROTECTED]> >wrote: > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303426 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

