‎2007 Nov 11 12:14 PM
which is preferrable between move and move-corresponding based on performance issues?
‎2007 Nov 11 2:26 PM
Move statement is best than move-corresponding statement .
Move-corresponding statement takes little bit performance but it is not countable.
Thanks
Seshu
‎2007 Nov 11 4:16 PM
If you have a scenario in which you can use both then 'move' is better than 'move-corresponding'.
move-corresponding will be used only where you can't use a move statement as the fields might not be in the required sequence.
‎2007 Nov 11 4:19 PM
From a performance standpoint, MOVE is better than MOVE-CORRESPONDING, but the improvement is so slight that I generally use MOVE-CORRESPONDING. You also have to take into account programming efficiency. Programming a couple of hundred MOVE statements may take more time than is saved in the life of the program using the MOVE-CORRESPONDING.
Rob
‎2007 Nov 12 12:56 PM
the general performance recommendation is the following:
Never use move-corresponding with buffered tables, the overhead can be similar as the buffered access itself.
For database selects, the select itself is more expensive than the move corresponding. The decision come from the decision whether you want to use a fieldlist or a SELECT *. Fieldlists are recommended for very width tables, if the fieldlist reduces the width by a factor 2. Fieldlist must be used if your INTO structure is different from the table structure. In these 2 cases, you should use MOVE-CORRESPONDING.
Siegfried