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.