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

Performance Tuning - unavoidable nested loops.

Hi Experts,

I need to improve the performance of unavoidable nested loops.

In TIPS&TRICKS of SE300 tool i got PARALLEL CURSOR method to improve the nested loop performance.

I took one program and tested by using both methods...below is the conclusions..

Overall execution time is less in case of PARALLEL CURSOR but time taken in database execution is more in this method (As per SE tool analysis)

Overall execution time is more in case of straight forward nested loops but time taken in database execution is less in this method (As per SE tool analysis)

My doubt is WHICH METHOD I CAN USE....

Please guide me....

Thanks in Advance

Edited by: Julius Bussche on Jan 19, 2009 11:23 AM

Please use meaningfull subject titles

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2009 at 06:27 AM

    Hi Siva,

    While using nested loops...if you have any database fetching statements like Select inside the loop, then better to write a select outside the loop first then, use read statements to read these fetched data as per the selection criteria within the loop.By doing this you can make use of the parallel cursor method very well and the performance of your code will be surely improved as you have not kept any database related statements within the loop.

    Regards,

    Asha

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 19, 2009 at 09:15 AM

    why not continue here?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2009 at 10:48 AM

    Hi,

    check the following links

    /people/siegfried.boes/blog/2007/09/05/the-sql-trace-st05-150-quick-and-easy

    /people/siegfried.boes/blog/2007/11/13/the-abap-runtime-trace-se30--quick-and-easy

    Regards,

    Madhu

    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.