Some Query

[Former Member]

Hello Guys.

I have some doubt. Please Guide me.

1. How do I check performance of my code with st05 and se30.

2. What are the difference between se01, se09 and se10.

3. How I can Avoid the loop statment in my program . read statment is ok

but when required the summation , other then loop which is performace base best statment.

please provide the answer.

Thanks

Swati....

[Former Member]

Hi swati,

1 . sto5 is trace requests.. It is used to check sql statements.. open st05 and run sql trace and open other session and run your prog.. when prag is executed turn off sql trace and then goto trace-> list trace to check for the sql statements taking more time and other .. se30 is performance tuning purpose where u give ur prog name or report or transaction and execute and the performance of ur report.. you can know the split up of time for database , abap etc.. based on that you can try for reducing database query time..

2. se09 and se10 are the same i.e for releasing transport requests but se01 is detailed transport request where u can know lot of details abt transport requests.. generally se01 is not given permission for abapers and it lies with basis guys..

3. loop statement does not effect performance .. only if you have some select statements inside loop it ceates prob.. read is ok to read data from internal table .. you should use it when data is already extracted to internal table instead of using select statement as it occurs in appl server and select usess database server..

hope it helps..

Award marks if helpful