I will optimize your sql server database and fix slow entity framework queries


About this gig
Is your .NET app slow because of the database? I fix that.
Im a backend developer who works with C#, ASP.NET Core, Entity Framework Core and SQL Server. I find the queries and EF Core patterns that slow your app down and fix them, so your pages and APIs respond faster.
What I can do:
- Find and fix slow queries and N+1 problems in EF Core
- Index analysis and execution plan review
- Stored procedure tuning
- Rewrite heavy LINQ queries
- Review your schema and relationships
- Fix migration and EF Core configuration problems
How it works: you send the code and a short description of what is slow. I measure first, fix the biggest problems, and send a short report with before and after timings so you can see the improvement.
Please message me before ordering with your .NET version and a short description of the problem, so I can recommend the right package.
Get to know Mohamed Sami
ASP NET Core Backend Developer, REST APIs, SQL Server, Stripe and JWT
- FromEgypt
- Member sinceMay 2018
- Avg. response time1 hour
- Last delivery1 year
Languages
English, Arabic, Spanish, French
My Portfolio
Other Software Development Services I Offer
FAQ
What do you need from me to get started?
The code (repo access or a zip), your .NET and EF Core versions, a description of what is slow, and the database schema without sensitive data.
Can you optimize SQL Server queries and stored procedures, not only EF Core?
Yes. I work on SQL Server queries, indexes and stored procedures as well as EF Core and LINQ.
Do you need access to my production database?
No, and please never send production passwords. The schema, a small sample of non-sensitive data, or the slow queries and execution plans are usually enough.
Will you fix the problems or only tell me what is wrong?
Both. I make the fixes in your code and send a short report with before and after timings. If something needs a major rewrite, I will tell you honestly first.
Do you guarantee a speed-up?
I can’t promise a number because it depends on your data and setup. I measure before and after and show you the results. If I find nothing to improve, I will tell you.
Which databases do you work with?
SQL Server with EF Core. If you use another database, message me before ordering.