Case Study: Ugam reduces query execution time with Searce on AWS

A Searce Case Study

Preview of the Ugam Case Study

Ugam cuts query execution time from 2 mins to 30 seconds with Searce

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.


View this case study…

Searce

204 Case Studies