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
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: drouillard.ca/Tips&Tricks/Samba/Oplocks.htm -- Regards -------------------------------------- Gerald Drouillard Technology Architect Drouillard & Associates, Inc. Drouillard.ca