An application is currently using an encrypted Amazon RDS for MySQL DB instance to store personal health information (PHI). The developer aims to enhance the application's performance by implementing a caching mechanism for frequently accessed data. Additionally, the developer wants to include functionality to sort or rank the cached datasets. Given the requirement that the PHI must remain encrypted at all times, what is the optimal approach to achieve these goals?