How Ugam Could Reduce its Query Execution Time using the Power of AWS
UGAM is a leading next-gen analytics company that relies on nodes and clusters to perform analysis and display results to its customers.
Challenges
- High execution time to resolve query in RedShift and display dashboard results due to the existing cluster architecture
- High filtered query time on its platform upto two minutes hampering the agile business approach
- High latency during queries and displays
Solution
- Created temporary tables
- To hold common results for all filters
- With proper sorting algorithms and distributed keys
- With a set up to recreate weekly after the data has been loaded
- Added more nodes to the cluster and ensured proper distribution of data among all nodes
Business Impact
A reduction in query execution time from 2 mins to 30 seconds which ultimately resulted in faster response to end customers accessing dashboards
more case studies
Driving Logistics Innovation with Searce & Google Cloud
Driving Logistics Innovation with Searce & Google CloudThis case study showcases how Searce empowered FRONTdoor Collective (FDC), a pioneering logistics ...
Yaantra partners with Searce & Google Cloud to help consumers with a single window stopover for smart gadgets in India
Yaantra partners with Searce & Google Cloud to help consumers with a single window stopover for smart gadgets in India ...
Xeno Runs Their AI Powered CRM Through the Infrastructure and Apps Hosted on AWS
Xeno Runs Their AI Powered CRM Through the Infrastructure and Apps Hosted on AWS IntroductionXeno is an AI-powered CRM that ...