topic Re: performance in Application Development and Automation Discussions

performance

Former Member — Tue, 01 Aug 2006 10:52:44 GMT

Hi all,

i did a program and want to do the performance check.

i need to know that is there any way to guide for the code, which statement will be used instead of i write

(say one instead of second) in ABAP itself.

i tried se30, st05 also.

but i did not get proper guidelines to reduce performance.

can anyone send proper guidelines what to do.

Thanks in advance

Venkat

Re: performance

Former Member — Tue, 01 Aug 2006 11:02:43 GMT

place your code,we can tell you where you can improve the performance.

regards

srikanth

Re: performance

Former Member — Tue, 01 Aug 2006 11:05:31 GMT

Hi,

Check your SQL statements the where clause fields should be either of primary index or secondary index.

Post your code for performance improvement suggestions.

regards

Damasus

Re: performance

Former Member — Tue, 01 Aug 2006 11:28:08 GMT

Hi Venkat,

chk out below given instructions

performance of ABAP Program:

Always check the driver internal tables is not empty, while using FOR ALL ENTRIES

Avoid for all entries in JOINS

Try to avoid joins and use FOR ALL ENTRIES.

Try to restrict the joins to 1 level only ie only for tables

Avoid using Select *.

Avoid having multiple Selects from the same table in the same object.

Try to minimize the number of variables to save memory.

The sequence of fields in 'where clause' must be as per primary/secondary index ( if any)

Avoid creation of index as far as possible

Avoid operators like <>, > , < & like % in where clause conditions

Avoid select/select single statements in loops.

Try to use 'binary search' in READ internal table. Ensure table is sorted before using BINARY SEARCH.

Avoid using aggregate functions (SUM, MAX etc) in selects ( GROUP BY , HAVING,)

Avoid using ORDER BY in selects

Avoid Nested Selects

Avoid Nested Loops of Internal Tables

Try to use FIELD SYMBOLS.

Try to avoid into Corresponding Fields of

Avoid using Select Distinct, Use DELETE ADJACENT

Also by going to transaction SE30->tips and tricks you can get the idea

Reward points for the helpful.

Regards,

Harini

Re: performance

Former Member — Tue, 01 Aug 2006 11:46:59 GMT

Hi Venkat ,

put ur code over here so we can tell me u the best way to reduce.

regards

Prabhu

Re: performance

Former Member — Tue, 01 Aug 2006 13:31:55 GMT

Use all the posted points. Additional use the code inspector and have a close look at the points regarding performance.

Matthias

Re: performance

Former Member — Tue, 01 Aug 2006 13:52:56 GMT

Hi venkat,

find the tips by checking the links:

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

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

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

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

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

reward if helpful.

regards,

keerthi.