Performance Tuning in Entity Framework Core 5 and AspNet 5

When to use AsNoTracking() and how to optimize Entity Framework for performance

1. Think about what data you need or you might need in the future and select only the data that is needed. Avoid a bad practice of just selecting all the data inside a table, this will hurt the performance of the application, instead identify the columns and data needed for the operation to take place. 

2. If possible, use IQuerrible to able to sort and filter the data, that way it won't be only one set of dataset needed for a page to load

3. Identify code Hot Path, (instruction the app executes while it returns the response) and optimize for performance. This includes the data that is returned.

If possible do your complex computation and calculations and store them in the database. This can be achieved by scheduling a job that mainly deals with Calculations and inserts into the table.

This way, the Hot Path can only do the "reads" and able to return the response as quickly as possible. With the coming of Http/3, this might not be an issue, but it does not hurt to optimize for performance.

5. Use AsNoTracking() only when you don't need to update the data at some point.

For example: 

    If you're only reading from the database and sending the data to the UI and not doing immediate updates, this way it is okay to use AsNoTracking(). However, if you retrieve data using AsNoTracking() somewhere in your Linq query and then you try to modify the data (entities) then that way you are doing something wrong.

[NB] It takes longer to query the data using AsNoTracking() and then modify the data than just not using AsNoTracking() because that way if you want to modify the data, the Entity Framework will track all records and try to speed up the updates (Updates happens in ranges).

6. Never call _context.SaveChanges() inside a for-loop or a foreach-loop. Calling the database in O(n) might slow down your application. Instead, do the operations on the records retrieved from the database and then call _context.SaveChanges() outside the loop.

This way the operation will run faster and when it comes time to save changes using _context.SaveChanges() outside the loop, EF Core 5 would have tracked all the changes inside a loop and then commits only once.

Overall Application Performance Tuning

1. Run Performance Profiler Analysis on your application and see the performance report.
     - You should always strive for less Garbage Collection in your application. 
     - Pay attention to how you allocate memory or the way you create objects. Minimize Object creation outside Methods/functions as these objects get created globally and might cause a GC to happen.


Performance tuning in EF Core 5 5 .NET 5 published
Was this page helpful?
Yes Yes! this solution to the problem was helpful. No No! this solution to the problem was not helpful.. Leave ErnesTech Feedback.Feedback

Other users would like to know if this solution helped you.

Your Session is Ending
Login to Continue

© 2021 - ErnesTech - Privacy