Re: Re[2]: HELP Informix Locks

tvarnas@compulink.gr (Apostolos Varnas) wrote: <snip> >it depends how the data you want to update is distributed on the pages.At the >worst case if it is distributed across 1000 pages you will need 1000 locks. <snip> >Assuming your data is stored contiguous it is then placed on 50 pages, >so you will need 50 page locks.So the answer is something between 50 and 1000 >locks. >The best solution in such cases if you can afford to lose the concurrency for >the duration of this transaction is to lock the table in >exclusive mode. <snip> You forgot to take index pages into account. They are also locked when a row is inserted/updated. Worst case is one page per index per row, so if you have 3 indexes there could be as many as 3000 locks. -------------------------------------------------------- Rob McAllister rmcall@on-ramp.ior.com Spokane, WA "On all good programmers a little core must dump"