u r running a report .it is taking a long time for execution
.what steps will u do to reduce the execution time?
Answer Posted / medepalli.sunil@gmail.com
If the report is taking time to fetch data from the database
server we have to make sure that there is an optimized
"query". In order to have an optimized query we need to
write an optimized "where" conditions. That's database part.
Coming to the Programming part.
Say example. Our program has the usage of 95% and the
database usage of 5 % then we have to see the program's
performance. Try to reduce the number of LOOP's in a program
and also try to use the logical operators where ever
necessary to reduce the size of the program . that could
solve the problem.
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are the techniques involved in using sap supplied programs?
What are the page windows?
Explain what is step-loop? Explain all the steps?
How did you test the form you developed? How did you taken print?
What is dynamic action? : sap abap hr
What are the main uses of the primary key?
How is conversion of data types done between abap/4 & external level?
What is the use of enqueue function module? : sap abap data dictionary
difference between Valuation type and valuation category?
what is mean be On Change of in Control Break statement
What are the different methods of passing data?
What are different types of parameters?
Difference between function group and function module?
What are indexes? : abap hr
What is the difference between skip and reserve?