.net - Entity Framework Includes -

-

is there recommended maximum amount of .include statements use in entity framework query.

i think read somewhere microsoft recommends no more 3 cant find source.

thanks in advance.

see performance considerations entity framework http://msdn.microsoft.com/en-us/data/hh949853.aspx (p 8.2.2) :

it takes relatively long time query multiple include statements in go through our internal plan compiler produce store command. majority of time spent trying optimize resulting query. generated store command contain outer join or union each include, depending on mapping. queries bring in large connected graphs database in single payload, acerbate bandwidth issues, when there lot of redundancy in payload (i.e. multiple levels of include traverse associations in one-to-many direction).

i suggest use sql profiler or ef profiler (f.e. efprof) can performance issues


Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more