Скачать с ютуб 🚀 EF Core 8: How to optimize a query? в хорошем качестве

🚀 EF Core 8: How to optimize a query?

Do you want to make your queries more performant and efficient? Then this is the way you go! I've tried to address most cases in a Real-world query that you may face in your projects and fix them. If you saw my previous videos, I always like to explain the current situation and how to make it better, and finally code, I believe you grasp the concept better. Hope you enjoy it! Repo[EFQueryOptimization]: https://github.com/sa-es-ir/youtube-s... Moments 00:00 - Intro 00:26 - Showing the Slow query 02:45 - Check what query exactly is needed? 03:46 - Enabling EF core logs for queries 04:45 - Select only the required columns 09:21 - Decrease database roundtrips 10:49 - Remove extra Includes 11:32 - The worst thing a developer can do! 13:08 - Prefer checking numbers over strings 14:05 - Put conditions on the database side 15:33 - Use Pagination 16:10 - Run optimized query 17:30 - Optimize Contains method 21:25 - Optimize Database side 24:18 - Run the Benchmark! #dotnet #csharp #queryoptimization #efcore #entityframework --------------------------------------------------------------- Follow me on LinkedIn:   / sa-es-ir