Date Ranges Are the Key to a Better Index


Since AO Analytics originally went live in February 2013, we have been doing focused around individual time based reporting, it worked well and we were able to sort through indexes without doing full table scans.

After much feedback from our users as well as data usage patterns we made the decision to move to date ranges.

This replaced our entire retrieval algorithm and therefore copious amounts of work had to go into regression of backward compatibility while introducing the new way of moving forward with the overall system.

We feel everything went well and our User Interface currently uses the ‘new and improved’ version.

As always, we welcome feedback, whether it be positive or negative, so give it a try and tell us what you think.