Re: 65mb XML file Crashing CF8 on my workstation

2009-09-15 Thread Tom Chiverton
You could go old school and just treat it as a string... -- Helping to greatly architect eye-catching segments as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a

Re: 65mb XML file Crashing CF8 on my workstation

2009-09-15 Thread James Holmes
We've had good success with Saxon for this kind of thing. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/9/15 Barney Boisvert bboisv...@gmail.com: I'd recommend grabbing a SAX parser and using that instead of the DOM-based stuff that CF ships with.  

Re: 65mb XML file Crashing CF8 on my workstation

2009-09-15 Thread Gerald Guido
I did the same sort of thing using a DTS in SQL Server a long time ago. It was a little ActiveX (aka VB) script . It took about 3-5 seconds for a 25 meg MLS file. IIRC I found a code example on Xperts Exchange. HTH, G! On Mon, Sep 14, 2009 at 5:42 PM, Alan Rother alan.rot...@gmail.com wrote:

65mb XML file Crashing CF8 on my workstation

2009-09-14 Thread Alan Rother
Hey All, I'm trying to parse out a 65mb XML file from a customer... Don't ask... Every time I try to hit it with XMLParse(), memory spikesfrom 500mb to 1,200 and then crashes CF Has anyone else dealt with big XML files like this? =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7

Re: 65mb XML file Crashing CF8 on my workstation

2009-09-14 Thread Barney Boisvert
I'd recommend grabbing a SAX parser and using that instead of the DOM-based stuff that CF ships with. Then you can stream the file in and deal with it's nodes sequentially, rather than having to inflate the whole thing into a DOM tree to manipulate. Definitely can make the code trickier to