View previous topic :: View next topic
|
Author |
Message |
mailsaurabh.tripathi
New User
Joined: 22 May 2008 Posts: 56 Location: hyderabad
|
|
|
|
Hi
We have a program(running in LPAR1) which is accessing table A on LPAR2. The same querry at local server takes time say x, but when run from remote server is taking time 1.6x.
We are using SNA for cross platform access.
Can anyone please suggest the possible reasons and measures to be taken? Also if we use DRDA instead of SNA, will it be of any use?
Regards
saurabh |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Often/Usually, remote access takes longer than local access for the same query. . .
When looking at time, you might consider the remote 1.6x as standard and the local is an improvement rather than seeing the remote as "bad".
Some environments define a local read-only set of the remote tables (depending on the actual processing). These are refreshed as needed - once a day, once an hour, etc. . . |
|
Back to top |
|
|
mailsaurabh.tripathi
New User
Joined: 22 May 2008 Posts: 56 Location: hyderabad
|
|
|
|
Thank you for your input. I understand that with remote access there will be overhead. But there must be measures to keep this overhaed at minimum. Any suggestions to bring down the oveahead will be of great help. The program will pull around 12k rows from remote table.
We don't want to replicate the remote table at the local site, due to space constraint.
thanx
-saurabh |
|
Back to top |
|
|
|