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 different kinds of lock modes?
What is the different between abap and ooabap? Why do we use ooabap?
Can you assign a matchcode object to a parameter? If so how?
What is the difference between dialog program and a report?
If a table that is to be extended contains a long field, we cannot use append structures why? : abap data dictionary
Explain the difference between open_form and close_form?
Final class
What is sap abap data dictionary?
How to read files and process BDC's automatically ?
Explain pai and pbo.
What are the different abap editors? What is the used of different editors in abap?
What is meant by a schema? : sap abap hr
can any one answer these questions 1)How do you convert non-character field to character field? 2)How do you work with semi colon separated files? 3)why cant we use normal function module for data transfer? 4)what is the structure of CTU-PARAMS? 5)can we use transfer dataset to transfer data in internal table?
Explain the use of insert and append statement in sap abap?
Can a domain, assigned to a data element be changed?