Hello everyone! Today was a minor update, but did see quite a few changes to the database structure for our service.
One of the key drivers behind performance is being able to lookup and give information to the clients quickly, efficiently, and effectively. One of the biggest issues we’ve had with this is the notifications system.
You can imagine just how many notifications are sent across this application on a per hour basis, and as all of those notifications have to be stored, and served for people to see, we can have a very………VERY……….complex sql setup to serve them.
We have optimized the heck out of these notifications today, and they have begun to load quite a bit faster.
While that may not seem like much was done today, suffice to say, the notifications are loading quite a bit faster, the load on the SQL cluster is much lower, and the rewards load faster for everyone
Stick with us for more updates as we post them