2025-12-03, 02:29 AM
(This post was last modified: 2025-12-03, 02:30 AM by JF2025. Edited 2 times in total.)
@tomstephens89
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.
(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.
