10 Simple Programming tweaks for Faster Performance
Here are simple tips which will improve the performance of any ABAP Program.
- Avoid Use of validations between SELECT and ENDSELECT. Rather, retrive the data into an internal table and make your validations.
- Use Aggregate functions along with the SELECT statement is better than looping through the entire set of records.
- Nested select is a No No, instead of that use Joins or Views. This improves the readability to some extent also.
- Always use INTO TABLE and FOR ALL ENTRIES where ever possible. While using FOR ALL ENTRIES, check if the table contains any entries.
- Modifying a group of lines. Do not loop at all the records, rather use the MODIFY statement on the internal table as a whole.
- READ TABLE always with BINARY SEARCH.
- Try to align your WHERE clause in sync with the index.
- Appropriate use of INNER JOIN
- Use ABAP sort over ORDER BY.
- Use simple tools like SE30 and ST05 to fine tune the programs.
Copyright SAP DB
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home