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
186 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 62

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL LINE CONTINUATION ISSUE 12 33
is there a way to grey-out all the controls within a windows screen in VBA 18 23
Tsql query 6 21
Help in Bulk Insert 9 33
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

770 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