Case Study: CleanLink achieves faster, more reliable payroll processing with Lambert Labs

CleanLink cuts payroll processing time by 90% with Lambert Labs

CleanLink, a UK-based provider of site management software for the contract cleaning industry, faced significant performance challenges with its Amazon RDS SQL Server database. During peak monthly payroll periods, high-volume data processing clashed with thousands of concurrent user logins on its CleanLink Portal, leading to database lock contention, CPU saturation, and processing failures. The company partnered with Lambert Labs to resolve these bottlenecks without disrupting its essential payroll services for over 60,000 users.

Lambert Labs implemented a solution that enabled Read Committed Snapshot Isolation (RCSI) to eliminate lock contention and refined the logic of AWS Lambda functions to process data in smaller batches. This optimization, along with strategic infrastructure advice, drastically improved platform stability. The results included a 90% reduction in payroll processing time and the ability to successfully process 11,000 individual payslips within a 30-minute period with zero performance issues, providing a stable foundation for future growth.

CleanLink