topic peformance tuning in Application Development and Automation Discussions

peformance tuning

former_member206396 — Sat, 09 Sep 2006 10:40:40 GMT

hi all,

could any one tell me how to increase performance of my report, which is going dump in the quality itself.

tell me what to do to decrease the time??

help me out pls its urgent

thanking you.,

Re: peformance tuning

Former Member — Sat, 09 Sep 2006 10:43:25 GMT

check SAP tool ST05,SE30.

and paste ur code over there ? so we can give diff.options.

Regards

Prabhu

Re: peformance tuning

anversha_s — Sat, 09 Sep 2006 10:43:37 GMT

hi,

1. dont write select query inside loop.

2. sort ur internal table alaways.

3. use binary search for internel table.

4. inside the loop, if ur required condition satisfys jus 'EXIT'.

5.Always use modify command in place of insert and upadte commands.

6.do all ur data manip[ulations only inside the internal table.

all the best.

for any clarifiaction pls mail me.

pls reward points, if this helped u.

regards,

anversha.

anversha.shahul@wipro.com

Re: peformance tuning

Former Member — Sat, 09 Sep 2006 10:43:39 GMT

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

Re: peformance tuning

Former Member — Sat, 09 Sep 2006 10:44:10 GMT

1 Try to reduse the numer of internal tables.

2 Delete the intenal table not in use after a point.

3 Reduse or remove the number of unnecessory variables.

4 Use proper SQL query try to avoid Joins.

regards

Pulkit Agrawal

Re: peformance tuning

Former Member — Sat, 09 Sep 2006 11:47:11 GMT

Hi Rama krishna S

If u specify what u have used and who in your report i can help u more to increase your performance

regards

Pulkit Agrawal

Re: peformance tuning

Former Member — Sat, 09 Sep 2006 11:58:16 GMT

Hi,

For performance use below points

1 ) use binary search in read by sorting table

2) Instead of IF use case wherever req

3) remove move-corresponding from select

4) use constants whereever req instead of hardcong

In se30 transaction you can look for

Tip&TRicks button on application toolbar

apart from below conventions

Follow below steps

5) Remove * from select

6) Select field in sequence as defined in database

7) Avoid unnecessary selects

i.e check for internal table not initial

😎 Use all entries and sort table by key fields

9) Remove selects ferom loop and use binary search

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

full key.

11) Modify internal table use transporting option

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

from sy-tabix statement.

13) free intrenal table memory wnen table is not

required for further processing.

14)

Follow below logic.

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

Regards

Amole