Monday, 3 February 2014

Slow loading Advanced Reports?

Over the past few weeks, we've discovered that some Advanced Reports were "hogging" the system and slowing performance. Additionally, these reports were being sent out twice or thrice daily...

As an example, a report was generating about 19,000 rows with 24 columns of data - that is about 456,000 data items in one single report! The resulting Excel file was a few megabytes in size and was being sent out daily.

Upon investigation, we found that the filters for the subscription were set incorrectly, thereby causing large amounts of data to be included in the report.

With the latest update of TrakIT (released last Saturday), we've included a way to measure how long a report takes to generate. Under the Advanced Reports subscriptions, you will see a column "Last Gen" that indicates the number of seconds that the report took to generate the last time it was sent or manually generated.

We've also added a filter for system admins to identify long running reports. Take a look at this screenshot:


The "Generation Time" filter is currently visibly only to System Administrator - but it will be made available to all admins shortly.

We recommend you go through your subscriptions to see how long the last report took to generate. If you find the figure missing, it will be updated the next time your report is sent out.

For any questions or clarifications, please contact TrakIT Support.




No comments:

Post a Comment