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 is the difference between a structure and a table? : abap data dictionary
What is locking? : abap data dictionary
How do you take care of performance issues in your ABAP programs?
What is the purpose of creating symbolic a/c, what is transaction code for same? Can we assign one symbolic a/c to multiple wage types? : sap abap hr
What is ps structure? : abap hr
what next in SAP-ABAP/4 is it going to be change?
What are the dis-advantages of logical databases? : abap hr
What is an abap?
What are base tables of an aggregate object?
Write an abap program for creation of customer enquiry using BAPI 'BAPI_INQUIRY_CREATEFROMDATA'.
What are the names of the function modules that will be generated upon activation of a lock object?
Can any tell me ECC 5.0, ECC 6.0 Released year? and difference between them?
Difference between user exit and badis?
Is sap xi intended to replace ale?
What does an exec sql statement do in abap? What is the disadvantage of using it?