There are many tricks and tips which can be used for SAP ABAP performance tuning for reducing the time consumed in program execution.
Using ABAP sort in place of order by, order by clause is executed in database server whereas ABAP sort statement is executed in application server, collecting the data in internal table and using sort command to search executes the search much faster than order by. Another tip for SAP ABAP performance tuning is use of aggregated functions in place of loops for finding highest value etc. in a table, using parallel cursor technique in place of nested loops and using selection criteria in place of check clause in select endselect loop.
Selection with index support, selection with into table clause and selection with selection list in place of select endselect loop with check clause are few tips and tricks for SAP ABAP program performance tuning. Copy, modify and delete are the tasks which are required in an application many times, performing these tasks with help of loops is easy but wastes lot of execution time. Normally, a loop is run on the table and corresponding commands are given to perform any of these activities like append, delete or modify in the loop body, in place of this, use of modify command or delete command with necessary parameters can save lot of time. Appending two internal tables by using append lines in place of loops more frequently is a good SAP ABAP performance tuning trick. Avoiding use of select distinct clause and using abap+sort delete adjacent duplicates for deleting duplicate rows is also a good way of tuning the performance of a SAP ABAP program.
Using ABAP sort in place of order by, order by clause is executed in database server whereas ABAP sort statement is executed in application server, collecting the data in internal table and using sort command to search executes the search much faster than order by. Another tip for SAP ABAP performance tuning is use of aggregated functions in place of loops for finding highest value etc. in a table, using parallel cursor technique in place of nested loops and using selection criteria in place of check clause in select endselect loop.
Selection with index support, selection with into table clause and selection with selection list in place of select endselect loop with check clause are few tips and tricks for SAP ABAP program performance tuning. Copy, modify and delete are the tasks which are required in an application many times, performing these tasks with help of loops is easy but wastes lot of execution time. Normally, a loop is run on the table and corresponding commands are given to perform any of these activities like append, delete or modify in the loop body, in place of this, use of modify command or delete command with necessary parameters can save lot of time. Appending two internal tables by using append lines in place of loops more frequently is a good SAP ABAP performance tuning trick. Avoiding use of select distinct clause and using abap+sort delete adjacent duplicates for deleting duplicate rows is also a good way of tuning the performance of a SAP ABAP program.
No comments:
Post a Comment