topic Parallel Cursor Technique in Application Development and Automation Discussions

Parallel Cursor Technique

Former Member — Tue, 30 Sep 2008 05:03:26 GMT

Hello,

Can some one give me a description in detail as to what exactly Parallel cursor method is and how it works.

Also, what are the Performance Tuning Techniques that we can follow during ABAP Development?

Thanks and Regards,

Venkat

Re: Parallel Cursor Technique

Former Member — Tue, 30 Sep 2008 05:09:28 GMT

Hi Venkat,

Check this thread with the same topic:

Regards,

Chandra Sekhar

Re: Parallel Cursor Technique

Former Member — Tue, 30 Sep 2008 06:58:02 GMT

Thread Answered.

Thanks and Regards,

Venkat Phani Prasad Konduri

Re: Parallel Cursor Technique

Former Member — Tue, 30 Sep 2008 07:33:46 GMT

actually, I would not recommend the parallel cursor technique! First name is actually incorrect internal tables have no cursor only indexes, only parallel

index would make sense.

Performance improvement:

If costs for sort are taken into account, then parallel index is not faster than loop with loop on sorted table.

or with standard table


loop
    read ...  binary search
    index = sy-tabix    
    loop ... from index
       if  ( condition is not fulfilled )
          exit
       endif.
    endloop
endloop

The full parallel index technique should find all deviations between 2 tables, additional lines in Tab1, additional lines in tab2, changes.

Feel free to find a complete solution. We can compare results, it is not worth the effort!

Siegfried