topic Re: performance in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/3862955#M928486 <HTML><HEAD></HEAD><BODY><P>Performance Tuning</P><P></P><P><A href="https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d0db4c9-0e01-0010-b68f-9b1408d5f234" target="test_blank">https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d0db4c9-0e01-0010-b68f-9b1408d5f234</A></P><P></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></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></P><P><A href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap" target="test_blank">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap</A><EM>Performance</EM>and+Tuning&amp;</P><P></P><P><A href="http://www.erpgenie.com/abap/performance.htm" target="test_blank">http://www.erpgenie.com/abap/performance.htm</A></P><P></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></P><P><A href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap" target="test_blank">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap</A><EM>Performance</EM>and+Tuning&amp;</P><P></P><P><A href="http://help.sap.com/saphelp_nw2004s/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/frameset.htm" target="test_blank">http://help.sap.com/saphelp_nw2004s/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/frameset.htm</A></P><P></P><P><A href="http://help.sap.com/saphelp_nw2004s/helpdata/en/d1/801f7c454211d189710000e8322d00/frameset.htm" target="test_blank">http://help.sap.com/saphelp_nw2004s/helpdata/en/d1/801f7c454211d189710000e8322d00/frameset.htm</A></P><P></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="142332"></A></P></BODY></HTML> Mon, 19 May 2008 09:53:18 GMT Former Member 2008-05-19T09:53:18Z performance https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/3862954#M928485 <HTML><HEAD></HEAD><BODY><P>if i got date field in selection screen which is range of value and not primary key field . how u will take care of performance in select query.</P><P>and also give some performance tips</P></BODY></HTML> Mon, 19 May 2008 09:40:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/3862954#M928485 Former Member 2008-05-19T09:40:38Z Re: performance https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/3862955#M928486 <HTML><HEAD></HEAD><BODY><P>Performance Tuning</P><P></P><P><A href="https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d0db4c9-0e01-0010-b68f-9b1408d5f234" target="test_blank">https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d0db4c9-0e01-0010-b68f-9b1408d5f234</A></P><P></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></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></P><P><A href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap" target="test_blank">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap</A><EM>Performance</EM>and+Tuning&amp;</P><P></P><P><A href="http://www.erpgenie.com/abap/performance.htm" target="test_blank">http://www.erpgenie.com/abap/performance.htm</A></P><P></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></P><P><A href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap" target="test_blank">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap</A><EM>Performance</EM>and+Tuning&amp;</P><P></P><P><A href="http://help.sap.com/saphelp_nw2004s/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/frameset.htm" target="test_blank">http://help.sap.com/saphelp_nw2004s/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/frameset.htm</A></P><P></P><P><A href="http://help.sap.com/saphelp_nw2004s/helpdata/en/d1/801f7c454211d189710000e8322d00/frameset.htm" target="test_blank">http://help.sap.com/saphelp_nw2004s/helpdata/en/d1/801f7c454211d189710000e8322d00/frameset.htm</A></P><P></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="142332"></A></P></BODY></HTML> Mon, 19 May 2008 09:53:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/3862955#M928486 Former Member 2008-05-19T09:53:18Z Re: performance https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/3862956#M928487 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Even though Date field is not a primay key field, it will restrict the data , if you give it as an input. only way to improve performace is : to make the date field mandatory for input. if the internal table has data based on period( ie. date /year), then it will endup fetching the data only for the period( date) specified.</P><P></P><P>Assumption in the above case : the date field in the Database table is not empty.</P><P></P><P>other performance related links:</P><P><A href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/abap%2bperformance%2band%2btuning" target="test_blank">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/abap%2bperformance%2band%2btuning</A></P><P></P><P><A href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/performance%2btuning%2busing%2bparallel%2bcursor" target="test_blank">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/performance%2btuning%2busing%2bparallel%2bcursor</A></P><P></P><P>u can search in sdn , u can find more details.</P><P></P><P>Regards,</P><P>Madhu</P></BODY></HTML> Mon, 19 May 2008 10:04:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/3862956#M928487 Former Member 2008-05-19T10:04:16Z Re: performance https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/3862957#M928488 <HTML><HEAD></HEAD><BODY><P>You can build a index in the table for selected fields. This will improve considerably the performance of the queries.</P><P></P><P>Before building the index, I recommend to stydy index impact on the database.</P><P></P><P>Regards</P></BODY></HTML> Tue, 20 May 2008 14:25:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/performance/m-p/3862957#M928488 Former Member 2008-05-20T14:25:36Z