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.
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 19:00 Last Update: 9-Dec-16 5:23