Hi! I’m Pavel, a Software Engineer. Welcome to my website!
I’ve been developing software for over a decade, and recently I started sharing my experience, observations, and thoughts on how the world of software development really works.
If you are interested in C#, .NET, programming, system design, web development, software architecture, SQL, databases, and more, I believe you will find something useful and inspiring here.
In the first article in this two-part series, we analyzed the difference between copying using EF and copying using a stored procedure. Now, let’s see how much faster the stored procedure is and compare the performance of both approaches: ORM vs SP. Background If you haven’t read the first part of the article yet, I strongly recommend reading it here: Sp or Not Sp. You can find all the code from this article in the GitHub repository here: pavelgelver.com-articles/sp-or-not-sp-pt2. ...
Harmless-looking EF Core code can bottleneck performance. Let’s unpack why stored procedures might be better and how team habits play a role.