topic Re: Program executing time (St05 results) in Application Development and Automation Discussions

topic Re: Program executing time (St05 results) in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/program-executing-time-st05-results/m-p/4916585#M1147620 <HTML><HEAD></HEAD><BODY><P>It would help to see the original ABAP SELECTs rather than the output from the explain.</P><P></P><P>Rob</P></BODY></HTML> Mon, 08 Dec 2008 19:47:46 GMT Former Member 2008-12-08T19:47:46Z Program executing time (St05 results) https://community.sap.com/t5/application-development-and-automation-discussions/program-executing-time-st05-results/m-p/4916582#M1147617 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>I am working on an issue where a program is taking a huge time to execute...I tried to run the trace on using ST05 and found the following arears which are taking more time, so can you please suggest me what should I do with this to increase the efficiency of the program:</P><P></P><P>1. SELECT</P><P> "OBJECTID" "PONUMBER" , "USERNAME" , "UDATE" , "UTIME" , "CHANGENR" ,</P><P> "CHANGE_IND" </P><P> FROM</P><P> "CDHDR"</P><P> WHERE</P><P> "MANDANT" = ? AND "OBJECTCLAS" = ? AND "OBJECTID" IN ( ? , ? , ? , ? , ? , ?</P><P> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,</P><P> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?</P><P> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,</P><P> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?</P><P> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,</P><P> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?</P><P> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,</P><P> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?</P><P> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,</P><P> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?</P><P> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,</P><P> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?</P><P> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,</P><P> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?</P><P> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,</P><P> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?</P><P> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,</P><P> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?</P><P> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,</P><P> ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?</P><P> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) WITH</P><P> UR OPTLEVEL( 5 ) QUERY_DEGREE( 1 ) )</P><P> </P><P></P><P>2. </P><P></P><P>SELECT</P><P> T_00 . "EBELN" "PONUMBER" , T_00 . "EBELP" "LINE_NO" , T_00 . "DMBTR" ,</P><P> T_00 . "CPUTM" , T_00 . "ERNAM" ,</P><P>FROM</P><P> "EKBE" T_00 , ( SELECT * FROM ( VALUES ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ), ( CAST ( ? AS VARCHAR(30) ) ),</P><P> ( CAST ( ? AS VARCHAR(30) ) ) ) AS T_01_TMP ( "C_01" ) GROUP BY "C_01" ) AS</P><P> T_01</P><P>WHERE</P><P> T_00 . "MANDT" = ? AND T_00 . "EBELN" = T_01 . C_01 AND T_00 . "DMBTR" <> ? </P><P></P><P>and </P><P></P><P>3. </P><P>SELECT</P><P> "MANDANT" , "OBJECTCLAS" , "OBJECTID" , "CHANGENR" , "PAGENO" , "TIMESTMP" ,</P><P> "PAGELG" , "VARDATA"</P><P>FROM</P><P> "CDCLS"</P><P>WHERE</P><P> "MANDANT" = ? AND "OBJECTCLAS" = ? AND "OBJECTID" = ? AND "CHANGENR" = ?</P><P>ORDER BY</P><P> "MANDANT" , "OBJECTCLAS" , "OBJECTID" , "CHANGENR" ,</P><P></P><P>Thanks, </P><P>Rajeev Gupta</P></BODY></HTML> Mon, 08 Dec 2008 12:56:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/program-executing-time-st05-results/m-p/4916582#M1147617 Former Member 2008-12-08T12:56:08Z Re: Program executing time (St05 results) https://community.sap.com/t5/application-development-and-automation-discussions/program-executing-time-st05-results/m-p/4916583#M1147618 <HTML><HEAD></HEAD><BODY><P>please try, aggregation go to Table -> Summary of SQL Statement</P><P></P><P>Each of your statements should be visible as one line. What are the values for:</P><P></P><P>Table:</P><P>Duration:</P><P>Exec:</P><P>Rec:</P><P>Mintime/R:</P><P>Ident:</P><P></P><P>Which database are you using? Go the system -> status</P></BODY></HTML> Mon, 08 Dec 2008 13:43:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/program-executing-time-st05-results/m-p/4916583#M1147618 Former Member 2008-12-08T13:43:55Z Re: Program executing time (St05 results) https://community.sap.com/t5/application-development-and-automation-discussions/program-executing-time-st05-results/m-p/4916584#M1147619 <HTML><HEAD></HEAD><BODY><P>we are using DB6...but my concern is I haven't developed this program, so I was just wondering if the statements that I put in my post are written in the right way or do I need to do some performance analysis there???</P><P></P><P>Thanks, </P><P>Rajeev</P></BODY></HTML> Mon, 08 Dec 2008 19:40:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/program-executing-time-st05-results/m-p/4916584#M1147619 Former Member 2008-12-08T19:40:08Z Re: Program executing time (St05 results) https://community.sap.com/t5/application-development-and-automation-discussions/program-executing-time-st05-results/m-p/4916585#M1147620 <HTML><HEAD></HEAD><BODY><P>It would help to see the original ABAP SELECTs rather than the output from the explain.</P><P></P><P>Rob</P></BODY></HTML> Mon, 08 Dec 2008 19:47:46 GMT https://community.sap.com/t5/application-development-and-automation-discussions/program-executing-time-st05-results/m-p/4916585#M1147620 Former Member 2008-12-08T19:47:46Z