Subscribe to RSS feed

Sep
05

XMLDB Performance: Binary XML Storage Models

This post will show you some of the first numbers I collected regarding “Loading XML data”, while making use of different XMLType “physical storage containers”. I also have done some initial testing with Object Relational XMLType storage, but because this method of storage has many options and extra features, I won’t describe them yet here. [...]

Jul
20

XMLDB Performance: The Side Effects of a Simple “count(*)”

While setting up a baseline for my XMLDB performance tests, I noticed that my “count(*)” on a Binary XML table (using Securefile LOB storage) called “WIKI_STAGE” took an awful long time. So long, that I even had to kill the SQL*Plus session, that was executing the “count(*)”. I started wondering. Why did it take so [...]

Jul
15

Setting Up an XMLDB Performance “Baseline” Environment

I just read Thomas Kyte’ s blog post “Read This“, which is dealing with the content of the blog post of Cary Millsap. As Tom phrased it: I liked what Cary Millsap just said: I don’t mean “show and tell,” where someone claims he has improved performance at hundreds of customer sites by hundreds of [...]