topic Re: Performance Tuning in Application Development and Automation Discussions

Performance Tuning

Former Member — Wed, 22 Nov 2006 15:20:28 GMT

Hi,

Could anybody send me the document for performance tuning.

I need it for my project purpose.

Thanks in advance,

Ponraj.s.

ponraj_rec@yahoo.com

Re: Performance Tuning

Former Member — Wed, 22 Nov 2006 15:22:41 GMT

Hi,

reduce database time

1) Remove corresponding from select satement

2) Remove * from select

3) Select field in sequence as defined in database

4) Avoid unnecessary selects

i.e check for internal table not initial

5) Use all entries and sort table by key fields

7) Try to use secondary index when you don't have

full key.

FORM SUB_SELECTION_AUFKTAB.

if not it_plant[] is initial.

it_plant1[] = it_plant[].

sort it_plant1 by werks.

delete adjacent duplicates from it_plant1 comparing werks

SELECT AUFNR KTEXT USER4 OBJNR INTO CORRESPONDING FIELDS OF TABLE I_AUFKTAB

FROM AUFK

FOR ALL ENTRIES IN it_plant1

WHERE AUFNR IN S_AUFNR AND

KTEXT IN S_KTEXT AND

WERKS IN S_WERKS AND

AUART IN S_AUART AND

USER4 IN S_USER4 AND

werks eq it_plant1-werks.

free it_plant1.

Endif.

ENDFORM. "SUB_SELECTION_AUFKTAB

2) reduce abap time

1) Remove selects from loop and use binary search

2) Modify internal table use transporting option

3) Avoid nested loop . Use read table and loop at itab

from sy-tabix statement.

4) free intrenal table memory wnen table is not

required for further processing.

3)Reduce sytsem timeRegards

1) perform give types of formal parameters

perform add using a b.

form add a type i b type i.

REgrads

Amole

Re: Performance Tuning

Former Member — Wed, 22 Nov 2006 15:22:57 GMT

HI,

look at the links for some docs

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

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

http://www50.sap.com/useducation/curriculum/course.asp?cid=60119869

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

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

http://www.dbis.ethz.ch/research/publications/19.pdf

https://websmp102.sap-ag.de/~form/ehandler?_APP=00200682500000001337&_EVENT=DISPLAY&COURSE=BC490&LANGUAGE=

Regards

Sudheer

Re: Performance Tuning

Former Member — Wed, 22 Nov 2006 15:55:58 GMT

Pooraj,

I had emailed you a document over performance tuning and analysis. Please dont forget to mark all helpful answers.

Thanks,

Re: Performance Tuning

Former Member — Wed, 22 Nov 2006 15:56:42 GMT

Hi,

For Better performance you may keep in mind following things:

1. Avoid using into corresponding fields of table , try to use appending table intarnal table name (say itab).

2.Insetad of joining multiple tables in one select statement into one internal table you can use for all entries by using multiple select stmt into multiple internal tables.

- You can select all necessary data into itab1 with necessary where condition .

-Taking itab1 as a driver table you can select all necessary data into itab2 for all

entries of itab1 , here you can avoid the use of Loop /Endloop.

- Using for all entries will give better performance.

-Make sure before using for all entries the driver table is not empty .

3. Make sure proper index is there for the tables.

4.Avoid to use Select End Select

5.Select all necessary fields instead of Select *

If sounds good pl reward.

Cheers.

Re: Performance Tuning

Former Member — Wed, 22 Nov 2006 16:21:21 GMT

Check out <a href="/people/rob.burbank/blog/2006/11/16/performance--what-will-kill-you-and-what-will-leave-you-with-only-a-flesh-wound">Performance - what will kill you and what will leave you with only a flesh wound</a>

Rob

Re: Performance Tuning

Former Member — Sat, 25 Nov 2006 12:19:04 GMT

Answered