2025-12-04, 06:12 PM
(2025-12-03, 02:29 AM)JF2025 Wrote: @tomstephens89
(2025-12-01, 08:15 PM)tomstephens89 Wrote: Unfortunately performance problems causing DB locking, no login, slow WEB ui etc are still present in 10.11.4.
I have DB locking policy set to Optimistic and Parallel tasks set to 1 already.
I had the same locking issue with the release of 10.11.x. However, I changed the "LockingBehavior" value in the database.xml file to "Optimistic", and parallel tasks to empty in General>Settings (meaning it uses my system's core count). That fixed locking and performance issues for me, after clearing cache and restarting the server.
I note that you have parallel tasks set to 1. That did not work well for me. Hope this helps.
Kinda weird that setting parallel tasks to 1 did not work well for you and that what fixed it was setting it to more than one (obviously your processor doesn't have just one core), since lowering its value is supposed to be one of the things that could prevent db locking. I guess there must be something related to db handling that's still buggy. Did you have db locking issues with parallel tasks set to 1 with the default NoLock too? Setting locking behavior to Optimistic may have helped, but it doesn't make much sense that you have more db locking with parallel tasks set to 1 than with more than 1. And did you try with Pessimistic? If so, did you also have db locking issues?

