Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.4K 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
- 317 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 385 SQL Performance
- 33 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
Locking in Multiuser environment
harsh_bandlish
Member Posts: 5
Current Scenario : Our client is working in multiuser environment at 13 differnt sites and with 35 users (including 20 CITRIX users). and around 15 GB of database.
Problem : The problem is lots of sales reports are requesting for "Posted structure line" table. so whenever anyone run one of those reports, it locks the entire table, which even not allow to post orders by rest of the user.
and if the table is locked by some other user then the report takes huge amount of time to execute.
Request:
So, is there anyway through which we can only apply read lock onto the required tables, so that rest of our requests won't effected.
Suggest the solution either from Navision side or from SQL side.
](*,)
Problem : The problem is lots of sales reports are requesting for "Posted structure line" table. so whenever anyone run one of those reports, it locks the entire table, which even not allow to post orders by rest of the user.
and if the table is locked by some other user then the report takes huge amount of time to execute.
Request:
So, is there anyway through which we can only apply read lock onto the required tables, so that rest of our requests won't effected.
Suggest the solution either from Navision side or from SQL side.
](*,)
Harsh
0
Comments
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
That should solve the problem.
Make sure the report's TransactionType are set to UpdateNoLocks.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Which version of Navision are you running on?
Ideally in a report you would not lock tables. If it is so i would suggest, you need to review the code.
It is the posting routines which cause locks, which can be resolved. These again are due to code related to Localization. You will also need to consider weather the hardware is set as per requirements of Navision for the no. of users using the system.
Regards,
Manoj