Client: Tua Rádio

Technologies Used

• PHP (CodeIgniter Framework from 2012)
• MySQL Database Optimization
• Server-side Caching Strategies
• Query Performance Analysis
• Legacy Code Refactoring

Challenge

When I inherited Tua Rádio's multimedia news portal (built 2015/16 on top of a 2012 codebase) in 2017/18, it was in critical condition: homepage loading in 4-8 seconds, inefficient queries hammering the database, and servers at 60-80% CPU capacity with real risk of complete failure during peak traffic. Complete rewrite meant months of development, content migration, CMS retraining, and business interruption.

The challenge was delivering acceptable performance within legacy system constraints without starting over.

Implemented Solution

Applied surgical optimizations focused on critical bottlenecks using 80/20 rule: attack the 20% of code responsible for 80% of problems:

• Query Optimization: Rewrote problematic queries that fetched unnecessary data, performed overly complex joins, or repeatedly executed for cacheable information. Restructured database access to minimize data volume and request quantity
• Strategic Caching Layers: Implemented memory caching for rarely-changing content (category structures, columnist information, programming data), eliminating repetitive database hits
• Progressive Page Rendering: Restructured rendering logic to prioritize above-the-fold content, loading visible elements first and deferring secondary elements
• Targeted Code Refactoring: Focused exclusively on high-impact areas rather than polishing code that already performed adequately

All interventions delivered immediate value without interrupting operations or requiring team retraining.

Results / Impact

• Reduced homepage load time from 4-8 seconds to acceptable levels
• Decreased server CPU usage significantly, moving out of critical 60-80% zone
• Eliminated risk of system crashes during peak traffic hours
• Maintained consistent performance as platform aged and accumulated content
• Improved user experience and reduced bounce rates
• Significant cost savings compared to complete system rewrite

Why it matters

This project demonstrates a middle path between maintaining struggling legacy systems and investing fortunes in complete modernization. Performance doesn't necessarily come from new frameworks — it comes from intelligent technical decisions about how data flows through the system, identifying real bottlenecks and applying surgical improvements focused on concrete problems.