Tuning Reports in General

In general, I used to follow these steps for tuning in reporting level.

In Query Properties:

• If you are using multiple queries associated with layout then set “Execution method as Concurrent”
  By default Execution method will be sequential ,Hence every query will executed one by one. Setting sequential to concurrent, Query will executed concurrently (parallel) and it won’t wait until first query’s execution.

Note: It doesn’t mean setting Execution Method to Concurrent will always gives better performance! , It may vary with peak/Normal hours & some cases will give better performance on setting the sequential .This will depends up on the Number of queries, joins, etc… Used and associated with layout.

Hello World

Hi All It’s my first post … Welcome to my World