Re: Locking...

Posted in 1996

Bill Ennis — 3 Dec 1996 09:58:10 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi, Well the answer is it depends. Row locking can yield better performance, but at a price. You see you need more system resources with row level locking. If you use it you may need to up your LOCKS parameter in the onconfig which in turn requires more memory. My 2 cents, Bill > > Hi All, > > I wish to know what locking mode is better: Row or Page Locking ? Please > help me. > > TIA, > > Romulo Albuquerque > > > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com