468,272 Members | 2,077 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,272 developers. It's quick & easy.

PureXML

Does PureXML use bufferpools for all the data stored?

I am assuming that PureXML is faster than XML Extender at shredding data,
but is not faster than relational (without LOB's) in cases where there are
no XML documents (other than people trying to force a schema into an XML
document).
Jul 23 '08 #1
3 1802
Mark A wrote:
Does PureXML use bufferpools for all the data stored?
As far as I know only inlined (aka small) XML documents in DB2 9.5.
I am assuming that PureXML is faster than XML Extender at shredding data,
PureXML does not shred data.
but is not faster than relational (without LOB's) in cases where there are
no XML documents (other than people trying to force a schema into an XML
document).
Well, XML documents don't fall out the sky I s'pose.
XML can be a better approach than relational when the schema evolves a
lot. If you have trouble making (and keeping) it square.. XML may be
your friend.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Jul 23 '08 #2
"Serge Rielau" <sr*****@ca.ibm.comwrote in message
news:6e************@mid.individual.net...
Well, XML documents don't fall out the sky I s'pose.
XML can be a better approach than relational when the schema evolves a
lot. If you have trouble making (and keeping) it square.. XML may be your
friend.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
I do understand the advantages of XML schemas, but now I need some
information of performance.

I have seen the performance comparison between PureXML and XML Extender, but
I am particularly interested in the performance differences between PureXML
and relational.

If PureXML just uses CLOBs then I already have numbers for the difference
between a CLOB and VARCHAR (or any relational schema without a CLOB).

In the implementation I am looking at, large documents are not really
involved, and all individual segments(?) of the XML schema (what we call
columns in relational) are less than 1K. I want to make sure I am not
misunderstanding something about how PureXML data is stored in this type of
situation. In other words, if each segment (column) is small, can it be
configured to use DB2 bufferpools, or does the whole XML document have to be
small?..
Jul 23 '08 #3
Thanks Matthias!

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Jul 24 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Serge Rielau | last post: by
2 posts views Thread by Karstens Rage | last post: by
3 posts views Thread by db2admin | last post: by
4 posts views Thread by 2803stan | last post: by
2 posts views Thread by Sam Durai | last post: by
1 post views Thread by Ram chandran | last post: by
reply views Thread by maism_mca | last post: by
reply views Thread by Rajesh Kumar Joshi | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.