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 is the program flow of BADI(step by step)?

2 Answers   HP,

---

what are Program Events and Run time Events in Reports

1 Answers   TCS,

---

How data is stored in cluster table?

2 Answers  

---

what are logical and physical databases

1 Answers  

---

What is the tcode to create indexes?

0 Answers  

---

How to set an Enhancement point for a custom report?

0 Answers   HCL,

---

Can you create a field without data element domain?

9 Answers   Satyam, Wipro,

---

How to combine multiple billing into one RV document ( Step by Step)?

0 Answers  

---

What are the domains and data element?

0 Answers  

---

final entry BDC table?

3 Answers  

---

can we transport text elements and text symblos in reports from devlopment to quality?is it necessary?

1 Answers  

---

Which one of the following statements would occur in the PBO of a dialog program using table control? a) module user_command. b) set screen '0100'. c) loop at itab. d) loop at itab with control itab_tc.

2 Answers  

---