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
