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-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Varden Morris Sent: Saturday, June 21, 2008 6:43 PM To: Axapta-Knowledge-Village@yahoogroups.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] ----- Original Message ---- From: Ali Jawad <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.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
