Hello,

One of our sites is experiences performance issues. Using the umbDebugShowTrace I have narrowed it down to a specific XSLT file. Now, I have checked it over, and the only parts that (to me anyway) seem like they could be the cause are the for-each loops we use. I have however, no idea of how to get the data I need with another (more optimized) Xpath expression. If someone could take a look at this that'd be great.

-Ferdy

The xslt:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE xsl:stylesheet [ <!ENTITY nbsp "&#x00A0;"> ]>
<xsl:stylesheet
  version="1.0"
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:msxml="urn:schemas-microsoft-com:xslt"
  xmlns:umbraco.library="urn:umbraco.library"
  exclude-result-prefixes="msxml umbraco.library">


<xsl:output method="xml" omit-xml-declaration="yes" />

<xsl:param name="currentPage"/>  
    
<xsl:template match="/">
  <ul id="nav">
      
    <xsl:for-each select="$currentPage/ancestor-or-self::*[@isDoc]/descendant-or-self::*[@isDoc]
 [umbraco.library:HasAccess(@id,@path)  and string(naviHide) != '1' and 
(self::Nieuws or self::Pagina) and @level &gt; 0]">
      <xsl:sort select="@sortOrder" data-type="number" order="ascending" />
      <xsl:variable name="menuName" select="menuName"/>
      <li>
        <xsl:if test="contains(@nodeName, 'commerce')">
          <xsl:attribute name="class">menuHeaderCommerce</xsl:attribute>
        </xsl:if>
        <xsl:if test="contains(@nodeName, 'Meldpunt') or contains(@nodeName, 'point de')">
          <xsl:attribute name="class">menuHeaderMeldpunt</xsl:attribute>
        </xsl:if>
        <xsl:if test="contains(@nodeName, 'corporate')">
          <xsl:attribute name="class">menuHeaderCorporate</xsl:attribute>
        </xsl:if>
        <a href="{umbraco.library:NiceUrl(@id)}">
          <xsl:if test="contains(@nodeName, 'commerce')">
            <xsl:attribute name="class">menuHeaderCommerceA</xsl:attribute>
          </xsl:if>
          <xsl:if test="contains(@nodeName, 'corporate')">
            <xsl:attribute name="class">menuHeaderCorporateA</xsl:attribute>
          </xsl:if>
          <xsl:comment /><!--prevent self-close -->
          <span class="leftDiv"><!-- test -->&nbsp;</span>
          <span class="middleDiv">
            <!-- test -->
            <xsl:choose>
              <xsl:when test="$menuName != ''">
                <xsl:attribute name="title"><xsl:value-of select="$menuName"/></xsl:attribute>
                <xsl:value-of select="$menuName"/><xsl:comment /><!-- Prevent self-closing element -->       
              </xsl:when>
              <xsl:otherwise>
                <xsl:attribute name="title"><xsl:value-of select="@nodeName"/></xsl:attribute>
                <xsl:value-of select="@nodeName"/><xsl:comment /><!-- Prevent self-closing element -->
              </xsl:otherwise>
            </xsl:choose>
          </span>
          <span class="rightDiv"><!-- test -->&nbsp;</span>
        </a>        
         <xsl:call-template name="subItem" >
            <xsl:with-param name="parentPage"><xsl:value-of select="@id" /></xsl:with-param>
          </xsl:call-template>
      </li>
    </xsl:for-each>
    
  </ul>
</xsl:template>        

<xsl:template name="subItem">
<xsl:param name="parentPage" />
<xsl:variable name="parentLevel" select="umbraco.library:GetXmlNodeById($parentPage)/@level" />
<xsl:comment><!-- --></xsl:comment>
<xsl:if test="umbraco.library:GetXmlNodeById($parentPage)/@level > 1">
  <xsl:if test="count(umbraco.library:GetXmlNodeById($parentPage)/descendant::*[@isDoc
 and not (self::Website) and not(self::Event) and string(naviHide) != 
'1']) &gt; 0">
  <ul><xsl:comment />
    <xsl:for-each select="umbraco.library:GetXmlNodeById($parentPage)/descendant::*[@isDoc
 and not (self::Website) and (@level - $parentLevel = 1) and 
umbraco.library:HasAccess(@id,@path) and string(naviHide) != '1']">
      <xsl:sort select="@level"/>
      <xsl:sort select="@sortOrder" data-type="number" order="ascending" />
      <xsl:variable name="menuName" select="menuName"/>
      <li>
        <xsl:if test="$currentPage/@nodeName = @nodeName or ($currentPage/ancestor::*[@isDoc and not (self::Website)]/@nodeName = @nodeName)">
          <xsl:attribute name="class">active</xsl:attribute>
        </xsl:if>
        <a href="{umbraco.library:NiceUrl(@id)}"><xsl:comment /><!-- Prevent self-closing element -->
          <span class="leftDiv"><!-- test -->&nbsp;</span>
          <span class="middleDiv">
            <!-- test -->
            <xsl:choose>
              <xsl:when test="$menuName != ''">
                <xsl:attribute name="title"><xsl:value-of select="$menuName"/></xsl:attribute>
                <xsl:value-of select="$menuName"/><xsl:comment /><!-- Prevent self-closing element -->       
              </xsl:when>
              <xsl:otherwise>
                <xsl:attribute name="title"><xsl:value-of select="@nodeName"/></xsl:attribute>
                <xsl:value-of select="@nodeName"/><xsl:comment /><!-- Prevent self-closing element -->
              </xsl:otherwise>
            </xsl:choose>
          </span>
          <span class="rightDiv"><!-- test -->&nbsp;</span>
        </a>
      </li>
    </xsl:for-each>
  </ul>
  </xsl:if>
</xsl:if>
</xsl:template>

</xsl:stylesheet>