Performance - Do you schedule snapshots of slow reports for quicker access?

Loading last updated info...

A report should never take more than 30 seconds to run. Slow reports frustrate users, and also take valuable server performance away from the report server.

When dealing with slow reports, it is a good idea to setup scheduled snapshots. As an example, you would schedule a long running report to create a snapshot at night when the server is idle and not under a lot of stress. We recommend creating new snapshots every night so that the information displayed in the reports is never more than 24 hours old.

As an example:

Do create a snapshot for a sales summary Do not create a snapshot for an invoice report

For information on setting up scheduled snapshots see the following KB article

Image

Figure: Create a scheduled snapshot of slow reports to improve performance

Authors

Need help?

SSW Consulting has over 30 years of experience developing awesome software solutions.

We open source.Loving SSW Rules? Star us on GitHub. Star