Re: SET LOCK MODE TO WAIT ?
Posted in 1995
andy lennard — — source: Informix-list mailing list archive (1991-1998)
When I tried using this I found that the 'wait' part was done by going into a fairly compute-intensive loop with the frontend retrying like crazy. It doesn't seem smart enough to have the backend signal when the lock is freed. This means thatwith several tasks waiting for the same lock there is no 'first-come-first-served' method to determine who is serviced next. =-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-= Andy Lennard andy@kontron.demon.co.uk =-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=