Contact person: Business Client

Phone:Show

Email:Show

Location: Dubai, United Arab Emirates

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"I am looking for someone who:

Has strong experience with CodeIgniter (legacy projects), MySQL/MariaDB performance, and PHP-FPM/Apache.

Can:

Read existing code and logs,

Identify all internal HTTP self-calls,

Optimize the critical queries and DB indexes,

Tame high-frequency polling endpoints like /noticnt,

Remove bad patterns like global SQL mode changing from PHP.

Works carefully in production:

No wild experiments directly on live without backups.

Explain what changes you plan to make.

Provide before/after timings (e.g., curl TTFB, reduced queries).

If you’re interested, please:

Mention similar performance optimization work you’ve done on CodeIgniter or similar LAMP stacks.

Propose a rough action plan:

Step 1: audit & confirm,

Step 2: fix internal curl + /noticnt polling,

Step 3: refactor heavy queries/indexes, etc.

I already have:

Access to server logs and code,

Clear pointers to problematic functions and routes (as listed above).

I need someone who can own the clean-up, make the application efficient, and stop the pattern where the site is fast after restart but then becomes slow again over time." (client-provided description)