Wednesday, May 21, 2008

10 Simple Programming tweaks for Faster Performance




Here are simple tips which will improve the performance of any ABAP Program.
  1. Avoid Use of validations between SELECT and ENDSELECT. Rather, retrive the data into an internal table and make your validations.
  2. Use Aggregate functions along with the SELECT statement is better than looping through the entire set of records.
  3. Nested select is a No No, instead of that use Joins or Views. This improves the readability to some extent also.
  4. Always use INTO TABLE and FOR ALL ENTRIES where ever possible. While using FOR ALL ENTRIES, check if the table contains any entries.
  5. Modifying a group of lines. Do not loop at all the records, rather use the MODIFY statement on the internal table as a whole.
  6. READ TABLE always with BINARY SEARCH.
  7. Try to align your WHERE clause in sync with the index.
  8. Appropriate use of INNER JOIN
  9. Use ABAP sort over ORDER BY.
  10. 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