The most common cause is missing index. But the following could also result in performance problems: (1) Mutilple database access code being executed on the client tier. This can be corrected by placing the code in a class or static method that is executed on the server. (2) Multiple calls to fetch data from a table requiring one or a few fields but the entire buffer is being fetched. In this case you should use field select. Do not get in the habit of making mutiple calls to the find method on a table to fetch different fields for the same record. Use a table buffer to do one find and use the buffer to fetch all required fields. If the number of fields in the table is large it will be better to do a field select instead of calling the find method that returns all fields. The less fields fetch the better the performance. (3) A table with a large number of records is placed on the form data source without a reltionship to another table. In this case all the records will be loaded when the form is open. Ensure that the table buffer is needed, otherwise remove it. Regards, Varden Morris
276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] ----- Original Message ---- From: Ali Jawad <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Sunday, June 22, 2008 1:14:54 AM Subject: RE: [Axapta-Knowledge-Village] SQL Slow response Hello Morris, I will try to do this, can you please share possible reasons for this so that I directly can target those. Thanks again……. Regards, Ali Jawad From:Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris Sent: Saturday, June 21, 2008 6:43 PM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: Re: [Axapta-Knowledge- Village] SQL Slow response Hi Ali, Do you know how to do a long query and multiple select statement trace? You should do this and analyze the resulting data to find the bottleneck. Regards, Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] com ----- Original Message ---- From: Ali Jawad <[EMAIL PROTECTED] com> To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Sent: Saturday, June 21, 2008 1:04:59 AM Subject: [Axapta-Knowledge- Village] SQL Slow response Hello, I have a situation here. We have around 10,000 line items In a sales blanket order. This order has been imported using AX import Export facility. Now after import when we open AX and click on Sales Order, it takes minutes to open, which is not acceptable. Can anybody please help me to locate and solve this issue. Thank You, Ali Jawad