• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 615
  • Last Modified:

SSRS reports are very slow

i have generated SSRS reports... the report takes very long time to generate(around 1 minute).. the stored procedure runs very fast(less than a second)..
and i have one paramter for the stored procedure..
there is no problem with the stored procedure..it runs very fast.. its the problem with ssrs..
why does it run so slow??
0
gautam_reddyc
Asked:
gautam_reddyc
  • 3
  • 3
1 Solution
 
Tim HumphriesDirectorCommented:
Hi,

What is the nature of the parameter you have - are you populating a drop down list for users to select from?

If so, and there are a lot of items in the list, that could be your problem.

Tim
0
 
blandyukCommented:
Only issue I encounter with SSRS is when it first starts, it takes awhile to load but once done, it's normally ok. As above, how much information is this report holding?
0
 
Tim HumphriesDirectorCommented:
@blandy - yes, this can be caused by IIS being a bit rubbish. Hence the move away from IIS as a hosting platform in 2008.
Re 'info that report is holding' - you're thinking that maybe the rendering time is high?


Tim
0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
gautam_reddycAuthor Commented:
the report is holding lot of records.. when i modified the records to retrieve top 100 rows and parameter to display top 10 values..it is rendering in 2-3 seconds..
what should i do to display 1000 records.. i found some articles on internet mentioning about 'parameter sniffing'.. i didnt make much of a difference
0
 
gautam_reddycAuthor Commented:
Tim,
  Yes, there are lot of items in the drop down list... how do you work around that?
0
 
Tim HumphriesDirectorCommented:
Very difficult...if you can categorise your list you can provide multiple parameters - a 'top level' that provides high level filtering on he parameter, which then restricts lower level lists. However, this doesn't work well if you want the users to be able to select multiple items across different categories.
Other than building your own parameter picker code, and hosting the report in a different (i.e. not Reporting Services) front end, your options are limited.

Tim
0
 
gautam_reddycAuthor Commented:
Tim,
  Thanks for the info.. will try to host the reports in ASP.NET using the Report Viewer
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now