Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reporting Services RDLC Slow Initial Load Expand / Collapse
Author
Message
Posted Saturday, January 19, 2013 10:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 26, 2014 10:27 PM
Points: 6, Visits: 113
We've a web application that's using the Reporting Services viewer and an .rdlc file to produce a report of an invoice.

It's running on SQL Server 2008R2 database and retrieving its data using efficient stored procedures.
There's not a lot of data for one invoice.

Our users are complaining that sometimes the wait for the report is too long.

I've tested it and occasionally it takes 30 seconds to produce the report.
Then if I immediately produce the same report with different parameters and it'll take < 5 seconds.

[I believe] The problem isn't with the data retrieval, I've monitored it in firebug and the .aspx Report Viewer form takes 5.27s the 1st time, 787ms thereafter.

I've searched elsewhere without luck, thought I'd ask the experts if you've any idea how to speed this initial start up.




Kindest Regards,

Chris Clarke

Post #1409254
Posted Sunday, January 20, 2013 1:59 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:47 PM
Points: 1,163, Visits: 1,187
Chris Clarke-296861 (1/19/2013)
We've a web application that's using the Reporting Services viewer and an .rdlc file to produce a report of an invoice.

It's running on SQL Server 2008R2 database and retrieving its data using efficient stored procedures.
There's not a lot of data for one invoice.

Our users are complaining that sometimes the wait for the report is too long.

I've tested it and occasionally it takes 30 seconds to produce the report.
Then if I immediately produce the same report with different parameters and it'll take < 5 seconds.

[I believe] The problem isn't with the data retrieval, I've monitored it in firebug and the .aspx Report Viewer form takes 5.27s the 1st time, 787ms thereafter.

I've searched elsewhere without luck, thought I'd ask the experts if you've any idea how to speed this initial start up.

Is the initial slowness waiting for the reporting server to "spin up to speed"? Once it's going, performance is fine? Take a look at:

http://www.mssqltips.com/sqlservertip/2197/how-to-speed-up-ms-sql-server-reporting-services-ssrs-on-first-run/ or
http://sql-sudhir.blogspot.com/2009/10/speed-up-reports-in-sql-server.html

HTH,
Rob
Post #1409304
Posted Sunday, January 20, 2013 2:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 26, 2014 10:27 PM
Points: 6, Visits: 113
I understand what you're saying but these links are talking about the SQL Services Report Server.

But we're not using a Report Server, just the Report Viewer with .RDLC files
(There's no App Pool to configure.)



Kindest Regards,

Chris Clarke

Post #1409306
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse