Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

sql execute about 1s,but report run time 20s

I execute the sql which is copied from webi query in database, it take less than 1s.

There are 6 queries in report, so I assume the time used to retrieve data from DB is 6s.

and the report responding time is about 20s(from the moment I click "refresh data").

so there are 20-6=14s,including network transfer time,report server generate report time.

Could anyone tell me what can I do to optimize the performance? Normally the report

responding time can reduce to how many seconds?

Thanks in advance.


Tony Renjie

Not what you were looking for? View more on this topic or Ask a question