Re: Development Trends in Web and Oracle

> Nothing moves anywhere without running through the CPU. Given disk is
> cheap one could potentially overlook all of this but what can not

Daniel, the XML isn't stored as a CLOB, it is shredded & recomposed! The argument is valid if were storing XML as a LOB.

> h and decrease performance
> by pushing huge numbers of unnecessary bytes.

And why is it decreasing performance. Read what I have written in the other posts. For you to validate information you would need a barrage of stored procs etc to check data validity etc. This can be done in an XML schema OUTSIDE the database if you choose. Actually, by default, XML inserted into an XMLTYPE column in a table isn't fully validated anyway - you have to explicitly do this.

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:1110655662.534446_at_yasure...
> Hexathioorthooxalate wrote:
>
>> Hi Daniel, may I ask for you elaborate a little further on this please?
>>
>>
>>><RIDICULOUSLYLONGTABSIGNIFYINGNOTHING>X</RIDICULOUSLYLONGTABSIGNIFYINGNOTHING>
>>>
>>>XML is fine for front-ends but doesn't belong in a database unless the
>>>object is to spend money on hardware.
>>
>>
>> There is an inference in what you have written that
>> RIDICULOUSLYLONGTABSIGNIFYINGNOTHING occupies much space in the database
>> or significant CPU overhead to process (the hardware reference). You have
>> specifically not written this however so I ask for you to clarify?
>>
>> Regards
>> Hex
>
> The storage, unless parsed to relational, wastes all of that space. CPU?
> Nothing moves anywhere without running through the CPU. Given disk is
> cheap one could potentially overlook all of this but what can not
> be excused is the waste of network bandwidth. Why would anyone with a
> working synapse choose to increase bandwidth and decrease performance
> by pushing huge numbers of unnecessary bytes.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)
Received on Sat Mar 12 2005 - 15:21:03 CST