Multi-Tenant SQL Performance Tuning
Budget: $30 – $250 USD
My multi-tenant web application has grown fast, and the SQL layer is now the bottleneck. Across all tenants I’m seeing sluggish page loads and time-outs, so the task is to raise overall database performance, with a spotlight on cutting query execution time for the entire schema rather than chasing a few isolated statements.
I will grant you read access to the production replica plus the relevant schema scripts. What I need back is a set of optimised queries and supporting changes that can be applied with minimum downtime. Feel free to bring whatever workflow suits you—EXPLAIN plans, indexing strategies, query refactoring, partitioning, or caching hints—as long as the end result is measurable speed gains visible in our existing monitoring dashboard (slow query log and New Relic APM).
Deliverables
• A before-and-after performance report for the tuned queries
• Updated SQL scripts or migration files ready for staging
I prefer American and European developers
David
I will grant you read access to the production replica plus the relevant schema scripts. What I need back is a set of optimised queries and supporting changes that can be applied with minimum downtime. Feel free to bring whatever workflow suits you—EXPLAIN plans, indexing strategies, query refactoring, partitioning, or caching hints—as long as the end result is measurable speed gains visible in our existing monitoring dashboard (slow query log and New Relic APM).
Deliverables
• A before-and-after performance report for the tuned queries
• Updated SQL scripts or migration files ready for staging
I prefer American and European developers
David