Planning/Requisition Worksheet order tracking policy is slow

lzr
Member Posts: 264
After enabling order tracking policy it takes like four times as long to run the planning worksheet (from one hour to four). I have looked through the inventory profile offsetting and can find a lot of find('-') and was thinking of replacing them with findset but then I read that I should only do this if the records retrieved are less than record set on the database (which is 500).
When looking at the code I also found this which doesn't seem that good:
Have anyone experienced performance problems with the planning worksheet or the requisition worksheet and in that case how did you solve it?
Running NAV 2009 SP1 (R2 classic client). It's running on a SQL 2008 SP3 server
When looking at the code I also found this which doesn't seem that good:
[b]DeleteTracking(VAR SKU : Record "Stockkeeping Unit";ToDate : Date)[/b] ActionMsgEntry.SETCURRENTKEY("Reservation Entry"); WITH ReservEntry DO BEGIN RESET; SETCURRENTKEY("Item No.","Variant Code","Location Code"); SETRANGE("Item No.",SKU."Item No."); SETRANGE("Variant Code",SKU."Variant Code"); SETRANGE("Location Code",SKU."Location Code"); SETFILTER("Reservation Status",'<>%1',"Reservation Status"::Prospect); IF FIND('-') THEN REPEAT IF (("Reservation Status" <> "Reservation Status"::Reservation) AND ("Expected Receipt Date" <= ToDate) AND ("Shipment Date" <= ToDate)) OR ((Binding = Binding::"Order-to-Order") AND ("Shipment Date" <= ToDate)) THEN BEGIN ActionMsgEntry.SETRANGE("Reservation Entry","Entry No."); DELETE; ActionMsgEntry.DELETEALL; END; UNTIL NEXT = 0; END;I am thinking of replacing this find('-') with findset(true, true) since it's doing a delete in the middle of the code, what do you think?
Have anyone experienced performance problems with the planning worksheet or the requisition worksheet and in that case how did you solve it?
Running NAV 2009 SP1 (R2 classic client). It's running on a SQL 2008 SP3 server
Navision developer
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions