Problem in collect statement

[Former Member]

hi,

I am using Collect staement into an internal table for calculating total from General Ledger Details.which is having arround 60000 records. This loop Statement taking more time.For improveing the performance for the particular loop statment what should i do?..

LOOP AT LT_FAGLFLEXT INTO LS_FAGLFLEXT .

CLEAR : GV_MESSAGE , GV_PERCOUNT.

GV_MESSAGE = TEXT-023. "' Calculating totals from General Ledger Details'.

PERFORM PROGRESS_INDIACTOR USING GV_PERCOUNT GV_MESSAGE .

COLLECT LS_FAGLFLEXT INTO LT_COLLECT_FAGLFLEXT.

CLEAR LS_FAGLFLEXT .

ENDLOOP.

Thanks & Regards

Shubh

[Former Member]

Hi Shubh,

I don't think that the problem is with collect statement. I didn't see that there is any change in the parameters GV_PERCOUNT and GV_MESSAGE passed to the routine PROGRESS_INDIACTOR. So you can call this perform outside the loop which will increase the performance a lot.

Let me know if the problem still persists.

Thanks,

Kiran.