This is again another broad topic, but here are a few useful tips:
- Optimize your report queries- you can use tools such as query analyzer and sql profiler to optimize your query. Database tuning advisor can suggest better indexes for your database.
- Look at the execution log table, see if you find anything running slow, it will help you determine what you need to optimize.
- Report caching: it allows temporary copies of a report to be stored and rendered to a user.
- Snapshot
- Execution Snapshot: is viewed from a report folder in report manager just like on-demand reports would be viewed.
- History Snapshot: Creates a report history and are viewed from the history tab of the report and can accumulate many copies.