i have turn SQL Server Profiler to view a why Planning Worsheet was taking about 2 minutes to make calculations to a single item, on a CRONUS database.
I had detect some lines with this parameters
CPU - 187
Reads - 66820
Duration - 186
The SQL Statement
DELETE FROM "Demo Database NAV (6-0)"."dbo"."CRONUS$Prod_ Order Capacity Need" WHERE (("Worksheet Template Name"=@P1)) AND (("Worksheet Batch Name"=@P2)) AND (("Worksheet Line No_"=@P3))
I turn the Client Monitor and see that C/AL CODE
I changed like the Styrk´s sugestion http://dynamicsuser.net/blogs/stryk/archive/2010/10/22/solving-blocking-issues-practical-examples.aspx
IF NOT ProdOrderCapNeed.ISEMPTY THEN
but without luck.
I need some help to optimize this.
Can you help me?