“Without locking management we would not be able to handle last holiday season” - says Denis Sologub, CIO, Azbuka Vkusa retail chain.
Over last 15 years Azbuka Vkusa is experiencing continues grows. In 2001 they have implemented Microsoft Dynamics NAV with LS Retail solution for 4 stores. Since then 48 new stores have been opened and every year users felt growing pain associated with locking transactions and wait times. The company have tried many known methods for performance improvement – keys and code optimization, overnight batch processing, queuing transactions for delayed processing and it have been helping for some time. Last year they have run out of improvement options when operations grow to over 500000 item transactions a day.
“We did not want replace Dynamics NAV and together with our partner Lean4Systems we did extensive research for to solve locking issues.” - says Denis Sologub. “One of the solutions delivered by US based company Adaptive Business Solutions looked especially innovative and original. The solution test promised ability to process 100000-600000 item transactions per hour without noticeable wait times for users.
Locking Management Solution is a development methodology developed based on standard practices of parallel programing. The methodology focused on modifying Microsoft Dynamics NAV custom or standard system to make each user lock very precise and limited set of data and allows other users work without delays. Internal “Semaphore” function replaces Microsoft Dynamics NAV locking functionality and allows setting resource lock on any required level.
As result of the implementation users stopped experiencing locking and wait for transactions to be processed. Denis continues: “But the main result is – we can see us growing now to hundreds of stores without need of unnecessary investment in the new system and pain of new implementation.”
Implementation of Locking Management exceeded all expectations. Eliminating disbalance between Servers and Software open for us new horizons for using Microsoft Dynamics NAV and LS Retail. This will absolutely increase quality and efficiency of our operations and, what is also very important for us, comfort of our users.”