topic Re: performece qustion in Application Development and Automation Discussions

performece qustion

Former Member — Mon, 20 Aug 2007 12:58:28 GMT

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

Re: performece qustion

Former Member — Mon, 20 Aug 2007 13:08:52 GMT

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

Re: performece qustion

Former Member — Mon, 20 Aug 2007 13:25:49 GMT

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

Re: performece qustion

Former Member — Mon, 20 Aug 2007 13:31:02 GMT

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

And yeah 13.5 seconds is a LOT

Re: performece qustion

Former Member — Mon, 20 Aug 2007 14:15:03 GMT

hi florian

the time is in micro second

thankes