Re: [Axapta-Knowledge-Village] SQL Slow response

2008-06-24 Thread Naeem Sarwar
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: Sunda

Re: [Axapta-Knowledge-Village] SQL Slow response

2008-06-22 Thread Varden Morris
) (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, c

RE: [Axapta-Knowledge-Village] SQL Slow response

2008-06-22 Thread Ali Jawad
, 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

Re: [Axapta-Knowledge-Village] SQL Slow response

2008-06-21 Thread Varden Morris
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

[Axapta-Knowledge-Village] SQL Slow response

2008-06-21 Thread Ali Jawad
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