samba - Sep 2005 - Office (2003) saving excel sheet takes VERY long..

Hi!
Maybe you can help me, would be very nice!
I'm new to the list and I'm very glad that it exists...
A week ago we migrated to samba and since then it's taking very long to 
save a 1,8MB excel document. On fast ethernet it takes us about 10 
seconds, on wireless lan it can take up to a minute, although 
transferring the same amount of data from the very same machine, that is 
connected via 802.11g, to samba (by copying a file) takes only about 
3-4seconds over the wireless connection.
We use Excel in Office 2003 with SP1. Machine is a WinXP Pro SP2.
It looks as if it was Excel's fault, but it also seems to be much slower 
now since the files are stored on the samba server.

Is there any way to enhance Excel's writing or maybe the caching on the 
server?Most of the files are smaller than 300kbytes, but this particular 
one is ~1,8MB and used VERY frequently.

Samba version is 3.0.20

System's running on an Athlon XP 2.400+, 512MB ram, Redhat Enterprise WS 4

The smb.conf looks like:

[global]

   netbios name = smb

   workgroup = WORKGROUP

   server string = Samba Server

    hosts allow = 192.168.0.

  guest account = guest

 log file = /var/log/samba/%m.log

   max log size = 500

   security = user

    ;oplocks = no
    ;level2 oplocks = no

  encrypt passwords = yes
  smb passwd file = /etc/samba/smbpasswd

   socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192 IPTOS_LOWDELAY

    ;getwd cache = yes
    ;dead time = 15
    ;read raw = yes
    ;write raw = yes

    interfaces = 192.168.0.102/24

    remote announce = 192.168.0.255

    local master = yes

   os level = 200

   preferred master = yes

 name resolve order = wins lmhosts bcast

   wins support = yes

   dns proxy = no

  preserve case = no
  default case = lower
  case sensitive = no


   idmap uid = 16777216-33554431
   idmap gid = 16777216-33554431
   template shell = /bin/false
   winbind use default domain = no

[shared]
   comment = Temporary file space
   path = /smb/shared
   public = yes
   writeable = yes
   create mask = 0640
   directory mask = 750
   force create mode = 020
   force directory mode = 020
   guest ok = yes
   force group = users

[daten]
   comment = Root
   path = /smb/daten
   valid users = @verwaltung
   write list = @verwaltung
   force group = users
   create mask = 0640
   directory mask = 750
   force create mode = 020
   force directory mode = 020

[folder1]
   path = /smb/daten/folder1
   valid users = @users
   writeable = yes
   public = yes
   force group = users
   create mask = 0640
   directory mask = 750
   force create mode = 020
   force directory mode = 020

[folder2]
   path = /smb/daten/folder2/
   valid users = @users
   writeable = no
   write list = silvia, @verwaltung
   force group = users
   create mask = 0640
   directory mask = 750
   force create mode = 020
   force directory mode = 020



Thanks alot for any help!

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Why you disable the getwd cache parameter ?

man of smb.conf for getwd cache parameter :

This is a tuning option. When this is enabled a caching algorithm will
be used to reduce the time taken for getwd() calls. This can have a
significant impact on performance.



Max Riedel a ?crit :
> Hi! Maybe you can help me, would be very nice! I'm new to the list
> and I'm very glad that it exists... A week ago we migrated to samba
> and since then it's taking very long to save a 1,8MB excel
> document. On fast ethernet it takes us about 10 seconds, on
> wireless lan it can take up to a minute, although transferring the
> same amount of data from the very same machine, that is connected
> via 802.11g, to samba (by copying a file) takes only about
> 3-4seconds over the wireless connection. We use Excel in Office
> 2003 with SP1. Machine is a WinXP Pro SP2. It looks as if it was
> Excel's fault, but it also seems to be much slower now since the
> files are stored on the samba server.
>
> Is there any way to enhance Excel's writing or maybe the caching on
> the server?Most of the files are smaller than 300kbytes, but this
> particular one is ~1,8MB and used VERY frequently.
>
> Samba version is 3.0.20
>
> System's running on an Athlon XP 2.400+, 512MB ram, Redhat
> Enterprise WS 4
>
> The smb.conf looks like:
>
> [global]
>
> netbios name = smb
>
> workgroup = WORKGROUP
>
> server string = Samba Server
>
> hosts allow = 192.168.0.
>
> guest account = guest
>
> log file = /var/log/samba/%m.log
>
> max log size = 500
>
> security = user
>
> ;oplocks = no ;level2 oplocks = no
>
> encrypt passwords = yes smb passwd file = /etc/samba/smbpasswd
>
> socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192
> IPTOS_LOWDELAY
>
> ;getwd cache = yes ;dead time = 15 ;read raw = yes ;write raw = yes
>
>
> interfaces = 192.168.0.102/24
>
> remote announce = 192.168.0.255
>
> local master = yes
>
> os level = 200
>
> preferred master = yes
>
> name resolve order = wins lmhosts bcast
>
> wins support = yes
>
> dns proxy = no
>
> preserve case = no default case = lower case sensitive = no
>
>
> idmap uid = 16777216-33554431 idmap gid = 16777216-33554431
> template shell = /bin/false winbind use default domain = no
>
> [shared] comment = Temporary file space path = /smb/shared public > yes
writeable = yes create mask = 0640 directory mask = 750 force
> create mode = 020 force directory mode = 020 guest ok = yes force
> group = users
>
> [daten] comment = Root path = /smb/daten valid users = @verwaltung
> write list = @verwaltung force group = users create mask = 0640
> directory mask = 750 force create mode = 020 force directory mode > 020
>
> [folder1] path = /smb/daten/folder1 valid users = @users writeable
> = yes public = yes force group = users create mask = 0640 directory
> mask = 750 force create mode = 020 force directory mode = 020
>
> [folder2] path = /smb/daten/folder2/ valid users = @users writeable
> = no write list = silvia, @verwaltung force group = users create
> mask = 0640 directory mask = 750 force create mode = 020 force
> directory mode = 020
>
>
>
> Thanks alot for any help!


- --
St?phane Purnelle <stephane.purnelle@tiscali.be>
Site Web : http://www.linuxplusvalue.be
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDHyuU8tswkE3d0ecRAtlbAJ98HtJQg8MHrq+jf7Vxf7Nspj/bjgCfTpjQ
TNrl1vv6zY32bruNWuL21n0=vSeO
-----END PGP SIGNATURE-----

Max,

I'd try working on the TCP Socket options.  Adjust the 
SO_RCVBUF and SO_SNDBUF values up in steps of 1024, restarting
Samba after each change.  You can then time the transfers.  

That should help!



On Wed, 07 Sep 2005 19:22:58 +0200, Max Riedel wrote:
>Hi!
>Maybe you can help me, would be very nice!
>I'm new to the list and I'm very glad that it exists...
>A week ago we migrated to samba and since then it's taking very long to 
>save a 1,8MB excel document. On fast ethernet it takes us about 10 
>seconds, on wireless lan it can take up to a minute, although 
>transferring the same amount of data from the very same machine, that is 
>connected via 802.11g, to samba (by copying a file) takes only about 
>3-4seconds over the wireless connection.
>We use Excel in Office 2003 with SP1. Machine is a WinXP Pro SP2.
>It looks as if it was Excel's fault, but it also seems to be much slower
>now since the files are stored on the samba server.
>
>Is there any way to enhance Excel's writing or maybe the caching on the 
>server?Most of the files are smaller than 300kbytes, but this particular 
>one is ~1,8MB and used VERY frequently.
>
>Samba version is 3.0.20
>
>System's running on an Athlon XP 2.400+, 512MB ram, Redhat Enterprise WS
4
>
>The smb.conf looks like:
>
>[global]
>
>   netbios name = smb
>
>   workgroup = WORKGROUP
>
>   server string = Samba Server
>
>    hosts allow = 192.168.0.
>
>  guest account = guest
>
> log file = /var/log/samba/%m.log
>
>   max log size = 500
>
>   security = user
>
>    ;oplocks = no
>    ;level2 oplocks = no
>
>  encrypt passwords = yes
>  smb passwd file = /etc/samba/smbpasswd
>
>   socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192 IPTOS_LOWDELAY
>
>    ;getwd cache = yes
>    ;dead time = 15
>    ;read raw = yes
>    ;write raw = yes
>
>    interfaces = 192.168.0.102/24
>
>    remote announce = 192.168.0.255
>
>    local master = yes
>
>   os level = 200
>
>   preferred master = yes
>
> name resolve order = wins lmhosts bcast
>
>   wins support = yes
>
>   dns proxy = no
>
>  preserve case = no
>  default case = lower
>  case sensitive = no
>
>
>   idmap uid = 16777216-33554431
>   idmap gid = 16777216-33554431
>   template shell = /bin/false
>   winbind use default domain = no
>
>[shared]
>   comment = Temporary file space
>   path = /smb/shared
>   public = yes
>   writeable = yes
>   create mask = 0640
>   directory mask = 750
>   force create mode = 020
>   force directory mode = 020
>   guest ok = yes
>   force group = users
>
>[daten]
>   comment = Root
>   path = /smb/daten
>   valid users = @verwaltung
>   write list = @verwaltung
>   force group = users
>   create mask = 0640
>   directory mask = 750
>   force create mode = 020
>   force directory mode = 020
>
>[folder1]
>   path = /smb/daten/folder1
>   valid users = @users
>   writeable = yes
>   public = yes
>   force group = users
>   create mask = 0640
>   directory mask = 750
>   force create mode = 020
>   force directory mode = 020
>
>[folder2]
>   path = /smb/daten/folder2/
>   valid users = @users
>   writeable = no
>   write list = silvia, @verwaltung
>   force group = users
>   create mask = 0640
>   directory mask = 750
>   force create mode = 020
>   force directory mode = 020
>
>
>
>Thanks alot for any help!
>-- 
>To unsubscribe from this list go to the following URL and read the
>instructions:  https://lists.samba.org/mailman/listinfo/samba

Thanks alot this solved my Problem!
Now time's about 10seconds on wifi.. that's ok!

Thanks!

John Mazza wrote:
> Max,
>
> I'd try working on the TCP Socket options. Adjust the
> SO_RCVBUF and SO_SNDBUF values up in steps of 1024, restarting
> Samba after each change. You can then time the transfers.
>
> That should help!
>
>
>
> On Wed, 07 Sep 2005 19:22:58 +0200, Max Riedel wrote:
>
> >Hi!
> >Maybe you can help me, would be very nice!
> >I'm new to the list and I'm very glad that it exists...
> >A week ago we migrated to samba and since then it's taking very
long to
> >save a 1,8MB excel document. On fast ethernet it takes us about 10
> >seconds, on wireless lan it can take up to a minute, although
> >transferring the same amount of data from the very same machine, that
is
> >connected via 802.11g, to samba (by copying a file) takes only about
> >3-4seconds over the wireless connection.
> >We use Excel in Office 2003 with SP1. Machine is a WinXP Pro SP2.
> >It looks as if it was Excel's fault, but it also seems to be much
slower
> >now since the files are stored on the samba server.
> >
> >Is there any way to enhance Excel's writing or maybe the caching on
the
> >server?Most of the files are smaller than 300kbytes, but this
particular
> >one is ~1,8MB and used VERY frequently.
> >
> >Samba version is 3.0.20
> >
> >System's running on an Athlon XP 2.400+, 512MB ram, Redhat
Enterprise
> WS 4
> >
> >The smb.conf looks like:
> >
> >[global]
> >
> > netbios name = smb
> >
> > workgroup = WORKGROUP
> >
> > server string = Samba Server
> >
> > hosts allow = 192.168.0.
> >
> > guest account = guest
> >
> > log file = /var/log/samba/%m.log
> >
> > max log size = 500
> >
> > security = user
> >
> > ;oplocks = no
> > ;level2 oplocks = no
> >
> > encrypt passwords = yes
> > smb passwd file = /etc/samba/smbpasswd
> >
> > socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192 
> IPTOS_LOWDELAY
> >
> > ;getwd cache = yes
> > ;dead time = 15
> > ;read raw = yes
> > ;write raw = yes
> >
> > interfaces = 192.168.0.102/24
> >
> > remote announce = 192.168.0.255
> >
> > local master = yes
> >
> > os level = 200
> >
> > preferred master = yes
> >
> > name resolve order = wins lmhosts bcast
> >
> > wins support = yes
> >
> > dns proxy = no
> >
> > preserve case = no
> > default case = lower
> > case sensitive = no
> >
> >
> > idmap uid = 16777216-33554431
> > idmap gid = 16777216-33554431
> > template shell = /bin/false
> > winbind use default domain = no
> >
> >[shared]
> > comment = Temporary file space
> > path = /smb/shared
> > public = yes
> > writeable = yes
> > create mask = 0640
> > directory mask = 750
> > force create mode = 020
> > force directory mode = 020
> > guest ok = yes
> > force group = users
> >
> >[daten]
> > comment = Root
> > path = /smb/daten
> > valid users = @verwaltung
> > write list = @verwaltung
> > force group = users
> > create mask = 0640
> > directory mask = 750
> > force create mode = 020
> > force directory mode = 020
> >
> >[folder1]
> > path = /smb/daten/folder1
> > valid users = @users
> > writeable = yes
> > public = yes
> > force group = users
> > create mask = 0640
> > directory mask = 750
> > force create mode = 020
> > force directory mode = 020
> >
> >[folder2]
> > path = /smb/daten/folder2/
> > valid users = @users
> > writeable = no
> > write list = silvia, @verwaltung
> > force group = users
> > create mask = 0640
> > directory mask = 750
> > force create mode = 020
> > force directory mode = 020
> >
> >
> >
> >Thanks alot for any help!
> >--
> >To unsubscribe from this list go to the following URL and read the
> >instructions: _https://lists.samba.org/mailman/listinfo/samba_
>