ef core and sql query performance
i reproduce the affected screen or api request and inspect measurements such as query count and duration. unnecessary reads, tracking, pagination and index use are possible review areas.
i review code and databases to identify issues and prioritize them by their impact on business processes. i verify fixes and performance improvements with tests, and report changes and measurable results.
let’s discuss your projecti offer review and improvement support for slow screens, recurring errors or a .net application that has become difficult to maintain. code and database review, prioritized findings and agreed fixes can be planned as separate deliverables.
we first define the review question and access boundaries. performance work starts with a baseline and compares the result after changes under the same data and conditions. the report includes findings, changes and measurement limits; an improvement percentage is not promised before review.
.net · sql server · postgresql · nunit / xunit
i reproduce the affected screen or api request and inspect measurements such as query count and duration. unnecessary reads, tracking, pagination and index use are possible review areas.
i review the areas requiring changes, error handling and test coverage. findings are ordered by business impact and implementation effort in a practical improvement list.
i establish the conditions of the failure and expected behavior. a repeatable check verifies the fix, with related workflows reviewed for unintended effects.
share the affected operation, reproduction steps, .net and database versions and business impact. examples with personal data removed are enough to start. any required technical access is agreed after the scope is clear.
my experience at turkmen holding covers c#/.net backend development in existing monolithic textile erp modules. you can also inspect my personal project source and technical articles.
recognize n+1 queries, early materialization, unnecessary tracking, growing joins and deep pagination through an order list you can run locally.
silent ef core performance killers and how to fix them ↗share your requirements, existing system and target date. we can assess the scope and working model that suit your project.