Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How to improve entity framework performance with large of database?

user-image
Question ajoutée par Mohamed Elsokary , Senior .NET Fullstack / React , procoor
Date de publication: 2016/10/13
Mohammad Altrkawi
par Mohammad Altrkawi , Technical Team Leader , AESSCO

Improving the performance of EF for big databases starts with designing and normalizing your DB as good as it could be. Then, you have to manage EF configuration based on your requirements, specially the configuration related to Lazy Loading and Proxy Creation. Kindly refer to this useful post on Stack Overflow: Is EF really production ready for large application?

Salem Al Badawi
par Salem Al Badawi , Web Developer , Electronic Company for High Technology

there are several steps you can improve the performance 

1)avoid to put all DB object in one single entity model  

2)Disable change tracking for entity if not needed

3)Use Pre-Generating Views to reduce response time for first request

4) Avoid fetching all the fields if not required

5)Use Compiled Query wherever needed

6...

More Questions Like This