one of our client is using nav 3.7 . the database size is around 55GB and have 150 concurrent users across 42 locations.
we face repeatedly locking problem in the system during month end. uesrs either end up in deadlock or wait for more than 10 min to post.
Microsoft suggested to go for 4.0 as the locking mechanism is changed drastically there.
my doubt is ,
1. If we just open the 3.7 database in 4.0 client , we the locking mechanism of 4.0 take affect. as we are not going to use any new features of 4.0. the only reason for migration is locking problem.
2. what does that automatic database conversion means when we open the 3.7 database in 4.0.
3. The locking is driven by C/SIDE code or some inbuilt system code.
thanks and regards
Navision Technical Consultant