>1) Are you sure you need FLOCK()

Since just recently we have made the application Multi-user, we are using FLOCK(). We are locking the first table that is updated during a save operation. Therefore if another user tries to do the same, they have to wait until FLOCK() is released. Now if this slows down things, then even if only one User is saving an Invoice, then it should not be slow from a node.

>
>2) You can optimistically or pessimistically lock with explicit locks (FLOCK() and RLOCK()) -- that's not the issue.
>

Usually most members refere to VFP when they give a solution. I thought it was a feature of VFP. We are using optimistic locking ( during save )


>3) I asked whether you were using READ NOLOCK. If you are not you probably should be <s>.
>
>I should also probably have asked whether you read to memvars or directly to the table -- but you can still handle this even if you read directly to the table.

We are not using READ NOLOCK & we read to memvars ( no direct table manipulation ). Will NOLOCK have impact ?

>
>So, okay, let's take this a little slower, run your multi-user practices by me and I'll try to explain how my suggestion would apply <s>.

That's nice of you. My first message tells the settings for multi-user setup. Any suggestions ?

Rakesh