Hi,
Acquiring an "Exclusive" lock on an object, locks all the related objects. I
understand
this is done for maintaining the foreign key constraints. However, this for
most practical
purposes is a problem. E.g. Employee is related to Department. Usually
Department will have
100's of Employees, so if modifying an Employee in Exclusive mode will
require me to lock Department as well.
This will slow down the system considerably. Moreover the Passimistic
locking implemented in
databases allows me to lock Employee without having to lock Department,
which is more effiecient.
I would be glad if someone can help me here, and give some
recommendations/explanations about it.
Also if some changes are required, I am willing to put in some time to
provide a new option or any other
strategies you might have in mind.
Thanks !
Sudhir Bhojwani
Altoweb, http://www.altoweb.com
Phone: 650.251.1597
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
