Wednesday, August 1, 2007

Performance Tuning

1.

What are ST05 and SE30 used for?

ST05 SQL Trace transaction

SE30 Run time analysis transaction

2.

What are simple rules for increasing performance?

a. Do not use nested loops / select statements.

b. Always use where in select query.

c. Select only required fields

d. Avoid Select – Endselect instead use Into table

e. Modularize the code.

f. Avoid using move corresponding

g. Always check for sy-subrc before sorting, read, select statements and where ever necessary.

h. Perform code inspector check

3 comments:

Anonymous said...

Usually I do not learn articlе on blogs, but I ωoulԁ like
to sаy that this ωгitе-uр ѵery pressured me to check out аnd ԁo іt!
Your writіng style has been аmazed me.
Thanks, quite great ρost.

Ηere is my blog post dev.lefam.org

Anonymous said...

Its like you lеarn my mind! You seem to underѕtand a lot about this, ѕuch aѕ you ωrote the е book іn it
οr something. I believe thаt you just could do with ѕomе % to pressure the message house a little bit, but instead of that, this is fantastic blog. An excellent read. I'll certainly be back.

Feel free to surf to my web blog; Chatroulette Alternative

Anonymous said...

It is not my firѕt time to go to seе thiѕ wеb
page, i аm browѕing this web sіte dailly anԁ take good
data frοm hеre evеryday.

my wеbsite; Premature Ejaculation Training