Hi,

I need to have random access to the XML document, selecting children may
depend of what parents are and vice versa, need to be able to go from deeper
level back to ancestors etc. So naturally XPath (and XPathDocument and
XPathNavigator) are the tools of choice. The problem is - how to deal with
large files? Entire document has to be loaded in memory and for files over
50Mb "out of memory" error is guaranteed.

Any idea how to have random access to large XML documents?

Thanks,

Yuriy.

Yuriy Galanter wrote:
Well, 50 Mb isn't particularly huge document/. XPathDocument should
handle it ok, allocating about 200Mb or RAM.
As an alternative consider using XML data type in SQL Server 2005.


--
Oleg Tkachenko [XML MVP, MCPD]
http://www.tkachenko.com/blog | http://www.XmlLab.Net