topic Re: Performance issue in report in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue-in-report/m-p/7066597#M1504118 <HTML><HEAD></HEAD><BODY><P>discussed maybe several hundret times:</P><P></P><P>Use a SORTED table for the second internal table, the key must correspond to the WHERE clause.</P><P>Then performance will be fine.</P><P></P><P>If you must use a standard table, then you must optimize it yourself, READ BINARY ... LOOP FROM INDEX ... search the form.</P><P></P><P>Siegfried</P></BODY></HTML> Thu, 08 Jul 2010 09:22:05 GMT Former Member 2010-07-08T09:22:05Z Performance issue in report https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue-in-report/m-p/7066595#M1504116 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Developed a report with loops..where its taking somuch of time to give the output in PRD server..in loop 1st internal table has 970 records,so its running in the loop 970 times and coming out and again reading another loop with number of records in its internal table so its taking somuch of time to give output....is there any other solution to fasten the prorgam..its a costing report..</P><P></P><P>Regards,</P><P>Venkat.</P></BODY></HTML> Thu, 08 Jul 2010 06:53:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue-in-report/m-p/7066595#M1504116 Former Member 2010-07-08T06:53:36Z Re: Performance issue in report https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue-in-report/m-p/7066596#M1504117 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Before posting you blog, Please search on SDN.</P><P></P><P>Mean while following blog will help you.</P><P></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="1715097"></A></P><P></P><P>Kind Rgds</P><P>Ravi Lanjewar</P></BODY></HTML> Thu, 08 Jul 2010 08:54:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue-in-report/m-p/7066596#M1504117 ravi_lanjewar 2010-07-08T08:54:56Z Re: Performance issue in report https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue-in-report/m-p/7066597#M1504118 <HTML><HEAD></HEAD><BODY><P>discussed maybe several hundret times:</P><P></P><P>Use a SORTED table for the second internal table, the key must correspond to the WHERE clause.</P><P>Then performance will be fine.</P><P></P><P>If you must use a standard table, then you must optimize it yourself, READ BINARY ... LOOP FROM INDEX ... search the form.</P><P></P><P>Siegfried</P></BODY></HTML> Thu, 08 Jul 2010 09:22:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue-in-report/m-p/7066597#M1504118 Former Member 2010-07-08T09:22:05Z Re: Performance issue in report https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue-in-report/m-p/7066598#M1504119 <HTML><HEAD></HEAD><BODY><P><SPAN __jive_macro_name="thread" id="1283414"></SPAN></P><P>Thread locked.</P><P>Thomas</P></BODY></HTML> Thu, 08 Jul 2010 09:40:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance-issue-in-report/m-p/7066598#M1504119 ThomasZloch 2010-07-08T09:40:23Z