Perhaps you can read in the file as a flat text file, split it on record delimiters (ie. <item> or <record>) parse each one of them individually into an XML object, then append all the Xml objects together? No idea if that works :)
....................... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com "Some people call me the space cowboy. Some people call me the gangster of love." -----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, July 17, 2006 2:20 PM To: CF-Talk Subject: Parsing Extra-large XML files? I've got a co-worker who is working with a client that receives product information from a third-party vendor in XML format. He needs to take the information contained in the XML file and dump it into our local database. The XML file is 50 megs and contains lots of "columns". He's been trying to dump the file into memory using XMLParse but CF keeps crapping out on him. Does anyone have any ideas what my co-worker can do with this file? <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/cf_lists/message.cfm/forumid:4/messageid:246798 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4