Describe a challenging software engineering problem you encountered in a previous project. How did you approach solving it, and what was the outcome?

In a previous project, I encountered a scalability issue due to a rapidly growing database. I approached the problem by analyzing query performance and implementing caching solutions, which ultimately improved response times by over 50%. My team and I also discussed migrating to a more scalable database architecture.