Looking at the debug trace there's room for improving your queries in your razor macros as it's those that are slow. If you post some of your razor views, maybe someone could give you feedback on optimising those queries.

Hi David,

Why do you use XSLT Search ? maybe you can use your custom Examine Search ?

Thanks, Alexandr

Hey Niels,

My "Navigation.cshtml" looks like this:

@inherits umbraco.MacroEngines.DynamicNodeContext
@using umbraco.MacroEngines;
@{  
    var root = Model.AncestorOrSelf(1);
}
<ul class="nav navbar-nav">
@{ 
  var homeSelected = Model.Level == 0 ? " class=\"active\"" : string.Empty; 
}
@if(root.umbracoNaviHide == false) 
{ 
  <li @Html.Raw(homeSelected)>
    <a href="@root.Url">
      @root.Name
    </a>
  </li>
}
  @foreach (var item in root.Children.Where("Visible"))
  {
    var selected = Array.IndexOf(Model.Path.Split(','), item.Id.ToString()) >= 0 ? " class=\"active\"" : string.Empty; var subItems = item.Descendants().Where("Visible"); 

    if (subItems.Count() > 0 && item.contentDropDown == true)
    {
      <li class="dropdown"> 
        <a href="@item.Url" class="dropdown-toggle" data-toggle="dropdown">@item.Name 
          <b class="caret"></b>
        </a>
        <ul class="dropdown-menu">
          @** WHERE Level==3 LOADS ONLY THE CHILDREN OF THE 2nd LEVEL **@
          @foreach (var subItem in subItems.Where("Visible").Where("Level == 3"))
          {
          <li><a href="@subItem.Url">@subItem.Name</a></li>
          }
        </ul>
      </li>
    }else
    {
        if(item.umbracoNaviHide == false) 
        { 
            <li @Html.Raw(selected)><a href="@item.Url">@item.Name</a></li>
        }
    }
  }

And it takes approx. 1.17 seconds to load.. Have I completely misunderstood how to traverse the tree or?

Thanks so much for the help!

Hi david,

I think you have problem in this line

@foreach (var item in root.Children.Where("Visible"))

You call each node under rood. Try to specify your select before foreach. Something like that:

@foreach (var item in root.DescendantsOrSelf("YOUR DOC TYPE").Where("Visible"))

Hey Alex,

Hmm I can see where you are getting at, but yeah I'm having trouble selecting the specific doc type in the foreach.

Because of my structure, I have frontpage first, and under that, magazines, articles and more.. All these have different docTypes due to having different generic properties.. How can I select a specific doctype, if they are all different.. and is there any other thing to do other than calling Children? (if that is bad practice)

Could you show me your tree with doctypes? I'm sure that we will find solution together )

Thanks, Alex

Also you can create custom Examine index.

Hey Alex,

http://i.imgur.com/Txd7vkK.png

There it is, hope it can shet some light on whats wrong :/

Interesting structure. This all information do you need for start page ? We have to separate data somehow.

The reason Why I put all the content under Frontpage is only for it not to show in the navigation :-) It did that because I use ".Children", so had to do like Fronpage.Children to show the navigation..

How would you recommend that I proceed from here, while having it in mind that it should all result in faster performance :/?

Navigation items you can put in Cache. Fill that cache in application_start and than don't touch umbraco tree. What about other performanca issues ? Where do you have some bottleneck ?

Hey Alex,

Im not sure I understand what you mean with application_start?

Sure I can cache several macro's like the boxes to the right, the navigation, the footer and such.. But when the cache runs out, It's still really slow, and really it shouldn't be that slow for such a small site?,

Otherwise, actually all my macros are really slow, they are all between 1 and 2 seconds on load time each :/, thats why I suspect there might be something severely wrong some other place :/

is working on a reply...