Optimize MySQL Queries & Download Speed
Budget: ₹1,500 – ₹12,500 INR
My web portal is healthy in most areas, yet two bottlenecks keep users waiting: slow MySQL queries and painfully long ZIP-file downloads. The database is MySQL, and every sluggish request is traceable to queries that read large tables without the right indexes or caching strategy. Once the data finally returns, the app streams the results into ZIP archives, but the transfer rate is still far from ideal.
Here is what I need:
• Analyse the current query patterns, execution plans and schema to pinpoint the worst offenders.
• Refactor or rewrite those queries, add or adjust indexes, and introduce sensible caching so average query time drops to an acceptable threshold.
• Audit the ZIP generation and delivery workflow (server settings, compression level, chunking, HTTP headers, etc.) and implement tweaks that cut download time dramatically.
• Provide a short before-and-after report with the main metrics, scripts or configuration changes, and clear rollback notes.
You will be working directly on a staging clone, so nothing mission-critical goes down. As soon as the new benchmarks prove the gains, I will push the changes to production.
Here is what I need:
• Analyse the current query patterns, execution plans and schema to pinpoint the worst offenders.
• Refactor or rewrite those queries, add or adjust indexes, and introduce sensible caching so average query time drops to an acceptable threshold.
• Audit the ZIP generation and delivery workflow (server settings, compression level, chunking, HTTP headers, etc.) and implement tweaks that cut download time dramatically.
• Provide a short before-and-after report with the main metrics, scripts or configuration changes, and clear rollback notes.
You will be working directly on a staging clone, so nothing mission-critical goes down. As soon as the new benchmarks prove the gains, I will push the changes to production.