|
|
|
Junior Member
 
Group: Forum Members
Last Login: 3/30/2007 4:22:00 PM
Posts: 13,
Visits: 1
|
|
When tpump update a row, I understand that it does a row hash lock. Based on this, I suspect that this means that all the rows with the pi values that hash to the same value as the pi being updated will be locked.
(Please correct me if I'm wrong) I can see where this may cause blocking.
When tpump does inserts however, I don't understand why there are blockers.
Can someone explain this?
Thank you.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 7/10/2009 6:28:52 PM
Posts: 505,
Visits: 546
|
|
Inserts require row hash write locks.
This required for purposes such as duplicate row checking, duplicate value checking(for unique) and not to mention to avoid any read transactions from occurring on the same row hash etc.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 3/30/2007 4:22:00 PM
Posts: 13,
Visits: 1
|
|
That was perfect.
thank you very much.
|
|
|
|