Solved

Oracle reports are very slow through RDP

Posted on 2014-03-12
5
579 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

813 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