Featured Post

Scalability Techniques

Scalability is about the capability of a system to manage the increase workload of a system without causing qualities impact (i.e. perfo...

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