☄️ Master the Modular Monolith Architecture: [ Ссылка ]
📌 Accelerate your Clean Architecture skills: [ Ссылка ]
🚀 Support me on Patreon to access the source code: [ Ссылка ]
In this video, I'm going to be solving an EF Core performance optimization challenge. The goal is to optimize a poorly performing EF Core query and make it as fast as possible. My friend Stefan created the challenge, and there's still time to post your submission. How fast can you make this EF Core query?
You can find Stefan's EF Core performance challenge here:
[ Ссылка ]
Stefan's LinkedIn (follow him for great C# posts)
[ Ссылка ]
Join my weekly .NET newsletter:
[ Ссылка ]
Subscribe for more:
[ Ссылка ]
Chapters
0:00 What is the challenge?
1:55 Improvement 1: Upgrade .NET version
2:10 Improvement 2: Don't load the entire Authors table
3:31 Improvement 3: Limit the number of Authors returned
4:46 Improvement 3: Filter the Books
6:11 Improvement 4: Fetch only required columns
7:48 AsNoTracking discussion
9:14 Improvement 5: Sorting before projection
10:08 Improvement 6: Filtered Include
12:02 Improvement 7: Query Splitting
13:12 Improvement 8: Get lucky
![](https://i.ytimg.com/vi/jSiGyPHqnpY/maxresdefault.jpg)