• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

SQL Server 2008 R2/SSRS..Running in a ASP.NET VS2012 framework 4.5 environment..Reports running twice as long in reportviewing control?

I have SSRS 2008 R2 reports that run in a couple of seconds when run directly on the report server. This is acceptable. However when running thru the reportviewer in remote mode. This time doubles. Any suggestions on how I can reduce this. Running in IE vs Chrome makes no difference. This report is not terribly complex. Any pointers? Ideas? thought?
0
Paul Mauriello
Asked:
Paul Mauriello
  • 2
1 Solution
 
gheistCommented:
It takes a second or two to make SQL connection. If it was measurable difference we should worry.
0
 
Paul MaurielloSoftware Programmer Developer Analyst EngineerAuthor Commented:
I was expecting a more in-depth answer..pointers etc...but if this is the best answer I can get....
0
 
gheistCommented:
The problem is that report control is hard to trace. Most likely you will get .5s difference for opening SQL connection between local machine and over the network. Pointers? It cannot be made faster.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now