nethermit
asked on
Generating report is sluggish
Does anybody know why does it take less than 5 seconds to pull, for example, 15,000 rows of data in the query but it would take at least 30 seconds to render and generate a report with the 15,000 rows of data? Well, it will be especially slower when graphs and charts are involved.
We tried to cache it to run daily at a specific time, which resolves the issue but clients are not able to view the 'latest' report at current time.
So, is there a way to tweak or configure so the rendering process is quicker?
Looking forward to your opinions. Thanks!
Rgds.
We tried to cache it to run daily at a specific time, which resolves the issue but clients are not able to view the 'latest' report at current time.
So, is there a way to tweak or configure so the rendering process is quicker?
Looking forward to your opinions. Thanks!
Rgds.
ASKER
By default my query is set to
Select TOP (100) PERCENT...
I did, however, try SELECT TOP (1000)...
The query above returns with data in no more than 2 seconds in MSS Management Studio. In Reporting Services, when generating a table report it is much faster. But it has taken 35-50 seconds per chart to render.
When uploading to Sharepoint as web part, it got sluggier .. up to a minute a chart.
Anyone has any similar experience? Was a solution found to overcome sluggish report generation?
Select TOP (100) PERCENT...
I did, however, try SELECT TOP (1000)...
The query above returns with data in no more than 2 seconds in MSS Management Studio. In Reporting Services, when generating a table report it is much faster. But it has taken 35-50 seconds per chart to render.
When uploading to Sharepoint as web part, it got sluggier .. up to a minute a chart.
Anyone has any similar experience? Was a solution found to overcome sluggish report generation?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
the IIS configuration was up to expectations when checked. Perhaps the problem could ultimately lie in the size of data being pulled in.
Also Try to do a metric of how long does it run if you modify the report to select (top 100 or top 1000 from ....)
Also , try to reduce the number of calculated fields , ( I doubt that would generate any load)
Keep us posted with results
Best of luck.