Optimization of Database Performance for Unmaze

After successfully setting up the Cloud Architecture for the Unmaze English Learning Platform, the company again required my services to address a database scalability issue. During peak times, the database ran out of memory, leading to system instability.

I investigated the code and database queries and found that the root cause was some transactions not being properly closed. To enhance performance, I optimized the database queries in key flows abstracted by an ORM and reviewed the database indexes to ensure they were efficient.

After that, the database ran smoothly on a Compute Engine instance without the need for a managed database service, which would have increased the cost.