Barry That's not entirely correct.
Universe uses a number of different lock types. At the group level, the main lock types are Read and Write locks - these are used to ensure exclusive access during read and write operations, to prevent two processes trying to restructure the group at the same time. These are temporary and exist only for the duration of the read/write itself, and have no relation to BASIC READU locks. You will see these as WR and RD entries in the lock table. The READU locks are held at two levels: as individual item locks and as information locks. The information locks are held at the group level, and speed up the search process - the presence of an information lock signals that one or more record locks are present and should be checked. Records are not 'locked' at the group level, it is only a signal to check further. Brian > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik > Sent: 26 April 2006 16:24 > To: [email protected] > Subject: RE: [U2] [UV] File sizing > > >locked in the group. So you can minimize group lock contention by > >making the file "wide and shallow". So not only is there no gain > > So that's what a group lock is? If you have more than 1 > record locked, it locks the whole group? That seems like an > odd idea. What if you have one record locked, then another > user locks some other record in that same group, then you go > to lock a second record... the system could not very well > lock the whole group for you because someone else has a lock already. > > Barry Brevik > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
