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 a multiple line field? : abap bdc
What are the events in abap/4 language? : abap hr
What are the different types of luws. What are they?
Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul
What is the maximum No. Of structures that can be included in a table or structure. : abap data dictionary
Explain the call transaction method? : abap bdc
What is the meaning of table buffer? This buffer is used by which type oftable?
What is the difference between RETURNING and CHANGING parameters for a method?
What is a bsp application? : sap abap hr
Explain open dataset in sap abap?
In what ways we can get the context sensitive f1 help on a field?
How to insert a line into abap internal tables?
What are the different database integrities?
What data is contained? : abap data dictionary
Explain get pernr concept when we use logical data base? : abap hr