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.

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.

Answer / sreedhar

use performance tuning steps to get good performance of ur
program.

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.

What are the two ways for restricting the value range for a domain? : sap abap data dictionary

0 Answers  

---

what is Delivery? In which tables delivery data will be stored?

2 Answers   Accenture,

---

how to capture the errors in bdc Call transaction method?

0 Answers  

---

I have two pages, In one page I want address, Header, Main & footer. In the second page I want only Main. How to do it?

1 Answers  

---

How to eliminate duplicate entries in internal tables?

0 Answers  

---

What are the table controls in bdc ? What is the difference between bdc and lsmw ?what is the difference between bdc and rfc ? : abap bdc

0 Answers  

---

How do u test a script?

2 Answers   IBM,

---

How to find the return code of a stmt in ABAP programs?

1 Answers  

---

While picking can the pick list be updated automatically?

1 Answers  

---

when you are using 2 internal table in program, you have decided to use for all entries statement to retrieve data but unfortunately there are no records in the first internal table. What will be the result? (2nd internal table contains records).

4 Answers  

---

How do u set up background jobs in SAP? What r the steps? What are the event driven batch jobs?

0 Answers  

---

Which function module reads the data for particular infotype ? : abap hr

0 Answers  

---