topic Re: performance in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/2215075#M474841 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Check out this thread</P><P><A href="https://forums.sdn.sap.com/click.jspa?searchID=2440381&amp;messageID=2572547" target="test_blank">https://forums.sdn.sap.com/click.jspa?searchID=2440381&amp;messageID=2572547</A></P></BODY></HTML> Fri, 04 May 2007 20:12:55 GMT Former Member 2007-05-04T20:12:55Z performance https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/2215072#M474838 <HTML><HEAD></HEAD><BODY><P>How to improve performance of a report. My report is taking 1 hr to execute in production.</P><P></P><P>How to use SE30 and ST05 to improve......plz help</P></BODY></HTML> Fri, 04 May 2007 20:05:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/2215072#M474838 Former Member 2007-05-04T20:05:50Z Re: performance https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/2215073#M474839 <HTML><HEAD></HEAD><BODY><P>SM30 is used to measure function and table calls....Just pass the name of the report executed and watch the list....</P><P></P><P>To improve performance...a few tips...</P><P></P><PRE><CODE> * Never use SELECT-ENDSELECT. * Try to use indexes. * Use LOOP ASSIGNING * Don't make unnecessary table reads </CODE></PRE><P></P><P>Greetings,</P><P></P><P>Blag.</P></BODY></HTML> Fri, 04 May 2007 20:11:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/2215073#M474839 Former Member 2007-05-04T20:11:26Z Re: performance https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/2215074#M474840 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please check this links ...</P><P></P><P>SE30:</P><P><A href="http://help.sap.com/saphelp_nw04s/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/frameset.htm" target="test_blank">http://help.sap.com/saphelp_nw04s/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/frameset.htm</A></P><P></P><P></P><P>ST05:</P><P><A href="http://help.sap.com/saphelp_nw04/helpdata/en/17/358df9c9fee2469105731e10756921/frameset.htm" target="test_blank">http://help.sap.com/saphelp_nw04/helpdata/en/17/358df9c9fee2469105731e10756921/frameset.htm</A></P><P><A href="http://www.datamanagementgroup.com/resources/Articles/Article_UsingSAPsSQLTraceTool.asp" target="test_blank">http://www.datamanagementgroup.com/resources/Articles/Article_UsingSAPsSQLTraceTool.asp</A></P><P><A href="http://www.sapbrain.com/TOOLS/SQLTRACE/SQL_TRACE.html" target="test_blank">http://www.sapbrain.com/TOOLS/SQLTRACE/SQL_TRACE.html</A></P><P></P><P></P><P>Regards,</P><P>Ferry Lianto</P></BODY></HTML> Fri, 04 May 2007 20:12:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/2215074#M474840 ferry_lianto 2007-05-04T20:12:43Z Re: performance https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/2215075#M474841 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Check out this thread</P><P><A href="https://forums.sdn.sap.com/click.jspa?searchID=2440381&amp;messageID=2572547" target="test_blank">https://forums.sdn.sap.com/click.jspa?searchID=2440381&amp;messageID=2572547</A></P></BODY></HTML> Fri, 04 May 2007 20:12:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/2215075#M474841 Former Member 2007-05-04T20:12:55Z