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

how to see the table output?

2253


How will you find manager of an employee

1387


What are the 3 types of tables in sap? : abap data dictionary

1144


What is the use of table maintenance allowed?

1112


Name the function module used to convert logical file names to physical file names in abap/4 programs?

1221


How to do find it?

1071


What are indexes? : sap abap data dictionary

1225


Explain buffering concept usage?

1057


What is the difference between sum and collect?

1699


What function does data dictionary perform?

1196


Application Category?

1436


What is meant by hotspots?

1252


What is the process to enhance the Infotype

3455


What are the properties of selection screen?

1099


What is an interactive report? What is the obvious difference of such report compared with classical type reports?

1029