Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Performance issue of Item tracking -NAV 2009
maharajagk
Member Posts: 3
Hi All,
WE have implemenented Nav 2009 classic client with a client of ours.We have used serial number tracking for items and we have used Native db.
We are using Item serial number tracking for items (Only serial number tracking).We use a barcode reader for scanning the item serial number.We use the option Create Customized serial and keep focus on Customized serial number and scan the serial number .then we increment the serial number by 1 in the increment field.We tested with 40000 qty only and it took nearly half a day to process and save in item tracking and posting the PO .
Another issue is that the Db size is increasing heavily whe we post using serial nos.
has anyone faced this prob and any ideas to resolve are welcome.
Maharaja
WE have implemenented Nav 2009 classic client with a client of ours.We have used serial number tracking for items and we have used Native db.
We are using Item serial number tracking for items (Only serial number tracking).We use a barcode reader for scanning the item serial number.We use the option Create Customized serial and keep focus on Customized serial number and scan the serial number .then we increment the serial number by 1 in the increment field.We tested with 40000 qty only and it took nearly half a day to process and save in item tracking and posting the PO .
Another issue is that the Db size is increasing heavily whe we post using serial nos.
has anyone faced this prob and any ideas to resolve are welcome.
Maharaja
0
Comments
40K serial number entered on one line or mulitple?
and what kind of items is it that you are serial tracking?
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
The item tracking is done for some items in item master .say 10 items .Also the transaction volume per day shall be around 30000 item tracking lines per day.
And then displays the info in a temporary form. The user makes changes to the temporary record and when he closes the form, the data is then copied back from Temp to reservation entries.
You can improve the performance, by displaying the reservation form, and allowing the user to scan the serial number on this now form and bypass the two step copying. You will have to also write similar code on when they can open the form.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Also, each serial number has its own item ledger entry, which means your database will get extremely large.
You could look at tracking serial numbers in a custom table or not track them until they are sold.
http://mibuso.com/blogs/davidmachanick/