topic Re: performance in Application Development and Automation Discussions

performance

Former Member — Wed, 21 Mar 2007 11:37:18 GMT

Hi,

Please tell the performance issues we have to take in reports and scripts,Please give full details Please....

Re: performance

alex_m — Wed, 21 Mar 2007 11:42:21 GMT

Performance can be checked against any ABAP program, whether its report or script or module pool.

U have to use basic standard and use ST05 & SE30 for to analysis the statements.

Re: performance

Former Member — Wed, 21 Mar 2007 11:42:25 GMT

Hi,

1) Dont use nested seelct statement

2) If possible use for all entries in addition

3) In the where addition make sure you give all the primary key

4) Use Index for the selection criteria.

5) You can also use inner joins

6) You can try to put the data from the first select statement into an Itab and then in order to select the data from the second table use for all entries in.

7) Use the runtime analysis SE30 and SQL Trace (ST05) to identify the performance and also to identify where the load is heavy, so that you can change the code accordingly

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d0db4c9-0e01-0010-b68f-9b1408d5f234

reward if useful.

regards,

Anji

Re: performance

Former Member — Wed, 21 Mar 2007 11:43:53 GMT

For reports...

WHile running the report go to SE38 initial screen~~> program-> execute~~> runtime analysis. From there Execute the program..

There you can find the time taken by diffrent ABAP statements in ur program...

Basically improving performance means "reducing DB time even though it increases ABAP run time"

So you have to concentarte on SELECT statements... Try to reduce the time taken by the SELECT by using different methods like..

1. Passing entire primary key

2. Using Views

3. Joins

4. Secondary Indexes

5. For all entries..

... etc

for more info...

http://saptechnical.com/Tutorials/ABAP/PerformanceSTDs.htm

Reward if helpful...