performance

[Former Member]

Hi,

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

[alex_m]

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.

[Former Member]

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-9b1...

reward if useful.

regards,

Anji

[Former Member]

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...