Solved

Generating report is sluggish

Posted on 2011-02-18
4
339 Views
Last Modified: 2013-11-05
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.
0
Comment
Question by:nethermit
  • 2
  • 2
4 Comments
 
LVL 14

Expert Comment

by:GeorgeGergues
ID: 34926029
Try to use paging ( by reducing the number of rows you get per page 100 for example  )

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.




0
 

Author Comment

by:nethermit
ID: 34927268
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?
0
 
LVL 14

Accepted Solution

by:
GeorgeGergues earned 500 total points
ID: 34927399
The other items you should look for is the memory application for the application pool running the SSRS webservice.

that is an IIS configuration . , see if it is running out of memory has a hard limit on upper memory.

Theses things will change depending on your server topology as well.
0
 

Author Closing Comment

by:nethermit
ID: 35067998
the IIS configuration was up to expectations when checked. Perhaps the problem could ultimately lie in the size of data being pulled in.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question