Hi all, we're running a site for a customer, which continously collects data from participants. this data is callable for our customer through a webservice. Our customer consumes this webservice with a .net client. The webservice generates an XML file, which has already been optimized on lenght.
By the time, the collected data has grown to about half a million rows and counting... Our Server seems to run out of memory now, when trying to create the xml-object (java.lang.outofmemory error). We already tried a different method to create the data for transfer by cfsavecontent. We even rewrote the sql-script to generate the xml-nodes directly. But in the end, after about 100,000 rows the server (1GB RAM) runs out of memory again. There must be a better way to transfer these amounts of data... If our customer would have used coldfusion, we could just exchange a query object... Anyone a hint? Greetz Joerg ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214124 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
