Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Hii Jorge.
First of all - great package and tool, thanks.
I am try to profiling my site , built on umbraco 4.7.1.1 - update to 4.7.2 start with my top navigation and see that i have many of sql queries.
According to your blog post i am try to change it, but still..
When i do something like this :
var parent = @Model.AncestorOrSelf(); if (parent != null) { dynamic[] topChildrens = parent.Children.ToArray(); <ul id="topMenu"> @foreach (var item in topChildrens) { } </ul> }
it is work with out any queries.
but when add Where statment like this :
@foreach (var item in topChildrens.Where(x => x.showOnTopMenu == true))
It is make 213 queries. and mark most of them with - DUPLICATE
Is that ok?
Thanks in advance.
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
quistion about sql queries.
Hii Jorge.
First of all - great package and tool, thanks.
I am try to profiling my site , built on umbraco 4.7.1.1 - update to 4.7.2 start with my top navigation and see that i have many of sql queries.
According to your blog post i am try to change it, but still..
When i do something like this :
var parent = @Model.AncestorOrSelf(); if (parent != null) { dynamic[] topChildrens = parent.Children.ToArray(); <ul id="topMenu"> @foreach (var item in topChildrens) { } </ul> }
it is work with out any queries.
but when add Where statment like this :
It is make 213 queries. and mark most of them with - DUPLICATE
Is that ok?
Thanks in advance.
is working on a reply...