topic Performance Issues in Application Development and Automation Discussions

Performance Issues

Former Member — Fri, 31 Aug 2007 04:10:29 GMT

hello all,

i have a report with some select statements and read statements and sort and loop etc.,

Now the running time of the report takes more than 5 minutes.. because there is a huge number of records...

now, what makes this to happen.. how can i reduce the accessing time to the database..?

pls give me some tips on how to increase the performance.?

thanks in adv.

Re: Performance Issues

kiran_k8 — Fri, 31 Aug 2007 04:27:39 GMT

Naveena,

5 minutes in Production is very well acceptable.

You can check in these areas to improve performance.

1.Always see that you select statement is having either primary key field or an index field in its where clause.Rather I say it is must to improve the perfornamce.

2.While reading the internal table use binary search.

K.Kiran.

Re: Performance Issues

varma_narayana — Fri, 31 Aug 2007 04:34:23 GMT

Hi..Naveena..

If u paste the Code it is easy to identify the issues.

Regards.

Varma

Re: Performance Issues

Former Member — Fri, 31 Aug 2007 04:45:40 GMT

i got the same problem once

at that time my basisi people reduced the parameter load by going to some transaction

for my program it is taking more than 5 min to execute finally its showing short dump

the problem with the select statement at that time

so the basisi people reduced that load on that parameter

from next time on words that executed very fast

reward if useful

Re: Performance Issues

Former Member — Fri, 31 Aug 2007 04:54:21 GMT

http://www.erpgenie.com/abap/performance.htm

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

Re: Performance Issues

Former Member — Fri, 31 Aug 2007 05:05:36 GMT

Hello Naveena,

Only select statements you can use to retrive data from database. here no problems.

But never try to inner join more than three tables in a select statment. Here performance will be poor.

Coming to the case of selecting one record in a loop: Use read statement instead of select single.. .

Using sort you can delete adjacent duplicates and while searching you can use binary search technique. This will increase performance.

For more tips....

Go to SE30. There You can find one button <b>Tips & Tricks</b> or Press <b>F6</b>. there you can find lot of tips.

Reward If Helpful.

Regards

Sasidhar Reddy Matli.