View previous topic :: View next topic |
Author |
Message |
craigmvs Beginner
Joined: 20 Nov 2004 Posts: 1 Topics: 1
|
Posted: Sat Nov 20, 2004 9:37 am Post subject: GU versus GN efficiency when both use a qualified SSA? |
|
|
Hello All.
I've recently been challenged as to my use of a GU call instead of a GN call on a root segment.
With either call I have a qualified SSA, the relational operator of which is an equal sign. No command codes are in use.
My values for the search field of the SSA are available to me in the same sorted order as the root key of my database.
We are talking about 7,000 root segment calls in a single COBOL program execution. The execution is DLI.
Would a GN call be substantially more efficient under these conditions than a GU call?
Craig |
|
Back to top |
|
 |
Bithead Advanced

Joined: 03 Jan 2003 Posts: 550 Topics: 23 Location: Michigan, USA
|
Posted: Mon Nov 22, 2004 9:28 am Post subject: |
|
|
I am not aware of any effeciency difference if this is a truly random call. If your PCB is already positioned fairly close in the database and you are progressing forwards, then GN may give you an advantage, depending on database organization.
Try changing the GU to a GN and see if it makes a difference in the CPU usage. |
|
Back to top |
|
 |
|
|