Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to improve entity framework performance with large of database?

user-image
Question added by Mohamed Elsokary , Senior .NET Fullstack / React , procoor
Date Posted: 2016/10/13
Mohammad Altrkawi
by 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
by 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

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.