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 is user specific parameter?
In a loop of an internal table, what is the use of at first & at last statements?
Can we set page headers to details lists?
why cluster tables are not buffered
What is modularization and its benefits? : abap modularization
what data types allows length specification ?
Explain the types of bdc's?
What is the t-code to display batch input sessions? : abap bdc
4.why dont use start form in script?
when u prefer lsmw?
What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?
what is meant by filtration in alv? how to do it?
1 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,