Re: Transaction and locks

In addition to what Dejan said, you should always try to avoid using
pessimistic locking in your applications. There is no simple
one-size-fits-all solution because every application is different.
However, designing your table schema at the outset with concurrency in
mind can eliminate locking and blocking headaches down the road.

--Mary

On Fri, 12 Jan 2007 11:24:56 +0530, "Chakravarthy"
<r_chakravarthy@xxxxxxxxxxx> wrote:

This may be a naive question. Since DB Transactions with higher isolation
levels internally use locks, does it make sense to use Transactions for
concurrency management , in place of using some kind of pessimistic locks ?

Thanks,
Raj.

.