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
