EF Core Performance Optimization Challenge | 233x FASTER

☄️ Master the Modular Monolith Architecture: https://bit.ly/3SXlzSt
📌 Accelerate your Clean Architecture skills: https://bit.ly/3PupkOJ
🚀 Support me on Patreon to access the source code:   / milanjovanovic  

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:
https://github.com/StefanTheCode/Opti...

Stefan's LinkedIn (follow him for great C# posts)
  / djokic-stefan  

Join my weekly .NET newsletter:
https://www.milanjovanovic.tech

Subscribe for more:
https://www.youtube.com/c/MilanJovano...

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