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
how to see the table output?
How will you find manager of an employee
What are the 3 types of tables in sap? : abap data dictionary
What is the use of table maintenance allowed?
Name the function module used to convert logical file names to physical file names in abap/4 programs?
How to do find it?
What are indexes? : sap abap data dictionary
Explain buffering concept usage?
What is the difference between sum and collect?
What function does data dictionary perform?
Application Category?
What is meant by hotspots?
What is the process to enhance the Infotype
What are the properties of selection screen?
What is an interactive report? What is the obvious difference of such report compared with classical type reports?