Urgent PHP-MySQL Backend Fix

PHP, Website Design, MySQL, HTML, Database Administration, Backend Development, Database Design, Performance Tuning · My live rewards website is built on PHP with a MySQL database and the backend has suddenly started lagging. Pages that rely on database queries are taking far too long to load, even though I already have basic indexing in place. I need someone who can jump in immediately, profile the queries, trace the bottlenecks in the PHP code or schema, and implement solid fixes without disrupting current users.

Here’s what I expect from you: • Audit the existing queries and PHP logic that power the rewards flow. • Pinpoint the causes of the slow performance—whether that’s missing composite indexes, sub-optimal JOINs, or inefficient server-side processing. • Apply the appropriate optimizations (query refactoring, additional indexing, possible caching strategy) and validate gains with before/after metrics. • Keep the site online while you work and provide a concise hand-off report summarizing every change so I can maintain it moving forward.

If you’re comfortable diagnosing real-time performance issues on a production PHP-MySQL stack and can start right away, let’s talk—I’ll share full access details once we connect.