If this is UniVerse there is a uvconfig parameter MAXRLOCK that specifies how many record locks to take (on an INSERT, UPDATE or DELETE statement) before choosing to use a FILELOCK. Reducing this parameter will mean fewer record locks per query, at the cost of greater danger of another updating process being locked out of the table till the first process finishes its updates. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
- [U2] SQL query locks Pamela J Robbins
- Re: [U2] SQL query locks Don Kibbey
- Re: [U2] SQL query locks Geoffrey Mitchell
- Re: [U2] SQL query locks Wally Terhune
- RE: [U2] SQL query locks Stevenson, Charles
- RE: [U2] SQL query locks Wally Terhune
- Re: [U2] SQL query locks Pamela J Robbins
- Re: [U2] SQL query locks Ray Wurlod
- Re: [U2] SQL query locks Pamela J Robbins
- Re: [U2] SQL query locks Ray Wurlod
