Dealing with the flexible metadata structure with xml type database

We are using xml type in the oracle to support complex strucutre for our metadata.
The xml can be as many as 200 elements in the node and can be repetitive. However, currently we experience the problem is that when client asks to get the search
result it takes a lot of times to transform this xml to xml for the search result. For example
when we have 300 metadata items, it takes 2 seconds to parse 10 xml records. Compare to
regular database it's a lot more. I was wonder if there are any workaround for this problem.

in side of xml type databse

ID XMLTYPE
1. <?xml ....><root><item1>...</item200></root> 2. <?xml ....><root><item1>...</item200></root>

Conver the data above to xml for displaying search result in the browser.

<?xml version="1.0" ?>
<searchresult>
<record>

    <id>1</id>
    <item1>12</item1>
    ..
    ..
</record>
<record>

   <id>2</id>
   <item1>22</item1>
</record>
</result>

This takes 2 seconds for 10 records.

MD Received on Mon Sep 11 2006 - 18:13:45 CDT