Solved

Oracle reports are very slow through RDP

Posted on 2014-03-12
5
559 Views
Last Modified: 2014-03-30
Hi,

I are using oracle as backend database for our inhouse software. Internally from the client PC's the software and reports working fine. We are using windows 2003 TS to provide access to other site users. they are connecting remotly to the TS server and works. Data entry and all fine, but while running reports through TS server, it takes a very long time. For example local user can generate a report in 1 minutes means, RDP users can generate the same report in 5-10 minutes.

Why reporting is very slow through RDP session?
0
Comment
Question by:kolathaya123
  • 2
  • 2
5 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 333 total points
ID: 39923276
if the report is accumulation/filtering/grouping/sorting... on the "client", it means that all the data, before the above operations has to go through the network to the client.
via RDP, which uses typically encryption for the data transport, this means a serious amount of processing overhead.

the solution would then be to modify the report so that for example the filtering/grouping happens on the database level already, and not only in the report.
0
 
LVL 10

Assisted Solution

by:dbmullen
dbmullen earned 167 total points
ID: 39933352
if not the above answer,
do a PING from/to the remote site.  (but I'm going to assume it's fast since other things work)
see if you can temporary disable any/all virus protection on both sides.
0
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 333 total points
ID: 39933593
disable any/all virus protection => I see/read that so often, and that's the LAST thing you should try ...
and a PING is only up to the network card, and will not do any encryption or actual data transport. you CAN try to simulate some pack size using the -l:
http://technet.microsoft.com/en-us/library/cc737478%28v=ws.10%29.aspx
0
 

Author Closing Comment

by:kolathaya123
ID: 39964526
good
0
 
LVL 10

Expert Comment

by:dbmullen
ID: 39964797
please, do not give me credit for any points on this question..  My response was not helpful.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Let’s list some of the technologies that enable smooth teleworking. 
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

743 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

13 Experts available now in Live!

Get 1:1 Help Now