improving the performance of a Program

[Former Member]

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

[Former Member]

Hi,

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

Regards,

Anjali.

[Former Member]

thank u

[Former Member]

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

[Former Member]

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

[Former Member]

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