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

performance

Hi all,

i did a program and want to do the performance check.

i need to know that is there any way to guide for the code, which statement will be used instead of i write

(say one instead of second) in ABAP itself.

i tried se30, st05 also.

but i did not get proper guidelines to reduce performance.

can anyone send proper guidelines what to do.

Thanks in advance

Venkat

Add comment
10|10000 characters needed characters exceeded

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 11:02 AM

    place your code,we can tell you where you can improve the performance.

    regards

    srikanth

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 11:05 AM

    Hi,

    Check your SQL statements the where clause fields should be either of primary index or secondary index.

    Post your code for performance improvement suggestions.

    regards

    Damasus

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 11:28 AM

    Hi Venkat,

    chk out below given instructions

    performance of ABAP Program:

    Always check the driver internal tables is not empty, while using FOR ALL ENTRIES

    Avoid for all entries in JOINS

    Try to avoid joins and use FOR ALL ENTRIES.

    Try to restrict the joins to 1 level only ie only for tables

    Avoid using Select *.

    Avoid having multiple Selects from the same table in the same object.

    Try to minimize the number of variables to save memory.

    The sequence of fields in 'where clause' must be as per primary/secondary index ( if any)

    Avoid creation of index as far as possible

    Avoid operators like <>, > , < & like % in where clause conditions

    Avoid select/select single statements in loops.

    Try to use 'binary search' in READ internal table. Ensure table is sorted before using BINARY SEARCH.

    Avoid using aggregate functions (SUM, MAX etc) in selects ( GROUP BY , HAVING,)

    Avoid using ORDER BY in selects

    Avoid Nested Selects

    Avoid Nested Loops of Internal Tables

    Try to use FIELD SYMBOLS.

    Try to avoid into Corresponding Fields of

    Avoid using Select Distinct, Use DELETE ADJACENT

    Also by going to transaction SE30->tips and tricks you can get the idea

    Reward points for the helpful.

    Regards,

    Harini

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 11:46 AM

    Hi Venkat ,

    put ur code over here so we can tell me u the best way to reduce.

    regards

    Prabhu

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 01:31 PM

    Use all the posted points. Additional use the code inspector and have a close look at the points regarding performance.

    Matthias

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 01:52 PM
    Add comment
    10|10000 characters needed characters exceeded