Re: Locking...

Posted in 1996

Bryan Tonnet — 3 Dec 1996 19:18:19 +1100 — source: Informix-list mailing list archive (1991-1998)

In <5802c5$anm@cssun.mathcs.emory.edu> bicudo@elogica.com.br (Romulo Albuquerque) writes: >Hi All, > I wish to know what locking mode is better: Row or Page Locking ? Please >help me. My understanding is that page level locking has a performance benefit up until contention on the locked pages degrades it again. When that point is reached, you should move to row level locking. Bear in mind that the locking is at table level, so you can select which tables would be better suited to page locking, and which might be candidates for row level. Bryan Tonnet batonnet@zeta.org.au