Panagen, improving the performance of static site generation
Reducing the static site generation time from Panagen, a custom software property of Panaworld.
Reducing building time of Panagen
A team of developers from Panaworld created their own solution using the PHP language. This software was a tool for building heavy static sites at compile time, reducing the costs of having a lot of execution time load in production machines.
This software was still Beta. It was used for a secondary product of the company. They asked me to debug and optimize all the aspects of the code: Algorithms, unnecessary loops, SQL queries...
Panagen root folder
In addition to removing unnecesary loops and improving sql queries... the greatest performance improvement I achieved was creating the proper SQL Indexes and adapting the queries helping the storage engine to use them.
Prior to optimization, Panagen took almost one hour in order to build 8 different websites, including the deploy time. After my work was done this task only took 15 minutes.
Private Project Notice
Disclaimer: This project is confidential. As a result, I am unable to provide access to the complete source code, but I can share images or small code snippets for demonstration purposes, with the owner's permission. However, if needed for an interview, I may be able to grant access to the private repository where this code or a copy of it is stored.