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 a multiple line field? : abap bdc

1029


What are the events in abap/4 language? : abap hr

1026


What are the different types of luws. What are they?

1101


Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul

3642


What is the maximum No. Of structures that can be included in a table or structure. : abap data dictionary

1101


Explain the call transaction method? : abap bdc

1043


What is the meaning of table buffer? This buffer is used by which type oftable?

1160


What is the difference between RETURNING and CHANGING parameters for a method?

1676


What is a bsp application? : sap abap hr

1059


Explain open dataset in sap abap?

1252


In what ways we can get the context sensitive f1 help on a field?

1031


How to insert a line into abap internal tables?

1021


What are the different database integrities?

983


What data is contained? : abap data dictionary

1061


Explain get pernr concept when we use logical data base? : abap hr

1170