u r running a report .it is taking a long time for execution
.what steps will u do to reduce the execution time?
- 4 Answers
- 12375 Views
- Bristle Cone, Cap Gemini, HP, Satyam, Wipro, I also Faced
- E-Mail Answers
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
Difference between top-of-page and top-of-page during at line- selection?
What are the basic functions of database utility? : abap data dictionary
How can you display frames (horizontal and vertical lines) in lists?
Static and instance variable and method with live example. Why and when to use
Hi,have Good Command in SAP ABAP, ABAP WEBDYNPRO now i want to learn sap IS utilities.. can u plz suggest me is it useful r not? If not can i learn BI? Is ABAP with BI have gud future?
Why do we use events and actions in web dynpro?
How do you activate a function exit?
Which function module would you use to check the user’s authorization to access files before opening a file?
What is the diff between database view and maintenance view?
Explain what is sap script?
What is the syntax for call transaction? : abap bdc
1. what is IDOC monitoring ? what is the tcode used for idoc monitoring ? 2 . what is change pointer in ale ?
Does the bdc-insert function allow multiple transactions to be processed by sap? : abap bdc
What are the difference between tables and structures?
What is a development class? : abap data dictionary
