Tugger the SLUGger!SLUG Mailing List Archives

[SLUG] SQL Transaction Handling


As a matter of design style, when you are doing SQL transaction 
processing, should you lock and unlock the relevant tables inside or 
outside of the transaction block?

I would be interested in knowing ppls reasons for what they suggest.

-- 
Howard.
LANNet Computing Associates - Your Linux people <http://www.lannetlinux.com>
------------------------------------------
Flatter government, not fatter government - Get rid of the Australian states.
------------------------------------------
I before E except after C. We live in a weird society!