How to improve our entity framework core query performance
1. Disable change tracking for read-only queries.

2. Use DbContext pooling.

3. Use IQueryable instead of IEnumerable

4. Use batch updates for large numbers of entities.

5. Use asynchronous instead of synchronous code.

6. Reduce the round trips to the database.

7. Caching in .NET Core.

8. Retrieve only the data you need.

9. Raw SQL queries.

10. Profiling and Monitoring.

11. Paging Implementation.

12. Indexing Implementation.

Last updated