performance tuning

[Former Member]

Hi experts,

Can I get some info about 'Performance Tuning'?

thnx for the help.

[Former Member]

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

[RichHeilman]

http://www.sapgenie.com/abap/performance.htm

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

Regards,

Rich Heilman

[Former Member]

To get a document on Perf Tuning, please give your e-mail.

[Former Member]

Hi all..

thnx a lot

Message was edited by: sey ni

[Former Member]

Hi,

Sent you the docs.

[Former Member]

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

[Former Member]

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