Re: XMLType performance

joel garry wrote:

> Now, Daniel says never store XML in the DB,

If I did I didn't intend to. I've no problem with XML stored in the database if it is done as document storage in the same manner in which I would store a .PDF or .MPG file.

What I object to is storing XML as active content to be updated and queried.

> and I think your tax
> example is perhaps a good refutation of that. The IRS stores each
> data element with an XML tag

That is about as good an argument as an I can think of for not doing it.

-- 
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