Skip to Content
0
Former Member
Mar 20, 2009 at 02:48 PM

I can't explain this long "Loop-Endloop" duration

16 Views

Hi all,

I have a problem with my report.

In a PERFORM i have this code :

  LOOP AT tg_fagltot.        ======>> This internal table contain 60902 entries

    CLEAR: tg_faglenc, tg_fagldec, tg_faglban, tg_t9fi608.


    READ TABLE tg_faglenc WITH KEY rbukrs = tg_fagltot-rbukrs
                                   ryear  = tg_fagltot-ryear
                                   docnr  = tg_fagltot-docnr.

    READ TABLE tg_fagldec WITH KEY rbukrs = tg_fagltot-rbukrs
                                   ryear  = tg_fagltot-ryear
                                   docnr  = tg_fagltot-docnr.

    READ TABLE tg_faglban WITH KEY rbukrs = tg_fagltot-rbukrs
                                   ryear  = tg_fagltot-ryear
                                   docnr  = tg_fagltot-docnr.

    READ TABLE tg_t9fi608 WITH KEY bukrs = tg_fagltot-rbukrs
                                   prctr = tg_fagltot-prctr.

    CONCATENATE  'tg_zsfi_rept-dmb' tg_fagltot-poper+1(2) INTO lv_dmbt.
    ASSIGN (lv_dmbt) TO <dmbt>.

    CHECK tg_faglenc IS INITIAL AND tg_fagldec IS INITIAL AND tg_faglban IS INITIAL.

    READ TABLE tg_tot WITH KEY bukrs = tg_fagltot-rbukrs
                               prctr = tg_fagltot-prctr.


(....)

ENDLOOP

I put a break-point on the last READ (the one after the chack function) and on the ENDFORM (to see when the program quit the LOOP-ENDLOOP function)

I started to do the function step by step (using F5) for the first entries and there's no function who take big time between the LOOP and the CHECK.

So i decided to press F8 to run the program until my break point (the one after the Check function).

The problem is that it run for 40minutes and never reach any of my 2 break point.

And there's only 60902 lines on the internal tables.

There is no other operation on my server so i don't why it take too much time to do it.

There's is no operation, just the 4 READ functions and the Check. And none of the internals tables have more than 100000 lines

First i thougth it was a performance problem due to my server but apparently not.

Is anybody have an idea of what it could be ?

Thanks

Edited by: Olivier Abbeloos on Mar 20, 2009 3:49 PM

Edited by: Olivier Abbeloos on Mar 20, 2009 3:50 PM