Re: Locking...

Romulo Albuquerque wrote: > > Hi All, > > I wish to know what locking mode is better: Row or Page Locking ? Please > help me. > > TIA, > > Romulo Albuquerque > Just my $.02 worth... We ran some experiments on locking, and it is important to lock records for as short a time as possible... I am used to an environment where you lock a record when the user clicks EDIT. the record is released when the user hits SAVE or CANCEL. DO NOT use this approach. If your user (or developer) crashes out when "After Dark" loads up, with a row OR page locked. You will freeze up an Informix Database. All the users must be kicked off, and the database restarted. Instead, Lock the records when the user clicks SAVE. It should look like this: - Start Transaction - Save Table 1 - Save Table 2 . . - Save Table n - Commit Bryan Valencia Software Services - Making Windows Scream Modesto, CA