[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2014-12-12
4
Medium Priority
?
197 Views
Last Modified: 2015-01-14
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
Comment
Question by:Paul Mauriello
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 62

Accepted Solution

by:
gheist earned 1000 total points
ID: 40532953
It takes a second or two to make SQL connection. If it was measurable difference we should worry.
0
 

Author Closing Comment

by:Paul Mauriello
ID: 40549899
I was expecting a more in-depth answer..pointers etc...but if this is the best answer I can get....
0
 
LVL 62

Expert Comment

by:gheist
ID: 40549920
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
The purpose of this video is to demonstrate how to set up the WordPress backend so that each page automatically generates a Mailchimp signup form in the sidebar. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question