Run Time Analysis

[PS_1978]

Hi All,

When I check runtime analysis of a function module, the database runtime is: 78%??? and ABAP & System runtimes are 12.9 and 9.2% respectively. Could you guys suggest me whether it is ok or not?

Regards,

Phani

[Former Member]

this shows poor performance. when u check run time analysis...the database should be less than 40% & abap should be around 50% & system should be around 10%.

U need to modify ur code and try to reduce runtime analysis...check in ST05 for which statements are taking more time and try to analyze and modify ur code.

[Former Member]

<b>The bar chart displays the total runtime required for</b>

• The ABAP interpreter

• The database

• System statements.

<b>With the ABAP and system statements, a green bar indicates that the corresponding statements required less than 50% of the total runtime. A red bar indicates that one of the statement categories required more than 50% of the total runtime. With the database operations, a red bar appears if this category required more than 25% of the total runtime.

</b>

If the system had to generate a program during the runtime analysis, it reports the fact below the bar diagram. In this case, the total runtime includes the time required for the program generation.

<b>Try to reduce the database load</b>

[Former Member]

hi Siva,

YOu need to avoid usage of database as much as possible ... it seems to me that you are making use of such statements .... try collecting the data into your internal tables and then perform the required operations on that .... avoid using select statements within loop and endloop statement ..

Check

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

Regards,

Santosh

[Former Member]

Hi,

The figure shows that the program has very poor performance.

Optimize ur program to have a better performance.

Refer this link for tips and tricks for having a good performace.

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

Rgds,

Prakash