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 |
I want some questions in SAP -ABAP,programming side
can onyone tell me , how many data classes and size categories are there ?
What are the fields in the memory table ‘screen’?
In scripts, i have 10 address lines there were blanks in between rows how can i avoid those
Different types of luws. What are they?
What is a table attribute?
What is the structure of CTU PARAMS ?
How to use messages in lists?
What is the logo in sap script?
What is logical database? : abap hr
hi this is ramu.my question is :set-screen,call-screen and leave screen differences and when we use those statement while implimenting code.please help me .iam in trails now..
1.Have you created custom table? Do you always use existing data elements and domains or create new ones? whatis the transaction code to see existing data elements and domains? 2.Performance wise inner join is better or For..ALL entries? why? 3.Where will you place data element domain and field together in an ABAP Program? 4.How will you pass the data/programs from one system to other system? 5.How will you print TOP-OF-PAGE in ALV Report?How will you make ALV Report interactive? 6.In Interactive report if i try to go to 20th list and my report has only 19 list what will be output? 7.Have you worked on Function Modules?How will you raise EXCEPTIONS in function modules? 8.Why you say Call transaction is faster than session? 9.How the business is carried out in your organisation?How did you get specs for coding ? Explain me complete step by step scenario from client deciding to switch SAP to your role of coding and after coding explain me how the object reaches back to client? Dont explain me about 5 phases like Business blueprint,realization etc? 10.To find User exit in SD module we can use development class VMOD and find out related exits. Which development class you use for MM FICO and PP Modules?