The Mines of Moria — digging deep, without waking the Balrog
SQL optimisation and batch processing
SQL query optimisation to improve site performance, then batch processing to handle substantial data volumes.
- Technologies
- SQL
- MySQL
- PHP
- Symfony
- Doctrine ORM
The work began during my apprenticeship, on the e-commerce solution: identifying the slowest SQL queries and optimising them to improve site performance.
In my current role it widened to volumes: batch processing was introduced to handle substantial data sets, with query optimisation continuing alongside.