2025 – 2026
Performance optimization
Performance optimisation of PHP and Python applications: SQL queries, algorithms, API response time.
- PHP
- Zend
- Python
- SQL
- JavaScript
The context
A legacy application (PHP / Zend / JavaScript / SQL) and an API (Python / SQL) in production whose response times and batch processing had become too slow.
Audit, profiling and then targeted rework of the bottlenecks in a legacy application and an API.
Key features
- SQL query optimisation
- Algorithm optimisation (sorting, data aggregation…)
- Auditing and profiling to identify bottlenecks
The result
API response time cut by 10× and batch processing cut by 3×, after auditing, profiling and reworking the SQL queries and algorithms.