Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Performance Issues

Former Member
0 Kudos

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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.

5 REPLIES 5

kiran_k8
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

Hi..Naveena..

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

Regards.

Varma

Former Member
0 Kudos

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
0 Kudos

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.