I am looking for some information on storing options for a very large XML document. I am going to be using JSP to display the page and Oracle as my database. There will be a large number of users, a lot of fields that require manipulation, and I need to be able to read the entire document at once, as well as having the option to select smaller pieces to read at one time.

Anyone know of some good resources I can explore to learn more about storing the entire XML document in one CLOB field vs. storing each field seperately in multiple tables and columns? Any opinions/suggestions?

Thanks,
walteramylee

Oracle is not really my subject but as a general principle loading large documents can cause problems. I take it that is what you meant by . As a rule of thumb loading via DOM needs three times the size of the document as RAM, this might be a problem if it is opened separately by many users. You would need to use a different approach, SAX or the .NET style XmlReader.



--

Joe