performance doc

[Former Member]

Hi,

can any one please send a document to improve the performance of programe

to venkat_mcaicwa@rediffmail.com.

Regards.

venkat

[seshatalpasai_madala]

Hi,

Check SE30 and there click on the button Trips & Ticks.

This documentation is enough to get an idea.

Regards,

Sesh

[Former Member]

Hello Venkat,

i'm sending document to ur mail id.

some more info:

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 Tips & Tricks or Press F6. there you can find lot of tips.

Reward If Helpful.

Regards

--

Sasidhar Reddy Matli.

Message was edited by:

Sasidhar Reddy Matli

[amit_khare]

Basically, most effected area for performance is data extraction.

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

Also, check for nested loops & using Select under loops.

Avoid duplicate selects, etc.

Regards,

Amit

Reward all helpful replies.