topic Re: Regarding ALV Tuning in Application Development and Automation Discussions

topic Re: Regarding ALV Tuning in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/regarding-alv-tuning/m-p/2429466#M543013 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>make sure the SQL statements is using INDEX for selecting..</P><P></P><P>try using the parallel cursor technique when proessing mulitple internal tables..</P><P></P><P>Thanks</P><P>Naren</P></BODY></HTML> Wed, 20 Jun 2007 06:11:27 GMT Former Member 2007-06-20T06:11:27Z Regarding ALV Tuning https://community.sap.com/t5/application-development-and-automation-discussions/regarding-alv-tuning/m-p/2429465#M543012 <HTML><HEAD></HEAD><BODY><P>I want to create an ALV report to display the Purchase Order Details, the data will come from 4 Database tables,I am extracting the data in 4 internal tables and then clubbing them to one final internal table,but the performance of my program is very bad,please suggest me some way.</P></BODY></HTML> Wed, 20 Jun 2007 06:09:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/regarding-alv-tuning/m-p/2429465#M543012 Former Member 2007-06-20T06:09:55Z Re: Regarding ALV Tuning https://community.sap.com/t5/application-development-and-automation-discussions/regarding-alv-tuning/m-p/2429466#M543013 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>make sure the SQL statements is using INDEX for selecting..</P><P></P><P>try using the parallel cursor technique when proessing mulitple internal tables..</P><P></P><P>Thanks</P><P>Naren</P></BODY></HTML> Wed, 20 Jun 2007 06:11:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/regarding-alv-tuning/m-p/2429466#M543013 Former Member 2007-06-20T06:11:27Z Re: Regarding ALV Tuning https://community.sap.com/t5/application-development-and-automation-discussions/regarding-alv-tuning/m-p/2429467#M543014 <HTML><HEAD></HEAD><BODY><P>Hi Sudhanshu,</P><P></P><P>There are ways to performance tune this.</P><P></P><P>1. Tune the querries to use best index.</P><P>2. USE ALV LIST DISPLAY if the data is more. Do not use grid.</P><P></P><P></P><P>Regs,</P><P>Sameer</P></BODY></HTML> Wed, 20 Jun 2007 06:12:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/regarding-alv-tuning/m-p/2429467#M543014 Former Member 2007-06-20T06:12:14Z Re: Regarding ALV Tuning https://community.sap.com/t5/application-development-and-automation-discussions/regarding-alv-tuning/m-p/2429468#M543015 <HTML><HEAD></HEAD><BODY><P>Could you send the sql statements.</P></BODY></HTML> Wed, 20 Jun 2007 08:48:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/regarding-alv-tuning/m-p/2429468#M543015 Former Member 2007-06-20T08:48:43Z Re: Regarding ALV Tuning https://community.sap.com/t5/application-development-and-automation-discussions/regarding-alv-tuning/m-p/2429469#M543016 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>first avoid occurs o etc.</P><P>delcare internal tables using types for structure and data with header line.</P><P>check for sy-subrc =0. for select statements ,use delete adjacent duplicates.</P><P>if there is large amount of data ise LIST display instead of grid.</P><P>for further performance issues chaeck below links.</P><P>BAP performance depends upon various factors and in devicded in three parts:</P><P>1. Database</P><P>2. ABAP </P><P>3. System</P><P>Run Any program using SE30 (performance analys) to improve performance refer to tips and trics section of SE30, Always remember that ABAP perfirmance is improved when there is least load on Database.</P><P>u can get an interactive grap in SE30 regarding this with a file.</P><P>also if u find runtime of parts of codes then use :</P><P>Switch on RTA Dynamically within ABAP Code </P><P>*To turn runtim analysis on within ABAP code insert the following code</P><P>SET RUN TIME ANALYZER ON.</P><P>*To turn runtim analysis off within ABAP code insert the following code</P><P>SET RUN TIME ANALYZER OFF.</P><P>Always check the driver internal tables is not empty, while using FOR ALL ENTRIES</P><P>Avoid for all entries in JOINS</P><P>Try to avoid joins and use FOR ALL ENTRIES.</P><P>Try to restrict the joins to 1 level only ie only for tables</P><P>Avoid using Select *.</P><P>Avoid having multiple Selects from the same table in the same object.</P><P>Try to minimize the number of variables to save memory. </P><P>The sequence of fields in 'where clause' must be as per primary/secondary index ( if any)</P><P>Avoid creation of index as far as possible</P><P>Avoid operators like <>, > , < & like % in where clause conditions</P><P>Avoid select/select single statements in loops.</P><P>Try to use 'binary search' in READ internal table. Ensure table is sorted before using BINARY SEARCH.</P><P>Avoid using aggregate functions (SUM, MAX etc) in selects ( GROUP BY , HAVING,) </P><P>Avoid using ORDER BY in selects</P><P>Avoid Nested Selects </P><P>Avoid Nested Loops of Internal Tables</P><P>Try to use FIELD SYMBOLS.</P><P>Try to avoid into Corresponding Fields of</P><P>Avoid using Select Distinct, Use DELETE ADJACENT</P><P>Go through the following Document</P><P>Check the following Links</P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="1591512"></A></P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="1429297"></A></P><P><A href="http://www.sapgenie.com/abap/performance.htm" target="test_blank">http://www.sapgenie.com/abap/performance.htm</A></P><P><A href="http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp" target="test_blank">http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp</A></P><P>check the below link</P><P><A href="http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm" target="test_blank">http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm</A></P><P>See the following link if it's any help:</P><P><A href="http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp" target="test_blank">http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp</A></P><P>Check also <A href="http://service.sap.com/performance" target="test_blank">http://service.sap.com/performance</A></P><P>and </P><P>books like</P><P><A href="http://www.sap-press.com/product.cfm?account=&product=H951" target="test_blank">http://www.sap-press.com/product.cfm?account=&product=H951</A></P><P><A href="http://www.sap-press.com/product.cfm?account=&product=H973" target="test_blank">http://www.sap-press.com/product.cfm?account=&product=H973</A></P><P><A href="http://www.sap-img.com/abap/more-than-100-abap-interview-faqs.htm" target="test_blank">http://www.sap-img.com/abap/more-than-100-abap-interview-faqs.htm</A></P><P><A href="http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp" target="test_blank">http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp</A></P><P>Performance tuning for Data Selection Statement </P><P><A href="http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm" target="test_blank">http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm</A></P><P>Run Time Analyser</P><P><A href="http://help.sap.com/saphelp_47x200/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/content.htm" target="test_blank">http://help.sap.com/saphelp_47x200/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/content.htm</A></P><P>SQL trace</P><P><A href="http://help.sap.com/saphelp_47x200/helpdata/en/d1/801f7c454211d189710000e8322d00/content.htm" target="test_blank">http://help.sap.com/saphelp_47x200/helpdata/en/d1/801f7c454211d189710000e8322d00/content.htm</A></P><P>CATT - Computer Aided Testing Too</P><P><A href="http://help.sap.com/saphelp_47x200/helpdata/en/b3/410b37233f7c6fe10000009b38f936/frameset.htm" target="test_blank">http://help.sap.com/saphelp_47x200/helpdata/en/b3/410b37233f7c6fe10000009b38f936/frameset.htm</A></P><P>Test Workbench</P><P><A href="http://help.sap.com/saphelp_47x200/helpdata/en/a8/157235d0fa8742e10000009b38f889/frameset.htm" target="test_blank">http://help.sap.com/saphelp_47x200/helpdata/en/a8/157235d0fa8742e10000009b38f889/frameset.htm</A></P><P>Coverage Analyser</P><P><A href="http://help.sap.com/saphelp_47x200/helpdata/en/c7/af9a79061a11d4b3d4080009b43351/content.htm" target="test_blank">http://help.sap.com/saphelp_47x200/helpdata/en/c7/af9a79061a11d4b3d4080009b43351/content.htm</A></P><P>Runtime Monitor</P><P><A href="http://help.sap.com/saphelp_47x200/helpdata/en/b5/fa121cc15911d5993d00508b6b8b11/content.htm" target="test_blank">http://help.sap.com/saphelp_47x200/helpdata/en/b5/fa121cc15911d5993d00508b6b8b11/content.htm</A></P><P>Memory Inspector</P><P><A href="http://help.sap.com/saphelp_47x200/helpdata/en/a2/e5fc84cc87964cb2c29f584152d74e/content.htm" target="test_blank">http://help.sap.com/saphelp_47x200/helpdata/en/a2/e5fc84cc87964cb2c29f584152d74e/content.htm</A></P><P>ECATT - Extended Computer Aided testing tool.</P><P><A href="http://help.sap.com/saphelp_47x200/helpdata/en/20/e81c3b84e65e7be10000000a11402f/frameset.htm" target="test_blank">http://help.sap.com/saphelp_47x200/helpdata/en/20/e81c3b84e65e7be10000000a11402f/frameset.htm</A></P><P>Just refer to these links...</P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="84514"></A></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="23912"></A></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="142272"></A></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="131727"></A></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="84583"></A></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="145177"></A></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="148874"></A></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="151144"></A></P></BODY></HTML> Thu, 21 Jun 2007 05:05:46 GMT https://community.sap.com/t5/application-development-and-automation-discussions/regarding-alv-tuning/m-p/2429469#M543016 Former Member 2007-06-21T05:05:46Z Re: Regarding ALV Tuning https://community.sap.com/t5/application-development-and-automation-discussions/regarding-alv-tuning/m-p/2429470#M543017 <HTML><HEAD></HEAD><BODY><P>thanks</P></BODY></HTML> Fri, 22 Jun 2007 09:26:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/regarding-alv-tuning/m-p/2429470#M543017 Former Member 2007-06-22T09:26:49Z