Need tips to improve the report performance

[umareddy0706]

Hello Everyone,

I have a report with 60 prompts( most of them are optional) and in the report page, I have list report with 120 columns.

Issue: Report is running very slowly. It is taking 20-25 minutes for execution. My client wanted to improve the performance.

Please advise me to improve the performance of the report.

Regards
Mahesh.

[raj_aries81]

Hi Mahesh,

Pl include more details. Did you check things like volume of data...query execution time on DB etc. Instead of adding all the prompts, I think it would be better to adopt a phased approach by adding 8-10 prompts each time and then running the report to check the report performance.

Regards
Raj

[rameshB]

hello Mahesh,
1. identify the fields/columns that are taking long time at time for execution of report.
2. Ask database team create index on that particular column name.
3.check the execution time from the database end before running the report in report studio.

regards,
Ramesh

[srinu_anu2007]

Hi,

Try to use Processing Property(goto Queries->goto properties->Processing->select Database Property

Try this one.

Thanks,