Re: Locking...

I've worked on a number of large multi-user informix databases and where there are a number of users inserting / updating data in a table it has always been necessary to have row level locking. It's not correct to state that row level locking only locks the row you're updating, it could also lock adjacent rows where an index is affected. With large volumes you could get -271, -245 & -246 errors. Setting 'lock mode wait' should avoid these errors. Hope this helps. Mike. In article <580vlj$lp3@cssun.mathcs.emory.edu>, "\\"Billy Wheeler\\"" <billy@west.co.za> writes >On 2 Dec 96 at 22:59, Romulo Albuquerque wrote: > >> I wish to know what locking mode is better: Row or Page Locking ? Please >> help me. > >As Bob Dole is alleged to have said: "Depends". > >Page locking is more efficient (faster), but can cause unnecessary >locks (reduces concurrency). Row locking is slower, but will never >unnecessarily lock rows other that those you intend. > >HTH. >-- >Ciao, > >Billy > >I'd be in favour of apathy, but I just couldn't be bothered... -- Mik Hobbs