05-17-2006 8:52 PM
Hi experts,
Can I get some info about 'Performance Tuning'?
thnx for the help.
05-17-2006 9:00 PM
05-17-2006 8:58 PM
Restrict the Select option.
Try to use where clause as per the index.
Dont use SELECT ENDSELECT, Instead of that use for all entries in table....
Try to use BINARY SEARCH with READ table.[be sure to SORT that internal table based on the key fields]
Always use Extended program check or use code inspector.
Regards
Aman
05-17-2006 9:01 PM
05-17-2006 9:00 PM
05-17-2006 9:11 PM
05-17-2006 9:18 PM
05-17-2006 9:01 PM
There are really only two things to remember:
When selecting from large database tables, make effective use of an index.
Avoid nested loops on large internal tables.
Doing these two can speed up a program 10s of times. Everything else (avoiding select/endselect) is good, but won't help as much as the two I've mentioned.
Rob
05-17-2006 9:02 PM
hi sey,
check the below link
http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm
See the following link if it's any help:
http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp
Check also http://service.sap.com/performance
and
books like
http://www.sap-press.com/product.cfm?account=&product=H951
http://www.sap-press.com/product.cfm?account=&product=H973
Regards,
Naveen