what happend if a select statement inside aloop....
Answers were Sorted based on User's Feedback
Answer / madhavi
nothing will happen, but sure there will be a performance
issues,.
because for every step it hits the database to seach for
the record based on condition.
so, this is not suggestable.
Is This Answer Correct ? | 20 Yes | 0 No |
Answer / saplead.sai
There are cookbook rules in PERFORMANCE issues that are
needed to be addressed while coding. One of those rules
being .. Not to use a SELECT statment in a loop - Reason
(The basic idea of querry is to limit DB hits).
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / aashish mehta
It is not suggested to use select with in the loop as it is
related with the performance.
Is This Answer Correct ? | 7 Yes | 0 No |
Filter badi and multiple used badi? Will the sequence matter of the badi implementation in case of multiple used badi?
what is difference between MOVE and MOVE-CORRESPONDING?
1.how to developed inreractive report 2.how to developed classicall report.
What is pseudo comment (#EC) and How it is different from normal comments(i.e. '*' and '"')
What is a multiple line field? : abap bdc
what is user specific parameter?
What is an abap data dictionary? : abap data dictionary
When using call transaction method for 1000 records , If u found error in 64th record then how can u find it and how can u send this to user
what is a buffer and how many types?
in an interactive report i want to trigger both 'at line selection' and 'user command'....if possible then how?
Explain the difference between domain and data element? What are aggregate object?
If I want to execute a bdc program only in background not in foreground is there any option for this? : abap bdc