Speed up slow SQL queries and reports (PostgreSQL / MS SQL) by Yeldos SozakbaySpeed up slow SQL queries and reports (PostgreSQL / MS SQL) by Yeldos Sozakbay
Speed up slow SQL queries and reports (PostgreSQL / MS SQL)Yeldos Sozakbay
Slow reports, timeouts, high database load? In production I made a key report 7x faster, from 15 s to 2 s.
What's included
• Analysis with execution plans
• Rewritten queries, missing or composite indexes, removal of unused ones
• Before and after timings
• Recommendations for the application code (EF Core or ADO.NET)