Searce
204 Case Studies
A Searce Case Study
Ugam, a next-gen analytics company, faced significant challenges with its data platform. The company experienced high query execution times in its Amazon Redshift cluster, with latency of up to two minutes that hampered its agile business approach and delayed the display of dashboard results for its customers. Searce was engaged to address these performance issues.
Searce implemented a solution that involved creating optimized temporary tables with proper sorting and distribution keys, which were recreated weekly. They also added more nodes to the Redshift cluster and ensured data was properly distributed across them. This work by Searce resulted in a substantial reduction in query execution time, from two minutes down to just thirty seconds. This improvement provided a faster response time for Ugam's end customers accessing the dashboards.