Comments (2)
Hi @stevensrf11, It won't be down to the generator. Use SQL Profiler
to look at the query being executed on your database and compare it to the one you manually run.
After you capture the SQL being executed, paste it into SSMS, and substitute any parameters so you are back to raw SQL. Then press CTRL-L
to view the query plan in SSMS. You should see what makes the call expensive, and SSMS should show you any index recommendations to speed it up.
It's usually pulling back far too much information, or too many .Include
statements. Oh, and the worst is an OR
clause in the query, in that case you are better off using two separate queries (one for each side of the OR
clause) and join the data together.
You can speed up EF if you are not going to modify any of the data by including .AsNoTracking()
as part of your linq query. More info here on AsNoTracking.
from entityframework-reverse-poco-code-first-generator.
from entityframework-reverse-poco-code-first-generator.
Related Issues (20)
- Add support for EF Core 8 HOT 1
- Query Filters (Global Query Filters) HOT 1
- Add "IsSynonym" property to Table class HOT 3
- edmx not refreshing after add stored procedure HOT 1
- Table wich name contains a dot gets ignored HOT 1
- Unable to call scalar function
- Error when using connection string with Authentication property. HOT 1
- HasDefaultValue() HOT 2
- Stored proc with multiple returns HOT 3
- Selecting from temporary table HOT 2
- Add more Data annotations HOT 1
- Selecting from temporary table returning "int" instead of the result table. HOT 2
- Sqlite Code Generation fails HOT 6
- how to add interceptor? HOT 3
- Add QuerySplittingBehavior
- allow multiple enums from a single table HOT 3
- Upgrade from v3.X.X to v3.Y.Y HOT 2
- Sorter & Sorters tables
- Check if connection is already open for stored procedure calls
- POCO Generator from MSSQL Server to Postgress Compatible classes ? HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from entityframework-reverse-poco-code-first-generator.