Performance Issues

[Former Member]

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.

[kiran_k8]

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.

[varma_narayana]

Hi..Naveena..

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

Regards.

Varma

[Former Member]

Hi

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

[Former Member]

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

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

[Former Member]

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.