topic Re: Performance issue in Application Development and Automation Discussions

Performance issue

Former Member — Thu, 29 Mar 2007 06:17:43 GMT

Hi ,

I am accessing table mseg . But the condition is such that i cannot use the key fields . The field that i can use is CHARG wich is not a primary key . In run time analysis the database usage is going near to 35 % . Is their any solution to reduce the database usage % .

Neetesh

Re: Performance issue

Former Member — Thu, 29 Mar 2007 08:04:55 GMT

Here are some of the steps which might help you to improve the performance of your program ...

refer

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp

Regards,

Santosh

Re: Performance issue

Former Member — Thu, 29 Mar 2007 08:37:51 GMT

Hi Neetesh,

creating an index will help in improving the performance.

u can use ST05 to know the select statements causing performance problems. then tune the same

if you are using for all entries, see u have deleted the duplicate entries and check if the internal table is initial prior to that.

u can go throught the below blog for more details:

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap%2bperformance%2band%2btuning

regards,

madhu

Re: Performance issue

Former Member — Thu, 29 Mar 2007 14:24:17 GMT

Hi Neetesh,

The best way to improve performance is to create index on CHARG field. But SAP suggests no more than 3 indexes for a transactional table and no more than 10 for a master data table. So take care of the existing Indexes.

Other things you can keep in mind are

In the select query the order of selected fields should be same as in the table.

In where condition also keep the order of fields same as in the table

if you are selecting data from for some values in an existing internal table then sort that internal table in order as mentioned in where clause and dontr forget to check table not initial before select query.

Reward points if helpful

Regards,

Pankaj Sharma