cancel
Showing results for 
Search instead for 
Did you mean: 

Urgent: WAD performance is very slow than query performance

Former Member
0 Kudos

Hi,

If i execute the report(using query with variables) which contains 8,50,000 records in WAD then its taking more than 900 seconds and say Connection timed out at the end.

If i execute the same query in Query designer using Web browser then it will take 400 seconds to show all the data in hierarchy or tabular view.

I've done tuning using RSRT on query read mode and persistent mode etc..

Can you please help me?

THanks in advance. Points will be given...

Reg,

Varun

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Varun,

Did you ever solve the performance issue of WAD report. We are having the same issue of WAD performance lot slower than executing just as a Query.

Thanks