topic Re: improving the performance of a Program in Application Development and Automation Discussions

improving the performance of a Program

Former Member — Mon, 23 May 2005 10:03:23 GMT

How would we go about improving the performance of a Program which selects data from MSEG & MKPF?

Re: improving the performance of a Program

Former Member — Mon, 23 May 2005 10:12:46 GMT

Hi,

Select using the key fields and the common fields, also if its a READ statement, put a BINARY SEARCH too.

Regards,

Anjali.

Re: improving the performance of a Program

Former Member — Mon, 23 May 2005 10:13:13 GMT

Hi Ramesh,

It would be helpful, if you can go a little more specific. If the performance is very much affected because of MKPF MSEG fetch alone, then make use of indexes and try improving it further. However it is to be seen how your database fetch is handled. Based on that we would be able to provide you solution.

Regards,

Vijay

Re: improving the performance of a Program

Former Member — Mon, 23 May 2005 10:18:10 GMT

thank u

Re: improving the performance of a Program

Former Member — Mon, 23 May 2005 10:20:54 GMT

Hi Ramesh,

you should use txn se30 to see runtime analysis and

use txn st05 to improve the runtime of Select statements.

hope this will help you.

Regards,

Narinder Hartala

Re: improving the performance of a Program

Former Member — Mon, 23 May 2005 10:22:06 GMT

Hi Ramesh,

I don't know your problem, but try to make less access to database as possible (probably is better to put all of possible data you need in a internal table for each table).

Pay attention in the "select" statment to put the conditional field in the same order they appear in MSEG and MKPF.

Have you make an abap runtime analusis (SM30) to understand if the problem is on database access or in the program?

Bye

enzo