StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSSRS report takes a long time to appear but is quick to process
text
Body
copied!<p><strong>EDIT</strong><br> 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.</p> <p>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.</p> <p>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?</p> <p>Here's a example of the simplest report I have, which still takes way too much time:</p> <pre><code>**Table Users** Id uniqueidentifier PK Name varchar(50) Salary decimal TimeInBank decimal Enabled bit </code></pre> <p>The table has less than 100 rows, nothing special. The query:</p> <blockquote> <p>Select * from Users where Enabled=1</p> </blockquote> <p>In the execution log, this report has the following statistics:</p> <pre><code>TimeRendering: 79 TimeProcessing: 54 TimeDataRetrieval: 22 Status: rsSuccess ByteCount: 5305 RowCount: 7 </code></pre> <p>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.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload