Re: XMLType performance

On Apr 10, 2:10 pm, The Geek Inside <jcs..._at_gmail.com> 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.

Funny, this was just in my .sig: http://www.sqlsnippets.com/en/topic-11783.html XML is the slowest of several ways to do the same thing.

>
> The system will have many queries to this information.

I'm maintaining a system that does this, it is a very stupid idea. XML has a very limited purpose, as a data interchange standard. In a database, you usually have metadata that describes the data, separate and distinct. With XML in a database, you are mixing the data with its description, which means you are constantly describing the data unnecessarily. Think about it - in data interchange, you have data which may be described in different ways on different systems, so you need a way to tell each system how it should be described. In a database, the metadata describes the data - you don't have to redescribe it every time you access a row! Not to mention it can increase the size of data by large amounts.

>
> Thanks in advance.
> --
> Premature optimization is the root of all evil.

You ain't seen evil until you've seen premature unoptimization!

jg

--
@home.com is bogus.
In the event of a water landing, please use the gravitationally
challenged as flotation devices.