I am loading an XML document through a VBA Macro over the network drive. The Size of the document is about 100 MB.
For performance reasons, I was planning on have a script that would ZIp the file and copy it to the local folder and then unzip it and the load it using the MSXML load Method. Everything works well. The Size of the zip file comes down to 3 MB and then i unzip it back to it's orginal size.
One thing that puzzles me is that the time take to load the xml document through the Load Method is same if done over a network or from the local c:\ drive.
Does this make sense?
Start Free Trial