J
James Palmer
Guest
As Thomas says, you need to scope your buffers correctly, and not fudge the locking. You will find you introduce bugs to the system that are hard to track down by using release and refind of records no-lock. If you explicitly find your records exclusive-lock within the scope of the transaction itself then there is no need to release as the locks will be released at the end of the transaction block. If you find yourself having to add release statements then your scoping is wrong. You will find you have unexpected behaviour when transactions roll back, and you may well find you get lock table overflows.
Continue reading...
Continue reading...