Suggested Pages

Tuesday, March 19, 2013

Select for Update

A select for update is often use as a semaphore on your database. If you plan a transaction with a select for update, you are avoiding the other transactions to get a read o write lock on the accessed rows; at this way you are implementing a sort of semaphore that is released only when the transaction ends.

No comments :

Post a Comment

Suggested Pages