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