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

KNOLSKAPE: Helping to transform talent with the performance and scaling power of Google Cloud

24%

savings on infrastructure costs with Google Cloud Platform

Technology Google Cloud

To put a stop to 'fake news', Logically partners with Searce to scale cost-effectively with Preemptible Virtual Machines on Google Cloud

10x

increase in infrastructure capacity with Google Preemptible Virtual Machines

Digital Natives Google Cloud

inshorts: Delivering mobile news solutions with Google Cloud to serve Indian readers better

4x

increase in speed of product cycle

Media & Entertainment Google Cloud
explore more