topic Re: performance doc in Application Development and Automation Discussions

performance doc

Former Member — Fri, 31 Aug 2007 06:32:42 GMT

Hi,

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

to venkat_mcaicwa@rediffmail.com.

Regards.

venkat

seshatalpasai_madala — Fri, 31 Aug 2007 06:35:43 GMT

Hi,

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

This documentation is enough to get an idea.

Regards,

Sesh

Former Member — Fri, 31 Aug 2007 06:37:23 GMT

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 — Fri, 31 Aug 2007 06:42:25 GMT

Basically, most effected area for performance is data extraction.

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

Avoid duplicate selects, etc.

Regards,

Amit

Reward all helpful replies.