Do you use select statement in loop end loop, how will be
the performance? To improve the performance?
Answers were Sorted based on User's Feedback
Answer / sukhbir
Best option will be to select the data before loop and
inside loop use read statement.
select f1 f2 f3(key fields) from db into
iNtertab
for all entries in itab
where condition.
sort intertab by f1.
loop at itab.
read intertab with key f1 = itab-f1
binary search.
Endloop.
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / jammy
No, It is not recommended to do that as it kills the
performance.
Is This Answer Correct ? | 4 Yes | 2 No |
What does nw 7.4 sp 05/nw 7.5 sp 02 offers in abap?
what is the model dialog box?
1 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,
What are the pooled and cluster tables?
What are the modes in lock objects? : sap abap data dictionary
20) What is the difference bewtween client dependent tables and client independent tables?
How can i insert a field in script without using executable program
What is the difference between a structure and a table?
What is the meaning of table buffer? This buffer is used by which type oftable?
What is RFC function module?
what are the diff page formats available in SMARTFORMS ?
1/ what r the driver programe used in your script ? 2 / can we change from classical report to interactive report ?
will join conditions in sql queries affect perfomance? how?