Database Optimization for Speedy Reporting
Exactly one year ago we launched the Revive Adserver Hosted edition, and the first customers started subscribing to our service. In that first year, we’ve had close to 350 new customers joining our service (and of course some of them have unsubscribed as well). As a result, the database of the Hosted edition has grown considerably. While this is technically not a problem, it does impact the user experience to some extent.
There are now many active customers, and most of them have a large set of sites and/or campaigns. This has resulted in the size of the overall database – and in particular the tables where those statistics are stored – to become pretty large. As a result, it can sometimes take longer than people hope for their reports to appear on the screen. We understand the importance of being able to quickly review the statistics of your campaigns and your sites. So we set out on a project to improve this aspect of the end user experience.
Based on our analysis, it is clear that while users frequently review statistics for a longer date range, they almost never drill down to the hourly detail level for statistics older than a few months. For this reason, it is a common practice in our industry to reduce the level of detail for older statistics. Now, on the 1 year anniversary of the launch of the Hosted edition, we are announcing that we’ll start doing that as well.
Starting in January 2020, we will be aggregating data older than 100 days. The data will be summed by day, for every combination of a banner and a zone, instead of by hour. This will result in a reduction of the number of database rows for the older statistics by about 95%. Overall campaign statistics won’t be affected, of course. For older data, when a user reviews the statistics by hour, they will notice that a day’s worth of numbers is always reported on the first hour of that day.
Get started now
Subscribe now to get your account on the Revive Adserver Hosted edition