I summed up 10 important points for me that needs to be considered during tuning your LINQ to SQL’s data retrieval and data modifying process:
1 – Turn off ObjectTrackingEnabled Property of Data Context If Not Necessary
2 – Do NOT Dump All Your DB Objects into One Single DataContext
3 – Use CompiledQuery Wherever Needed
4 – Filter Data Down to What You Need Using DataLoadOptions.AssociateWith
5 – Turn Optimistic Concurrency Off Unless You Need It
6 – Constantly Monitor Queries Generated by the DataContext and Analyze the Data You Retrieve
7 – Avoid Unnecessary Attaches to Tables in the Context
8 – Be Careful of Entity Identity Management Overhead
9 – Retrieve Only the Number of Records You Need
10 – Don’t Misuse CompiledQuery
Solution for the QlikView, Biztalk, DotNet and MSBI real time development problems
Search This Blog
Wednesday, May 6, 2009
Subscribe to:
Post Comments (Atom)
Popular Posts
-
The typical way of testing WCF services is to create a test project, add a service reference to the project, and then write a test agains...
-
.Net Integration with Bill Desk Payment Gateway Introduction: Now-a-days online shopping websites has become very popular, and to h...
-
. In the ASP.NET runtime the life cycle of a page is marked by a series of events. In ASP.NET 1.x, based on user interaction a page request ...
-
Qlikview developer, Designer and admin interview questions (Qlikview developer, Designer and admin FAQ’S) 1. Difference between Set ...
-
why use Windows Workflow Foundation? Microsoft has provided this foundation in order to simplify and enhance your .NET development. It is n...
No comments:
Post a Comment