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 |
What are the developments you have done with Modulepool?
What are plan versions used for? : sap abap hr
What is elementary search help? : sap abap data dictionary
What is the difference between tables and structures?
What is Buffering Concept? When should a Table be buffered?
2 Answers Cadila, IBM, ITC Infotech,
What is the lock object?
How can you change properties of screen elements dynamically in Module pool Programming ?
Explain what are the steps in the SD process at least up to the invoicing stage?
How would you suppress the display of a parameter on the selection screen?
in report gui we are giving customer number if it is wrong entry then how to write the code to restrict wrong entry?
Can we include customizing include or an append structure with pooled or cluster tables? : abap data dictionary
Do we have to migrate all sapscript forms to smart forms?