08-31-2007 5:10 AM
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.
08-31-2007 6:05 AM
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.
08-31-2007 5:27 AM
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.
08-31-2007 5:34 AM
Hi..Naveena..
If u paste the Code it is easy to identify the issues.
Regards.
Varma
08-31-2007 5:45 AM
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
08-31-2007 5:54 AM
08-31-2007 6:05 AM
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.