Re: Locking with Informix 5.0 SE

Kai Pruente <pruente@quantum.de> wrote: :Hi ! :I'm interesting in the locking method (page/row) of Informix SE 5.0. :An example with a small table with 10 rows results a row lock. :In the "Tutorial Informix SQL-Guide" I found: :Other Informix database servers (other than Informix Online) do not :offer thc choice; they lock by page or by row, whichever makes the :better implementation. :What means "better implementaions" depends it of the dataserver :(HP-UX B.10.00 C 9000/837) or of our database :(tables, number of rows..) ? There is no concept of pages in SE so it allways locks by row. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org