Skip to Content
author's profile photo Former Member
Former Member

improving the performance of a Program

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 23, 2005 at 10:12 AM

    Hi,

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

    Regards,

    Anjali.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 23, 2005 at 10:13 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 23, 2005 at 10:20 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 23, 2005 at 10:22 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.