Our site is build in xml technology, but is givin us a lot of
problems, especialy the high cpu usage problem. We have a web server
and a database server from where the xml is create. The web server is
fine but the data is always at 100 percents of is usage and it has 2
processors pentium 3 1.3 2 gybytes of memorie. We are using sql 2000
as our data base What can it be??, can someone please help me givin
me some tips or things to look for.

The process we use in our site is:
We use XML in two scenarios, the first one is the site structure,
this is a large XML file containing info on all the pages and modules
inside of them, and the main menu. something like this:

<site>
<page1>
<column1>
<include1/>
<include2/>
<include3/>
</column1>
<column2>
<include1/>
<include2/>
<include3/>
</column2>
<column3>
<include1/>
<include2/>
<include3/>
</column3>
</page1>
<menu>
<item1/>
<item2/>
<item3/>
<item4/>
</menu>
</site>

We process this using Micosoft XMLDOM, we've also tryed Chilkat XML
parser and I got a 300% improvement as they say, but still is
processor consumming. we traverse the document back and forth to
retrieve the data. the main methods we use are GetChildNodes,
Getattribute, nextsibbling, previoussibbling, childnodes.lenght.

----

The other part where we use XML is the SQL2000 Server, we use stored
procedures to get the data in XML format using FOR XML EXPLICIT and a
4 level UNION Example:

Select 1 TAG,
null PARENT,
field1 as [node1!1!field1],
field2 as [node1!1!field2],
field3 as [node2!2field3],
field4 as [node2!2field4],
field5 as [node3!3field5],
field6 as [node3!3field6],
field7 as [node4!4field7],
field8 as [node4!4ield8],
field9 as [node4!4field9],
field10 as [node4!4!field10]
from table
UNION ALL
Select 2 TAG,
1 PARENT,
field1,
null,
null,
null,
null,
null,
null,
null,
null,
null
from table
UNION ALL
Select 3 TAG,
2 PARENT,
field1,
null,
null,
null,
null,
null,
null,
null,
null,
null
from table
UNION ALL
Select 4 TAG,
3 PARENT,
field1,
null,
null,
null,
null,
null,
null,
null,
null,
null
from table
ORDERB BY [node1!1!field1]

We get the data using an ASP page and the ado.stream to read the xml
text data, we process the XML with MSXML 4.0 using XSL stylesheets
precompiled in application variables using the XSLPROCESSOR.

Tht's it.

Thanks.