Another fun week!!!
This week was mainly a maintenance week yet again. One of the bigger things I worked on was improving the efficiency of the event tracking system. Reports were taking anywhere from 45 seconds to 10 minutes or more to pull up. This didn't matter too much when I created the system because emails were automatically being sent with a report attached to them...
The same doesn't hold true once people request to have their own reports with their own data. These reports are created on demand. This means that the user must wait to pull the actual report up. Waiting 10 minutes just isn't acceptable. I set out to fix it... I rewrote some queries, improved several functions that give us data and recreated the tables with indexes. It took me a while to do all this but the end result is amazing. One report that pulls around 1000 students' information originally took around 11 minutes. After rewriting and optimizing the exact same report takes 4 seconds.
That's a huge improvement.
No comments:
Post a Comment