CODEWITHSUNDEEP
sqlsql-serverwpfreporting-services
0xFF
0xFF

Reputation: 838

SSRS report takes a long time to appear but is quick to process

EDIT
I was working on a new report and I tried to make a blank one. Even this one takes ~12 seconds to appear. There's clearly something wrong but I'd like to try possible solutions you might have before reinstalling.

My application has a couple of SSRS reports. They're all simple tables listing the data. In the designer's preview tab, they all appear within 1-3 seconds. The SQL queries or Stored procedure they use all execute fast enough. The reports are hosted in a ReportViewer, inside a tabcontrol.

My problem is that most of these reports are going to be generated around 20 times in a row, each with different parameters, and it take a report 12 seconds or more to appear in the actual application, which is a big problem. What could be causing such a slowdown?

Here's a example of the simplest report I have, which still takes way too much time:

**Table Users**
Id uniqueidentifier PK
Name varchar(50)
Salary decimal
TimeInBank decimal
Enabled bit

The table has less than 100 rows, nothing special. The query:

Select * from Users where Enabled=1

In the execution log, this report has the following statistics:

TimeRendering: 79
TimeProcessing: 54
TimeDataRetrieval: 22
Status: rsSuccess
ByteCount: 5305
RowCount: 7

Nothing seems wrong with these numbers but it still takes at least 12 seconds from the moment I press the button to the moment I can see the report.

Upvotes: 1

Views: 1634

Answers (1)

TTT
TTT

Reputation: 28934

If the data in your reports is not changing very often, you could consider caching the reports: http://msdn.microsoft.com/en-us/library/ms155927.aspx

You still may want to figure out what the bottleneck is in the first place, but at least the viewers of the report won't have to wait in the meantime.

Upvotes: 1

Related Questions