Skip to Content
0
Former Member
Jan 06, 2011 at 06:26 AM

Need to Optimize LOOP statement.

1183 Views

Hi,

For Performance optimization I added READ with BINARY SEARCH instead SQL Query this part is working better.. But replacing SQL with LOOP ENDLOOP. is making the performance worse..

Below is the code for LOOP:

LOOP AT IT_OPS_BOM WHERE slot EQ zslot

AND zsku(11) EQ tmp_opsbom-zsku(11)

AND ZCOMP = ' '.

*Do some logic

ENDLOOP.

Can we do someting to Furthur optimize the LOOP.. ENDLOOP.. part?

No. of Records in IT_OPS_BOM is more than 2 Lac.

Thanks,

Preyansh