Re: Locking...

Posted in 1996

"Billy Wheeler" — 3 Dec 1996 05:33:23 -0500 — source: Informix-list mailing list archive (1991-1998)

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...