Nastasi, John wrote: > Do you know if there are any issues with Samba running on > Solaris that would cause the application to run "very, very" > slow with oplocks turned off?
No, and that's the kind of problem we should
raise with the Samba team: I'm cc'ing this
to them.> Specifically, with oplocks turned on I get acceptable performance
> trying to open an MS-Access (Jet) database. The operation completes in
> no more than a minute or so. Turning "off" oplocks (as suggested
> repeatedly by many folks for multiple users accessing an MDB on a Samba
> share) completely hoses the same operation - 9 minutes to complete.
We need to see what Samba's doing differently
between the two cases. There are three places to
look:
1) Samba logs, at log level = 3 or more
2) truss reports
3) packet dumps. I recommend them in roughly that order: I'm
good at reading truss, and the team is real good
at logs.> I've tried the configuration on a Solaris 7 (Ent 4500) running Samba
> 2.0.10 and also on a Solaris 8 (V100) running Samba 2.2.7a - same
> result. I'm about to try the latest kernel patch to see if it could be
> an fcntl related issue, but was curious if you knew of anything else
> that could be causing the problem.
>
> Based upon what I've read - oplocks being turned off should "help"
> multi-user, MDB access performance. What I'm seeing, however, is just
> the opposite.
Yes, specifically by avoiding transferring the
whole file to the client and then transferring it back.
Turning of oplocks **in principle should** cause
the db to read only the records it wants to change,
then writing them back. The times imply it's still transferring the whole
file, which is utterly evil (;-)) Of course, using
smb file locking as the mechanism to do database locking
is brain-dead in the first place. Being able to do
so is just a way of letting you try out a DBMS, get
used to it and eventually buy the back-end DBMS and
a server to put it on.
--dave
-- David Collier-Brown, | Always do right. This will gratify Sun Microsystems DCMO | some people and astonish the rest. Toronto, Ontario | (905) 415-2849 or x52849 | [EMAIL PROTECTED]
-- David Collier-Brown, | Always do right. This will gratify Sun Microsystems DCMO | some people and astonish the rest. Toronto, Ontario | (905) 415-2849 or x52849 | [EMAIL PROTECTED]
