For the last two years we have been working to improve NAV scalability and performance to be able to handle thousands of concurrent users. Two and half years ago we received a request from our partner to be able to process 200000 sales lines per hour and ensure that other system users will be able to work without visible delays. Our initial attempts failed. However, 2 years later with the release of Nav 5.00 SP1 we were we able to find a breakthrough solution that allows processing large volume of transactions and, most importantly, allows for scaling up a Nav system by simply adding more hardware. Our solution is a set of programming rules and methods (based on standards of parallel programming) that allow NAV systems to avoid user locking. Our methodology makes each user work as an independent thread in the system and competes for shared resources with other users. Our “Semaphore” functions allow locking shared resources on any level down to the record level. Theoretically we can make any vertical or custom solution free of user locking by rewriting the code based on our rules and methodology. Currently we have customers running our solution with Lanham EDI and LS Retail add-ons.
Now we all can say to our prospects and clients: you will never have performance issue in Microsoft Dynamics NAV again. (See test results for Locking Management Solution)
| File | File size |
|---|---|
 Loking Management Test Results | 4712 Kb |