Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

improving the performance of a Program

Former Member

‎05-23-2005 11:03 AM

0 Kudos

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

5 REPLIES 5

Former Member

‎05-23-2005 11:12 AM

0 Kudos

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
In response to Former Member

‎05-23-2005 11:18 AM

0 Kudos

thank u

Former Member

‎05-23-2005 11:13 AM

0 Kudos

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

‎05-23-2005 11:20 AM

0 Kudos

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

‎05-23-2005 11:22 AM

0 Kudos

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