Skip to Content

How to optimize FETCH NEXT CURSOR

Hi All;  

  I am in charge of optimizing an ABAP Code. After debugging the program I found that the most CPU consuming operation is :

FETCH NEXT CURSOR s_cursor

                   INTO CORRESPONDING FIELDS OF TABLE t_table

                   PACKAGE SIZE s_s_if-maxsize.

How Can I reduce the execution time of this code to get a better performance of the ABAP program.

Regards

Anis

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 05, 2015 at 09:54 AM

    I can see immediately this is a BI/BW extractor. (or similar).

    You have to find the OPEN CURSOR that defines the selection, and optimise that. On the BI/BW end, you may be able to get better performance by tweaking the package side.

    Add comment
    10|10000 characters needed characters exceeded

    • As I said.

      You have to find the OPEN CURSOR that defines the selection, and optimise that.


      But in your first post you said it was a high cpu problem. Now you're saying it's an out of memory problem. Which is it?


      Also, is this a standard extractor or a custom (generic) one?

  • avatar image
    Former Member
    Jan 05, 2015 at 03:04 PM

    Please post the WHERE clause.

    Rob

    Add comment
    10|10000 characters needed characters exceeded