topic Re: performance tuning in Application Development and Automation Discussions

performance tuning

Former Member — Wed, 17 May 2006 19:52:14 GMT

Hi experts,

Can I get some info about 'Performance Tuning'?

thnx for the help.

Re: performance tuning

Former Member — Wed, 17 May 2006 19:58:44 GMT

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

Re: performance tuning

Former Member — Wed, 17 May 2006 20:00:36 GMT

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

Re: performance tuning

RichHeilman — Wed, 17 May 2006 20:01:02 GMT

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

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

Regards,

Rich Heilman

Re: performance tuning

Former Member — Wed, 17 May 2006 20:01:49 GMT

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

Re: performance tuning

Former Member — Wed, 17 May 2006 20:02:02 GMT

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

Re: performance tuning

Former Member — Wed, 17 May 2006 20:11:43 GMT

Hi all..

thnx a lot

Message was edited by: sey ni

Re: performance tuning

Former Member — Wed, 17 May 2006 20:18:40 GMT

Hi,

Sent you the docs.