Posts

Showing posts with the label performance tuning in sap abap

SAP ABAP Performance Tuning/Enhancement Key Steps.

Image
Basic steps to be looked into for optimized performance are: Database Server workload must be optimized. Application Server should be more fully utilized. Reduce the network traffic (Like, Commands that retrieve data must be optimized). Minimize use of global resources. (Like, Spool usage should be minimum). Here's a list of golden rules from performance optimization point of view: 1. Use Parallel Cursor technique in case of Nested Loop. Binary Search is used when parallel cursor is not feasible and the number of entries in the internal table is greater than 20. 2. Before using Select for all entries we need to check whether Driver internal table is empty or not. 3. After using one Select statement check sy-subrc value. If sy-subrc is 0, then only use next select statement. 4. During using Select for all entries use all the Primary key fields in the Select statement in WHERE clause in order to retrieve all records and to remove adjacent duplicates. 5. For sel...