topic Re: Optimizing performance in Application Development and Automation Discussions

Optimizing performance

Former Member — Tue, 25 Jul 2006 11:14:56 GMT

hi all

I Want to know how to check my program performance and how to optimize the progame , can anybody send me any tricks, PPT fils, links, methods for checking performance, some documentations, on my mail id

chetan.vishnoi@vikalpsolutions.com

thanks in advance

chetan vishnoi

Re: Optimizing performance

Former Member — Tue, 25 Jul 2006 11:18:28 GMT

Performance tuning for Data Selection Statement

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

Debugger

http://help.sap.com/saphelp_47x200/helpdata/en/c6/617ca9e68c11d2b2ab080009b43351/content.htm

http://www.cba.nau.edu/haney-j/CIS497/Assignments/Debugging.doc

http://help.sap.com/saphelp_erp2005/helpdata/en/b3/d322540c3beb4ba53795784eebb680/frameset.htm

Run Time Analyser

http://help.sap.com/saphelp_47x200/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/content.htm

SQL trace

http://help.sap.com/saphelp_47x200/helpdata/en/d1/801f7c454211d189710000e8322d00/content.htm

CATT - Computer Aided Testing Too

http://help.sap.com/saphelp_47x200/helpdata/en/b3/410b37233f7c6fe10000009b38f936/frameset.htm

Test Workbench

http://help.sap.com/saphelp_47x200/helpdata/en/a8/157235d0fa8742e10000009b38f889/frameset.htm

Coverage Analyser

http://help.sap.com/saphelp_47x200/helpdata/en/c7/af9a79061a11d4b3d4080009b43351/content.htm

Runtime Monitor

http://help.sap.com/saphelp_47x200/helpdata/en/b5/fa121cc15911d5993d00508b6b8b11/content.htm

Memory Inspector

http://help.sap.com/saphelp_47x200/helpdata/en/a2/e5fc84cc87964cb2c29f584152d74e/content.htm

ECATT - Extended Computer Aided testing tool.

http://help.sap.com/saphelp_47x200/helpdata/en/20/e81c3b84e65e7be10000000a11402f/frameset.htm

Just refer to these links...

You can go to the transaction SE30 to have the runtime analysis of your program.Also try the transaction SCI , which is SAP Code Inspector.

Re: Optimizing performance

Former Member — Tue, 25 Jul 2006 11:20:19 GMT

Hi chetan,

for checking the performance run the SQL trace tool ST05 if you are using select statements you can know the time taken by each individual query.Also you can do a runtime analysis using SE30.

Regards,

Sangram

SAP Consultant

Re: Optimizing performance

Simha_ — Tue, 25 Jul 2006 11:25:40 GMT

Hi.

Links sent to ur id..

Reward if it is needful.

Cheers,

Simha.

Re: Optimizing performance

Former Member — Tue, 25 Jul 2006 11:46:33 GMT

good

you can go thruogh the following tcodes which ll help you to checking the performance of your program.

SLIN

SCI

SE37

ST05

SM50

THANKS

MRUTYUN

Re: Optimizing performance

Former Member — Tue, 25 Jul 2006 12:17:54 GMT

hi,

i want some PPT types files.

thanks

chetan vishnoi

Re: Optimizing performance

Former Member — Tue, 25 Jul 2006 12:30:15 GMT

Hi chetan,

In se30 transaction you can look for

Tip&TRicks button on application toolbar

apart from below conventions.

Follow below steps

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

6) Remove selects ferom loop and use binary search

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

full key.

😎 Modify internal table use transporting option

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

from sy-tabix statement.

10) free intrenal table memory wnen table is not

required for further processing.

11)

Follow below logic.

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.

Regards

Amole

Regards,

Amole

Re: Optimizing performance

Former Member — Tue, 25 Jul 2006 12:30:49 GMT

Hi chetan,

i have sent optimization docs to your mail id. check if it is needful..

Thanks & Regards,

kalyani .A