Category: General
July 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 percentage points [sic], so therefore he’s an expert.

I mean show your work, which means documenting a relevant baseline measurement, conducting a controlled experiment, documenting a second relevant measurement, and then showing your results openly and transparently so that your reader can follow along and even reproduce your test if he wants to.

This is more or less funny, because I read Cary’s post, be apparently I didn’t read it… I can really relate to it now.

I am in the middle of setting up a XMLDB test environment to test, among others, load times while using different kinds off XMLType storage based upon CLOB, Object Relational and Binary XML (using Basicfile / Securefile options). And although I am working on a VMware environment, I noticed that it isn’t that easy to setup a “controlled experiment“. What makes it harder is, that I am using the Mediawiki XML English dumpfile, that contains roundabout 7 million records (17 Gb of ASCII data). This makes it more interesting, and the effects more clearer, but it also takes much more time to do stuff.

Read the postSetting Up an XMLDB Performance “Baseline” Environment
July 11

HOWTO: Load Really Big XML Files

Sometimes you will want to load data from huge XML files into the database. So how do you achieve this?

There are more then one ways to achieve this, but most of the time a “SAX parser” is used. The term on Wikipedia for SAX is:

A Simple API for XML (SAX) is a serial access parser API for XML. SAX provides a mechanism for reading data from an XML document. It is a popular alternative to the Document Object Model (DOM).

The disadvantage sometimes of using DOM is that it uses to much resources in the sense of CPU and memory and for really huge files this method simply will not work in terms of performance. Parsing an XML document with DOM acquires the whole document to be loaded into memory before processing can be started. Via SAX only a small memory footprint is needed.

Read the postHOWTO: Load Really Big XML Files
July 10

“Death by Mii…” or “How to Recover from Mii Loss…”

I have a daughter Athina, she is 6. Her girlfriend from across the street got also a Wii today. All the boy friends and girlfriends visited that girlfriend from across the street. So in her “despair” she deleted all her friends Mii‘s on our Wii (including mine).

Cool stuff being six.

I had a good laugh, although I couldn’t show it in front of her. While being very very serious, ehhh sort of father like, I tried to explain to her that friendship couldn’t be bought etc. and kept that lecture going for about half an hour.

She is bright and got the message. Being a father can be difficult… 😉

Read the post“Death by Mii…” or “How to Recover from Mii Loss…”