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
183 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:pmauriello
  • 2
4 Comments
 
LVL 61

Accepted Solution

by:
gheist earned 500 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:pmauriello
ID: 40549899
I was expecting a more in-depth answer..pointers etc...but if this is the best answer I can get....
0
 
LVL 61

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now