Visual Basic

View All Threads First Prev Next

Using large XML dataset efficiently Dominick Marciano7-Nov-12 8:16 Dominick Marciano 7-Nov-12 8:16  I currently have an XML file that contains about 115,000 codes along with addition information (description, "see also" information, etc), and is about 8.5MB in size. Unfortunately I did not create the file and cannot change it's format; must be used as is. I've never worked with a file of this size. Just trying to open the file to look at the format was cause slow-down while opening and trying to scroll through it. However, for my application, I need to be able to dynamically update drop-down list with the codes (as the user starts to type in a code), as well as do search for codes. I'm thinking this file is too large to load into an XDoc object or into a custom sorted list (key=code, value=description). I'm hoping someone has had experience working with similarly large XML files and has some suggestions on the most efficient way to work with a file like this. Thanks in advanced for any help you can provide. Re: Using large XML dataset efficiently David Mujica7-Nov-12 9:10 David Mujica 7-Nov-12 9:10  How about this ... 1) Load the data into a SQL server table. 2) Have your application access and manipulate the data in the database. 3) Whenever you need the file, then run a routine to export the data from the database to the XML file. Just a thought.

Last Visit: 31-Dec-99 18:00     Last Update: 19-Apr-24 15:59 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.