January 12, 2011 at 8:40 am
Hello,
We have a .NET 2.0 web page that displays an SSRS report instead of taking a user to the Report Manager page. A week ago the report would popup and display within 2 seconds. Now it takes about 9 seconds. The SQL query is still running fast(far less than 1 second), but there now appears to be a 4-5 second delay when I call this:
execInfo = rs.LoadReport(reportPath, historyID);
And another 3 second delay when I call this:
result = rs.Render(format, null, out extension, out encoding, out mimeType, out warnings, out streamIDs);
This happens all the time, not just on the first attempt, like other people have problems with.
I went into Report Manager(2005), and it actually took longer than expected to display the report, about 4 seconds. I then put this report on a SQL 2008 SSRS box, and it ran the report within 1 second. Both machiens have 3.0Ghz CPUs and plenty of ram, and neither is under stress.
So, it would appear there is some kind of connection delay before the report even really runs. My main concerin is why it is so slow when just doing the following because the report doesn't truely run at that point yet as the parameters havein't even been set yet:
execInfo = rs.LoadReport(reportPath, historyID);
Update: As I write this I was told there is a bad memory stick on the web server, perhaps that has something to do with this.
January 13, 2011 at 8:21 am
Web server memory did not fix issue.
No idea why there is such a delay.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply