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

performace

hi,

i need clarification regarding the run time analysis it will show the graphical output for system, database and abap. so if i want to reduce the correspoding time what are the steps we have to follow,

i mean for to reduce system timing what we can do,

for reducing database time what we can do,

for reducing abap time what we can do.

hope iam clear to all can any one of you help me out thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2006 at 01:13 PM

    for database : ask your basis to regenerate indexes

    check your sql statment (use off keys , indexes, multiple joins etc ) - for checkin it use st05 sql trace

    in abap : do not use nested selcts, nested loops , use sorted internal table where posible insteed of standard tables.

    BR, JAcek

    Message was edited by: Jacek Slowikowski

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2006 at 01:17 PM

    Hi Madan,

    You can do following:

    1) reducing database time - Avoid using nested select.

    avoid selecting data from clustur table.

    basically optimize all Select statements taht hits Database.

    2) Reducing abap time - Avoid using redundat code.

    modularize ABAP code.

    Use Subroutine/ FM etc.

    3) Reduce system timing - Basically depends on system/ network congestion. Can't do much.

    Reward points if this helps.

    Manish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2006 at 02:35 PM

    Hi,

    <b> reduce database time</b>

    1) Remove corresponding from select satement

    2) Remove * from select

    3) Select field in sequence as defined in database

    4) Avoid unnecessary selects

    i.e check for internal table not initial

    5) Use all entries and sort table by key fields

    7) Try to use secondary index when you don't have

    full key.

    FORM SUB_SELECTION_AUFKTAB.

    if not it_plant[] is initial.

    it_plant1[] = it_plant[].

    sort it_plant1 by werks.

    delete adjacent duplicates from it_plant1 comparing werks

    SELECT AUFNR KTEXT USER4 OBJNR INTO CORRESPONDING FIELDS OF TABLE I_AUFKTAB

    FROM AUFK

    FOR ALL ENTRIES IN it_plant1

    WHERE AUFNR IN S_AUFNR AND

    KTEXT IN S_KTEXT AND

    • WERKS IN S_WERKS AND

    AUART IN S_AUART AND

    USER4 IN S_USER4 AND

    werks eq it_plant1-werks.

    free it_plant1.

    Endif.

    ENDFORM. "SUB_SELECTION_AUFKTAB

    2) <b>reduce abap time</b>

    1) Remove selects from loop and use binary search

    2) Modify internal table use transporting option

    3) Avoid nested loop . Use read table and loop at itab

    from sy-tabix statement.

    4) free intrenal table memory wnen table is not

    required for further processing.

    3)<b>Reduce system time</b>Regards

    1) perform give types of formal parameters

    perform add using a b.

    form add a type i b type i.

    Regards,

    amole

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2006 at 02:37 PM

    Hi,

    Reduce system time avoid uploading legacy

    data in foreground as it may take more resouces

    and perfromance will be slow.

    run complex jobs in batk ground mode.

    regards

    amole

    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.