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 [...]
