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 is the difference between a structure and a table? : abap data dictionary

1037


What is locking? : abap data dictionary

1098


How do you take care of performance issues in your ABAP programs?

1085


What is the purpose of creating symbolic a/c, what is transaction code for same? Can we assign one symbolic a/c to multiple wage types? : sap abap hr

1234


What is ps structure? : abap hr

1323


what next in SAP-ABAP/4 is it going to be change?

2090


What are the dis-advantages of logical databases? : abap hr

1097


What is an abap?

956


What are base tables of an aggregate object?

1059


Write an abap program for creation of customer enquiry using BAPI 'BAPI_INQUIRY_CREATEFROMDATA'.

2149


What are the names of the function modules that will be generated upon activation of a lock object?

958


Can any tell me ECC 5.0, ECC 6.0 Released year? and difference between them?

2436


Difference between user exit and badis?

1101


Is sap xi intended to replace ale?

1040


What does an exec sql statement do in abap? What is the disadvantage of using it?

1176