[DC-984] Pessimistic locking locks entire table rather than record Created: 16/Mar/11 Updated: 17/Apr/14
|Reporter:||Barry O'Donovan||Assignee:||Jonathan H. Wage|
Standard LAMP stack using current SVN from http://svn.doctrine-project.org/branches/1.2/lib/Doctrine/Locking/Manager
When using pessimistic locking as described in:
the locking manager locks the entire table rather than the specific object.
This should be clear from the attached patch which corrects the issue (assuming I have correctly interpreted the intention of pessimistic locking!).
The current behavior will have worked as expected for users but it will have locked far more than was intended and may thus have affected performance.
NB: I can confirm this works for non-composite keys but please review and test for composite keys as I have no such tables to hand.
|Comment by Barry O'Donovan [ 18/Oct/11 ]|
Folks - just wondering if anyone had a chance to look at this as, while not critical, it does appear to be a genuinely major performance issue.
|Comment by Grégoire Paris [ 13/Dec/12 ]|
Duplicate with more information : http://www.doctrine-project.org/jira/browse/DC-185