[Samba] Slow Access Database on Samba

[Gerald Drouillard]

Dave Williams wrote:
> Dear  All,
> 
> We have an access database running on a Samba share (Samba version
> 3.0.10-1.4E) with a gigabit connection to the network. The front end of the
> databases are on the client machines with linked tables stored in a separate
> mdb file on the linux server.
> 
> For some reason the database runs very slowly when it is set up in this way.
> I tested copying a 10 MB file onto the samba share and it was instant which
> leads me to believe that this is not a networking issue but tweak needed to
> the smb.conf file. I have also run the database with the back end stored on
> a Windows Peer in the network - it runs much faster than on  the linux
> setup. Here is the current Global setting in smb.conf. I would be very
> grateful if anyone can help;
> 
> 
> [global]
>         workgroup = ACE
>         server string = Ace New Server
>         passdb backend = tdbsam
>         username map = /etc/samba/smbusers
>         wins support = Yes
>         local master = yes
>         preferred master = yes
>         wins support = yes
>         socket options = IPTOS_LOWDELAY TCP_NODELAY SO_SNDBUF=4096
> SO_RCVBUF=4096
>         oplocks = no
> 
> 
> Dave Williams
> 
> 
> 

Have a look at:
http://drouillard.ca/Tips&Tricks/Samba/Oplocks.htm 

-- 
Regards
--------------------------------------
Gerald Drouillard
Technology Architect
Drouillard & Associates, Inc.
http://www.Drouillard.ca