☄️ 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: https://www.patreon.com/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/OptimizeMePlease Stefan's LinkedIn (follow him for great C# posts) https://www.linkedin.com/in/djokic-stefan/ Join my weekly .NET newsletter: https://www.milanjovanovic.tech/ Subscribe for more: null 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