ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How to improve entity framework performance with large of database?

user-image
تم إضافة السؤال من قبل Mohamed Elsokary , Senior .NET Fullstack / React , procoor
تاريخ النشر: 2016/10/13
Mohammad Altrkawi
من قبل 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
من قبل 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...

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟