Hi Nenad,
> We did not set up the machine, it worked the other team. I think the
> oplocks is off on both machines, but I'm not sure (I will
> check). Currently the system is unusable, because users can work only on
> the server or on ws. When working user 1 (server), the user 2 can not work.
Yes, that is typically what happens when oplocks are on. User one opens
files and gets quick responses because the server puts opportunistic
locks on the files. When user two tries to open them (whether for
reading or writing) the server starts negotiations with user one's
computer for each involved file and asks user one to release the locks.
That takes time. Opening ten dbf files with ten ntx files each results
in 110 separate negotiations ...
> But, I think I can enable oplocks in this case because user-1 99.9% of
> time only looking for data (reports, etc.) and user-2 writes data.
It doesn't matter who is reading and who is writing. The entire file is
locked by user one (even if he is only reading) until the opportunistic
lock is lifted, and user two cannot open it at all while the negotiating
goes on. Locking a record for writing is an entirely different lock.
I think you would benefit from searching the web for in depth
descriptions of oplocks (especially by other providers of filesharing
database systems, like Dataflex for example) to read up on what actually
happens in the SMB protocol. And don't forget to also investigate all
the other settings that can be found in contrib\hbwin\win_os.prg
(cachedopenlimit, SMB2 etc, etc).
There are also many previous discussions in this group, so search for
those too.
Regards,
Klas