topic Re: Performance Tuning steps? in Application Development and Automation Discussions

Performance Tuning steps?

Former Member — Fri, 11 Aug 2006 13:56:04 GMT

Hi ,

What r the peformance tuning steps to increase the performance of ABAP Programs?In Select statement what must be included and what must not be included.?

What is "for all entries"?In this "for all entries" is there any pre-condition before using "for all entries"?

Regards,

gopi.

Re: Performance Tuning steps?

Former Member — Fri, 11 Aug 2006 14:03:22 GMT

In the select statement try to include all the key fields of the database table

For all entries.

For all entries is used , for each entry of the internal table specified an entry will be selected for that in the second select statement

Prerequisite : Internal table specified in for all entries should not be empty

eg:

select matnr from mara into table it_mara.

if not it_mara[] is initial. ---> <b>Prerequisite</b>
  select maktx from makt into table it_makt for all entries in it_mara where matnr = it_mara-matnr.
endif.

Here for every MATNR in it_maara , MAKTX will be selected

Message was edited by: Chandrasekhar Jagarlamudi

Re: Performance Tuning steps?

RichHeilman — Fri, 11 Aug 2006 14:05:10 GMT

Check out SE30, "Tips 'n' Tricks" button.

Regards,

Rich Heilman

Re: Performance Tuning steps?

Former Member — Fri, 11 Aug 2006 14:11:46 GMT

HI,

See the below link, you will find the Performance Tuning steps for Select statment and also other stuff for this Performance

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

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

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

Thanks

Sudheer

Re: Performance Tuning steps?

Former Member — Fri, 11 Aug 2006 14:14:14 GMT

Gopi

Few guidelines.

1. Try and get only the required fields in the SELECT statement. eg SELECT fields INTO xyz FROM table

rather than using SELECT *.

2. Try and use the WHERE conditions in the SELECT query instead of checks and ifs within the loop.

For all enteries basically causes the the select statement to executed for all the entries in the particular internal table. Please note it is required that the internal table is populated otherwise it would fetch all data from select query (ignoring the where conditions)

Regards

Anurag

Re: Performance Tuning steps?

Former Member — Fri, 11 Aug 2006 14:30:04 GMT

Hi Gopi,

Following are the different tools provided by SAP for performance analysis of an ABAP object

Run time analysis transaction SE30

This transaction gives all the analysis of an ABAP program with respect to the database and the non-database processing.

SQL Trace transaction ST05

The trace list has many lines that are not related to the SELECT statement in the ABAP program. This is because the execution of any ABAP program requires additional administrative SQL calls. To restrict the list output, use the filter introducing the trace list.

check these links:

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

http://www.sapdevelopment.co.uk/perform/performhome.htm

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

regards,

keerthi.