Re: On GET_LOCK ()

[Thimble Smith]

At 13:39, 19990728, Paul DuBois wrote:
>Is the timeout the amount of time you want to wait to see if you
>can get the lock?  It's not the duration for which the lock is in
>force.

Right, the timeout on GET_LOCK() is for how long you block before
giving up on getting the lock.  It doesn't make any sense to specify
how long you want to *hold* the lock.  I mean, I can't imagine how
I would program using that.

    if (machine_speed == REALLY_FAST)
        operation_duration = 10;
    elsif (machine_speed == KINDA_FAST)
        operation_duration = 25;
    else
        operation_duration = 75;

    sprintf(query_buf, "SELECT GET_LOCK(%s, %d)",
            "'name'", operation_duration);

There isn't a need for a non-blocking get_lock(), since using a
timeout of 0 is what you want.

Tim