• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 64
  • Last Modified:

Are there any performance considerations for large Entity Framework Models/Contexts?

Are there any performance considerations for large Entity Framework Models/Contexts?
Are many smaller contexts faster / better than one large of the same database? or vice versa?
And why?
0
itnifl
Asked:
itnifl
  • 2
1 Solution
 
arnoldCommented:
If I understand your question, deals whether it is better to have a single large table versus multiple.
There is a balancing deals with minimizing storage while maximizing valuable data.
A single contex thas many duplicate information consuming storage space.

The trade off deals with query And complexity......
0
 
itniflAuthor Commented:
Entity Framework models are not related to sizes of tables.
I have researched the topic, and it seems that the model size can affect the speed of the queries and usage of the EF context. Mostly one time per application domain, but also at certain steps in the process at every query request.

I would however be interested in how much the model size affects query execution for each different version of Entity Framework.
0
 
itniflAuthor Commented:
Found the solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now