Well, you can override the XML.onData. This is fired before XML's onLoad, and it'll give you the raw XML string data, unparsed. You can then manually parse this.
Are these XML files created yet? Like, you say Excel document. If you can, creating a dictionary file that points to a series of XML files is tons better than 1 big beast. The problem is, even XML.onData still has that honkin' string in it, and using the String methods on it will still chug. Your best bet is to load in the index file, and only load those smaller files. Even if the the "smaller" file consists of thousands of records, you can simply wait a frame after she loads, use a String.indexOf on a certain node, say "<record>" and repeat over a series of frames to record indices of where all the nodes are. In the next pass, you could then break it up into chunks. Since strings are copy by value, you could make a copy of the string you want to parse, just parse that chunk, convert to something meaningful like an array full of objects, discard the string, and repeat on the next frame. You could even save those objects you've created as sharedobjects, eliminating them from memory. ----- Original Message ----- From: "Jonathan Clarke" <[EMAIL PROTECTED]> To: "Flashcoders mailing list" <[email protected]> Sent: Thursday, January 05, 2006 10:17 PM Subject: Re: [Flashcoders] Massive XML files and Flash Thanks Jester, but databases are not my forte, to do it quickly I'd like to just use ActionScript only. Is there anyway I can just load specific sections of the XML or do I have to load the whole file into memory? On 05/01/06, JesterXL <[EMAIL PROTECTED]> wrote: > Does it have to stay in that format? Meaning, can you convert it and > throw > it into a database? Paging is still an effective methodology, and if you > can throw it in a database, you can then do what Flash does best and load > what you need on the fly. > > ----- Original Message ----- > From: "Jonathan Clarke" <[EMAIL PROTECTED]> > To: "Flashcoders mailing list" <[email protected]> > Sent: Thursday, January 05, 2006 7:21 PM > Subject: [Flashcoders] Massive XML files and Flash > > > Hi, > > I find myself in a situation where I need to build a tool to analyse > lots of xml data. Thousands of records containing a lot of strings as > well as numericals. I'm sure there are lots of more suitable > applications and languages, but I the only one I know is Actionscript. > Luckily, I know it very well and am more than confident at parsing > XML; however, I've never delt with data on this scale before. So, I'm > interested to know if anyone has any experience of dealing with this > sort of build, and whether it is feasible to expect Flash to handle > it. > > More on the data: I need to cross-reference and check data accross 3 > xml files. They are all big, but the biggest, by way of an example in > Excel form, has 25,000 records each with around 30 fields, often very > string heavy. > > Any tips would be greatly appreciated? > > -- > Jonathan Clarke > 1976 Ltd > http://19seventysix.co.uk > e: [EMAIL PROTECTED] > m (UK): +44 773 646 1954 > m (Barbados): +1246 259 9475 > _______________________________________________ > Flashcoders mailing list > [email protected] > http://chattyfig.figleaf.com/mailman/listinfo/flashcoders > > _______________________________________________ > Flashcoders mailing list > [email protected] > http://chattyfig.figleaf.com/mailman/listinfo/flashcoders > -- Jonathan Clarke 1976 Ltd http://19seventysix.co.uk e: [EMAIL PROTECTED] m (UK): +44 773 646 1954 m (Barbados): +1246 259 9475 _______________________________________________ Flashcoders mailing list [email protected] http://chattyfig.figleaf.com/mailman/listinfo/flashcoders _______________________________________________ Flashcoders mailing list [email protected] http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

