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.