IDS Forum

Locks

Posted By: ELENA GROVER
Date: Tuesday, 21 January 2003, at 12:30 p.m.

I am just starting to use Informix and I have read a lot of documentation about locking but I am more interested in best practices. This question is not specific but any recommendation or personal experience is welcome.

My problem is the next, suppose that I have a table call clients with about 3 millions of records, this table is actualized frequently and a lot of reports are run against it.

Is the best option to use a row lock? If some user 'A' is consulting a record and some other user 'B' modifies the same record what can I do to refresh the record for the user ‘A’? How can I assure when user 'A' and user 'B' are trying to modify the same record at the same time that an update would be always against the new values of the record and not the values before modification for another user?

How can I get the best performance, high availability and assure data consistency, using locks? Talking about 50-100 concurrent users, tables about 1-10 million of records and using ANSI DB.

Thank you very much.

Messages In This Thread

• Locks
  ELENA GROVER -- Tuesday, 21 January 2003, at 12:30 p.m.
  • Re: Locks
    ART KAGEL, BLOOMBERG/ 65E 55TH -- Tuesday, 21 January 2003, at 2:00 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.