Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

u r running a report .it is taking a long time for execution
.what steps will u do to reduce the execution time?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different kinds of lock modes?

1064


What is the different between abap and ooabap? Why do we use ooabap?

1187


Can you assign a matchcode object to a parameter? If so how?

1044


What is the difference between dialog program and a report?

1084


If a table that is to be extended contains a long field, we cannot use append structures why? : abap data dictionary

1170


Explain the difference between open_form and close_form?

1013


Final class

1547


What is sap abap data dictionary?

1119


How to read files and process BDC's automatically ?

2094


Explain pai and pbo.

1234


What are the different abap editors? What is the used of different editors in abap?

1055


What is meant by a schema? : sap abap hr

1152


can any one answer these questions 1)How do you convert non-character field to character field? 2)How do you work with semi colon separated files? 3)why cant we use normal function module for data transfer? 4)what is the structure of CTU-PARAMS? 5)can we use transfer dataset to transfer data in internal table?

2002


Explain the use of insert and append statement in sap abap?

1087


Can a domain, assigned to a data element be changed?

1084