![critical ops leaderboard critical ops leaderboard](https://img.game-news24.com/2021/11/Elyon-takes-down-its-Halloween-decorations-and-bring-up-a-leaderboard-event.jpeg)
To power real-time analytics, Rumble needed a low-latency option.
#Critical ops leaderboard full#
![critical ops leaderboard critical ops leaderboard](https://ignmlb68389855.files.wordpress.com/2020/07/image-75.png)
Rumble needs to deliver real-time, data-driven applications to meet those needs. Being able to instantaneously see their steps and purchase coupons from companies because of their healthy habits encourages them to maintain their active lifestyles. Eventually, it runs out of CPU and memory.
![critical ops leaderboard critical ops leaderboard](https://assets.website-files.com/5e309cb040e541771ba50cef/5e309cb040e5418c75a50de5_Leaderboard_Hero%402x.png)
At around 20+ requests per second, PostgreSQL becomes unable to maintain the latency required to serve the leaderboards. The evenings are usually their peak times, with a high number of concurrent queries, and this is where the application responsiveness declined. As user growth started to increase, PostgreSQL performance began declining. Since they have high engagement with their users, maintaining the platform performance is vital. Rumble displays the leaderboards in real-time to users and also engages with them when new companies and coupons are available by sending them notifications. To offset the compute, they preaggregated daily steps into weekly and monthly data, resulting in the three tables. However, this became very compute intensive due to the large number of queries. They originally computed the weekly and monthly steps from the daily collection.
![critical ops leaderboard critical ops leaderboard](https://i.ytimg.com/vi/2pB6c7HfDHs/maxresdefault.jpg)
A new row is added every day to the daily table, weekly to the weekly table, and monthly to the monthly table. There are three different tables that track the user’s steps: daily, weekly, and monthly. Rumble originally used PostgreSQL to handle data comprising users’ step counts. From there, users can make purchases to unique products or services at hundreds of shops and websites like cafes and stores.Įncountering Performance Challenges with User Growth Rumble, an Israeli company, is building applications to encourage and inspire people to maintain healthy daily habits by converting the user’s steps to reward coins. However, people tracking daily activity levels for casual or semi-competitive reasons have never received the same fanfare as those who track to compete-no medals, post-race swag, or high-fives. These smartwatches have helped people train for races, track different types of workouts, and be mindful of how much movement they are getting in a day. Purchases for smartwatches that track calories and activities have dramatically increased since 2014. Many of us have become more conscious about how much activity we’re getting in a day-and it shows.