u r running a report .it is taking a long time for execution
.what steps will u do to reduce the execution time?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / jesuvin
Performance of reports could be increased by avaioind nested
select statements. Instead use Select ... FOR ALL ENTRIES.
Restrict the use of Select... Endselect, instead go for
select .. inot table itab and then loop at itab.
Avoid nested loop statement, Do not use select within loop.
Do not call function module within loop statement.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sreedhar
use performance tuning steps to get good performance of ur
program.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / venkateswarlu.bandi
Hi this is venkatesh,
this is my answer.
if it is too big means that is submitted into the
background processing.
that is which is using the standard program RSBDCSUB.
that is done by go thorugh transaction code is sm35.
atually all large programs are done by the background
porcessing only.
Is This Answer Correct ? | 0 Yes | 7 No |
Difference between Read and Get cursor?
wat is the significance of keyword " LIKE ".
what is DATA ,TYPES,PaRAMETERS called in ABAP terms?
how to make split command reusable?
how to transport query?
What are internal tables? How do you get the number of lines in an internal table? How to use a specific number occurs statement?
does select single *.. / select * .. affect performance ? how?
what is the diffreence between sap memory and abap memory plz give the example
What are user exits? What is involved in writing them? What precautions are needed?
What is macro? : abap hr
I am getting the (first) page number and the remaining records displayed in another list in another page BUT the PAGE Number is not displayed? What is the code/solution?
how to field properties are set with **** as a password.
1 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,