Re: XMLType performance

The Geek Inside wrote:
> Hello there,
>
> I'm involved in a project with many XML managment and I'm evaluating
> using the XMLType to store several information types in XML structures
> and extract information from these.
>
> This is the first time using XMLType, I would like to get some feedback
> about the preformance using XMLType.
>
> The system will have many queries to this information.
>
> Thanks in advance.

I would never store XML inside a database if it could be reconstituted on demand.

Without knowing the full set of requirements my initial reaction would be ... never store XML.

Consider the scability and storage of:
<thisisareallylongtag>1</thisisareallylongtab> To which you can add the lack of relational integrity.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org