?
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
?
193 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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
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.
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.

800 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