Natural Program Performance Tuning

Geeta_A · New User Joined: 17 Feb 2009 Posts: 1 Location: India

Hi,

Can anybody suggest what all points to look into while doing performance tuning for Natural programs?

monasu1998 · Active User Joined: 23 Dec 2005 Posts: 176 Location: India

Hi Geeta,
From my point of view, the first and foremost thing that should be looked into to tune the performance of the program is 'Looking at the database access statements'..

Possibly relacing the complex FIND statements with READ statements....

And may be (I am not very sure), the numeric data definitions can be considered............

I would appreciate if someone correct me if I am wrong....

Thanks

Steve Robinson · New User Joined: 14 Nov 2009 Posts: 12 Location: U.S.

At least half of Natural's statements have performance considerations. So, the first thing you have to do is learn these.

Then, you have to learn how Adabas works, and how Natural interacts with Adabas.

The you should learn the use of SETTIME.....*TIMD

steve

monasu1998 · Active User Joined: 23 Dec 2005 Posts: 176 Location: India

Hi Steve,

Thank you for your response on this topic. Can you please tell few Natural statements which are performance consideration?

dbzTHEdinosauer · Posted: Mon Nov 16, 2009 8:58 pm

Steve Robinson · New User Joined: 14 Nov 2009 Posts: 12 Location: U.S.

For example:

READ, FIND, HISTOGRAM, READ WORK FILE, WRITE WORK FILE, GET

All arithmetic statements, ADD, SUBTRACT, MULTIPLY, DIVIDE, COMPUTE

CALLNAT, PERFORM, FETCH, FETCH RETURN

COMPRESS, SEPARATE, EXAMINE

DECIDE FOR, DECIDE ON, IF

FOR, REPEAT

MOVE, MOVE BY NAME, MOVE BY POSITION

REDUCE, EXPAND, RESIZE

SORT , SORTED BY clause of FIND

And I am sure I have skipped a few.

steve

monasu1998 · Active User Joined: 23 Dec 2005 Posts: 176 Location: India

This list is nice to see Steve. Thank you very much