Date ranges are the key to a better index

0 min read 126 words

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.

Andrew
Andrew

Andrew is a visionary software engineer and DevOps expert with a proven track record of delivering cutting-edge solutions that drive innovation at Ataiva.com. As a leader on numerous high-profile projects, Andrew brings his exceptional technical expertise and collaborative leadership skills to the table, fostering a culture of agility and excellence within the team. With a passion for architecting scalable systems, automating workflows, and empowering teams, Andrew is a sought-after authority in the field of software development and DevOps.

Tags

Recent Posts