topic Re: Sql duration in Application Development and Automation Discussions

Sql duration

rodrigo_paisante3 — Thu, 12 Apr 2007 12:18:19 GMT

Hi all,

I just start to work with abap. I want to know if exist a transaction to see the sql duration and performance, or compare two sql performance. In sap academy i saw one transaction like this, but i dont remeber.

Thanks in advance

Paisante

Re: Sql duration

Former Member — Thu, 12 Apr 2007 12:36:05 GMT

you can use st05 to find the performance of each select.

u can use se30 - runtime analysis to find which part of your code is taking more time.

using st05:

activate the trace --> execute the program --> deactivate the trace --> display trace.

then go to Tracelist --> Summarize trace by SQL statements.

here u can analyse performance of all the selects.

If you want to compare the duration by the selects in your prog itself then use: GET RUNTIME statement.

**reward if helpful

regards,

madhu

Re: Sql duration

Former Member — Thu, 12 Apr 2007 12:44:03 GMT

Hi ,

se30 is the transaction that you are looking for.

If you click on the Tips and Tricks button, you will get a split editor, wherein you can execute and compare two codes.

Regards,

Ravi

Re: Sql duration

Former Member — Thu, 12 Apr 2007 12:47:49 GMT

You can also execute this program RSHOWTIM