program efficiency

[Former Member]

can anyone please tell how to increase program efficiency by adding some validation i.e. before saving, deleting. Thanks in advavce.

[Former Member]

you really mean efficiency? or do we talk about performance?

[Former Member]

Heeloo,

These are some the performance tuning techniques:

What tools can be used to help with performance tuning?
ST05 is the SQL Trace transaction and can be used to measure the performance of the select statements of the program. SE30 is the Runtime Analysis transaction and can be used to measure the application performance. It also gives some tips on how to improve the performance through efficient code.

One of the best tools for static performance analyzing is Code Inspector (SCI). There are many options for finding common mistakes and possible performance bottlenecks.

back to top

What are the steps to optimise the ABAP Code?
Avoid using SELECT...ENDSELECT... construct and use SELECT ... INTO TABLE. 
Use WHERE clause in your SELECT statement to restrict the volume of data retrieved. 
Design your Query to Use as much index fields as possible from left to right in your WHERE statement 
Either enable buffering in your database table or create Indexes to speed up the query. 
Use FOR ALL ENTRIES in your SELECT statement to retrieve the matching records at one shot. 
Avoid using nested SELECT statement, SELECT within LOOPs. 
Avoid using INTO CORRESPONDING FIELDS OF TABLE. Instead use INTO TABLE. 
Avoid using SELECT * and Select only the required fields from the table. 
Avoid nested loops when working with large internal tables. 
Use assign instead of into in LOOPs for table types with large work areas 
When in doubt call transaction SE30 and use the examples and check your code 
Whenever using READ TABLE use BINARY SEARCH addition to speed up the search. Be sure to sort the internal table before binary search. 
Use "CHECK" instead of IF/ENDIF whenever possible. 
Use "CASE" instead of IF/ENDIF whenever possible. 
Use "MOVE" with individual variable/field moves instead of "MOVE-CORRESPONDING", creates more coding but is more effcient. 
back to top

What is the difference between SELECT SINGLE and SELECT ... UP TO 1 ROWS?
SELECT SINGLE returns the first matching row for the given condition and it may not be unique, if there are more matching rows for the given condition.

SELECT ... UP TO 1 ROWS retrieves all the matching records and applies aggregation and ordering and returns the first record.

Inorder to check for the existence of a record then it is better to use SELECT SINGLE than using SELECT ... UP TO 1 ROWS since it uses low memory and has better performance.

back to top

Which is the better - JOINS or SELECT... FOR ALL ENTRIES...?
When using FOR ALL ENTRIES the number of matching records is restricted to the number of records in the internal table. If the number of records in the database tables is too large then join would cause overheads in performance. Additionally a JOIN bypasses the table buffering.

back to top

Does SAP publish guides and cookbooks on performance monitoring and testing?
Yes it does. You'll find a collection of resources for Performance monitoring and testing under SAP NetWeaver Administration on SDN.

If useful reward.

Vasanth

[Former Member]

Hello,

For performance tuning steps,you can try transaction ST05 for SQL Performance trace.For ABAP runtime anaysis,try se30.You can execute your program and then check the DB and ABAP access which is greatly beneficial for performance tuning.Further, check "tips and tricks" in se30.You can find some efficient ways of coding.

Also check,

http://www.sapbrain.com/ARTICLES/TECHNICAL/optimization/optimization.html

https://wiki.sdn.sap.com/wiki/display/HOME/ABAPPerformanceand+Tuning

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp

Regards,

Beejal

**Reward if answer is helpful