10 Effortless Programming tweaks for Faster Performance
Here are lucid tips which testament convalesce the performance of any ABAP Program.
1. Avoid Account of validations between Capture and ENDSELECT. Rather, retrive the counsel into an internal table and constitute your validations.
2. Applicability Aggregate functions along with the Accept statement is more appropriate than looping over the full place of records.
3. Nested catch is a No No, instead of that avail Joins or Views. This improves the readability to some amount also.
4. Always appliance INTO TABLE and FOR ALL ENTRIES where ever possible. While using FOR ALL ENTRIES, proof provided the table contains any entries.
5. Modifying a bunch of lines. Cook not loop at all the records, rather exercise the Convert statement on the internal table as a whole.
6. Scan TABLE always with BINARY SEARCH.
7. Fling to range your WHERE clause in sync with the index.
8. Convenient application of INNER JOIN
9. Apply ABAP category over Succession BY.
10. Appropriateness incomplex tools coextensive SE30 and ST05 to positive tune the programs.
Call SAP Database for extra Tips and Tricks, Ebooks, Articles and enrol in SAP Forums for Debilitate related discussions.
From materials of: http://a1articles.com/article_554959_11.html
Published: June 11, 2008
Published: June 11, 2008
Keywords:
table,
internal table,
table entries,
table constitute,
table contains,
table scan,
provided table,
appliance table
Last relative articles:
Comments: [0] / Post comment:
07 Sep 2010 07:39:33
Teams facing harsh truth of the table - Soccer America
Teams facing harsh truth of the table Soccer America Last weekend's action did much to confirm the table's truth. GALAXY GAGS AGAIN. Handed a man advantage in the 21st minute via a red card to Fire defender ...
07 Sep 2010 06:06:52
Home Style: Glorious gourds in your fall dcor - Seattle Times
Home Style: Glorious gourds in your fall dcor Seattle Times To bring a subdued but sophisticated fall touch to a side table , start with a weathered white capital riser. Blanket it with moss and place a pumpkin-shaped ...
07 Sep 2010 04:19:25
BWW Reviews: Mustard Seed Theatre's Production of CRUMBS FROM THE TABLE OF JOY - Broadway World
BWW Reviews: Mustard Seed Theatre's Production of CRUMBS FROM THE TABLE OF JOY Broadway World Playwright Lynn Nottage's Crumbs From the Table of Joy, which is set in the 1950's, initially gives us more than enough plot for one play, presenting us ...