performece qustion

[Former Member]

hi

i use se30 and i get red line with 135,210 = 99.7%

how much time this is in second and if it is good time?

regards

[Former Member]

You can't find the time if you use SE30

Use ST05 Transaction or get run time command.

Goto ST05 Transaction -> trace on -> enter report transaction -> execute -> come back to ST05

Trace off -> list trace

here you will see time ,it will display time for each query

Thanks

Seshu

[Former Member]

Hi Shnya,

Red Line indicates the data base hits to your report/transaction. If it is in between 20% to 35% is a good approach. I think your report/transaction is hitting database many times. Avoid nested loops, nested select, inner joins with more than 3 levels in your report/transaction.

You may not get the same values if you run the report/transaction again.There may be slight differences among the values. Use ST05 to know which selects are taking more time.

Check this link for SE30 and ST05

http://www.thespot4sap.com/articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp

Thanks,

Vinay

[Former Member]

the time given is in milliseconds, so divide it by thousand and you got seconds.

And yeah 13.5 seconds is a LOT

[Former Member]

hi florian

the time is in micro second

thankes