TCP Software offers a workforce management software system that helps organizations optimize operations and streamline processes. Governments, hospitals, restaurants, and other entities use TCP’s time tracking and employee scheduling software to easily manage employee work schedules, time off, and payroll.
The Challenge
In early 2022, TCP identified lagging performance with one of its software products. Queries and datasets running against the product’s Amazon Relational Database Service (RDS) instances were running significantly slower compared to comparable queries and datasets running against EC2 instances.
However, improving these performance issues wasn’t enough work to justify hiring a full-time database administrator.
TCP needed a project-based expert to improve the performance of RDS deployments. This professional would need to be fast, efficient, and experienced working with databases operating in the AWS cloud, and TCP needed them to get to work as soon as possible.
The Solution
Within three days, NerdRabbit connected TCP with the AWS professional they ended up hiring for their project. The expert recommended RDS best practices to improve performance in just 80 hours of work.
The Benefits
The contract database administrator suggested changes to TCP’s code base that significantly improved performance in RDS. They reduced the number of queries and made changes to the indices on their existing tables, improving the speed and scalability of data retrieval queries.