DevForce Community Forum : Navigation Properties slowing down query http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Navigation Properties slowing down query Mon, 13 Apr 2026 20:39:29 -700 Fri, 03 Jun 2011 00:42:07 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2740 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Navigation Properties slowing down query : Are you developing in WPF... http://www.ideablade.com/forum/forum_posts.asp?TID=2740&PID=10888#10888 Author: pompomJuice
Subject: 2740
Posted: 03-Jun-2011 at 12:42am

Are you developing in WPF or SL?

Navigational properties in SL are loaded asynchronously (WPF might be sync?). Therefore, if you pump those query results into a DataGrid with auto generate fields set to true, it would definitely do async fetches on all those nav properties because the DataGrid is touching them. Whatever the case, something in your code is trying to view those nav properties!

If this is your scenario then you could speed the process up by Include(ing) the nav properties from the get go, saving you the time those individual async/sync fetches would have taken.

W



Edited by pompomJuice - 03-Jun-2011 at 12:44am]]> Fri, 03 Jun 2011 00:42:07 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2740&PID=10888#10888 Navigation Properties slowing down query : I have this query:var query... http://www.ideablade.com/forum/forum_posts.asp?TID=2740&PID=10883#10883 Author: gregweb
Subject: 2740
Posted: 02-Jun-2011 at 7:10am

I have this query:
 
var query = this.EmailEntityManager.EmailFolderEntities.Where(a => a.EmailAccountId == this.CurrentEmailAccount.Id).Where(a=> a.Visible == true).Where(a => a.IsDeleted ==false);
 
 
EmailFolderEntities has several navigation properties such as EmailAccount and ChildFolders.   When the query executes, these navigation properties are being populated.  The issue with that is that it slows down the query dramatically - like from a second or two to 10 seconds.  If I delete the navigation properties, then the query speeds up again.
 
I thought that the navigation properities would not be populated unless there was a specific "Include" statement in the query such as
 
var query = this.EmailEntityManager.EmailFolderEntities.Where(a => a.EmailAccountId == this.CurrentEmailAccount.Id).Where(a=> a.Visible == true).Where(a => a.IsDeleted ==false)
.include("EmailAccount");
 
 
Greg
]]> Thu, 02 Jun 2011 07:10:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2740&PID=10883#10883