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

performance issue

Hi ,

my prg conatins the selects stmts within loop stmt.

so its giving very less performance.

so what i want to do (Rewrite the code) BETTER PERFORMANCE.??

pls. anyone .. explain.

regards,

venu.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Sep 10, 2007 at 05:49 PM

    Hi Venu

    For performance analysis, you can go to SE30. and get the analysis of the loops and the statements. you can figure out which statement is less efficient. You can check the tips& tricks by SAP in this transaction. in Se30, press F6 for the tips.

    You can compare your SQL statements with the SAP example statements and figure out the problem.

    Or can you paste the code here in the forum.

    Reward points , if helpful.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2007 at 05:51 PM

    do this

    select fields from table into table itab

    for all entries in itab2

    where etc etc...

    to improve performace

    use

    1. for all entries dont use select endselect or loop

    2. specify exactly which fields u want not *

    3. Specify the key fields in where clause in the same order the appear in SE11.

    Message was edited by:

    Nehal Fonseca

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2007 at 05:53 PM

    Hi,

    You have to get the all the related by specifying the condition in thw where condition into different internal tables.

    Then loop the main internal table and read the other tables by this you can improve the performance of the report.

    If you want us to help in better way, please provide your brief requirement.

    Thanks,

    Sriram Ponna.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2007 at 07:25 PM

    Hi Venu,

    Without looking at the code, I think no one can give any suggestions...

    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.