RE: [Samba] Slow performance with QuickBooks
I am also fairly confident that this organization IS outgrowing QuickBooks. However, I am using win9x machines to transfer to this server, and only able to see a few MB / second say 2 or 3 MB/sec (VIA FTP... eliminating Samba from the whole Picture). Samba is a little better than FTP speed wise, but not much. Win XP and FTP can transfer at 6-7,sometimes even 8 MB/sec. I swear I've checked everything. What could possibly be causing this. -Original Message- From: CLIFFORD ILKAY [mailto:[EMAIL PROTECTED] Sent: Sunday, June 01, 2003 4:26 PM To: [EMAIL PROTECTED] Subject: Re: [Samba] Slow performance with QuickBooks At 02:25 PM 28/05/2003 -0500, Brandon Lederer wrote: I have spent much of the day today researching performance tuning with samba. I have tried everything that I can find out about how to make performance faster. I checked disk performance with Bonnie, installed FTP and tested a transfer that way, achieving 6-7 MB / second. about 30 seconds for 150 MB file. I was finally able to achieve those speeds on a file transfer to the server through samba. But QuickBooks is still just as slow as it was. Its performance has not changed a bit. I am banging my head against the wall on this. I am going nuts. Please Help. I doubt it has anything to do with Samba. Have you tried to run QB on a Windows file server on the same or similar hardware? I suspect what you are running up against is an architectural limitation of QB. Many low end databases have abysmal performance in a multiuser situation and I doubt QB is any different. If you instrument your network, say with Ethereal, you will probably find that there is an incredible amount of network traffic as QB clients hit the QB data file on your Samba server. QB does not use a client/server architecture so even the simplest queries ship large data sets across the wire to the clients. It isn't just data but indexes as well that gets sent back to the client. Add a good measure of badly implemented locking in the database and you have a recipe for molasses slow network performance. Microsoft Access is also notorious for sluggish performance when you have more than a handful of clients accessing a .mdb file across the network so the problem is hardly unique to QB. Windows apps tend to like using opportunistic locking to improve perceived performance but the problem with that is the potential for database corruption. If you turn op locks off, which is the safe thing to do, performance will suffer. Many small businesses run blissfully ignorant of how vulnerable their data is in products like QuickBooks and Simply Accounting and many of them are lucky most of the time. However, when things blow up with these low end products, and they do on occasion, they blow up pretty spectacularly, particularly with larger accounting data files. Assuming further testing proves that Samba, something specific to your server, a bad networking component such as a driver, card, cable, jack, or switch is not the culprit and you conclude that it is after all an architectural limitation, if you cannot live with the poor network performance of QuickBooks, you may want to consider an accounting application that is better designed. I'm evaluating SQL Ledger http://www.sql-ledger.org which is an Open Source client/server product. Regards, Clifford Ilkay Dinamis Corporation 3266 Yonge Street, Suite 1419 Toronto, Ontario Canada M4N 3P6 Tel: 416-410-3326 mailto:[EMAIL PROTECTED] -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba
RE: [Samba] Slow performance with QuickBooks
Its definitely a problem with quickbooks. I had a client that had a rather large qb file (about 120MB). It died a spectacular death. What was amazing is how quickbooks handled it. They told my client that their data files were only safe up to around 20MB at the most. This was repeated at their highest level of paid support. We sent our data file to them to rebuild and were told that we needed to move to a different product if we were going to continue to have so much data stored in their system. I would never use something like quickbooks again... Their multi-user support sucks! Jason N. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of CLIFFORD ILKAY Sent: Sunday, June 01, 2003 4:26 PM To: [EMAIL PROTECTED] Subject: Re: [Samba] Slow performance with QuickBooks At 02:25 PM 28/05/2003 -0500, Brandon Lederer wrote: I have spent much of the day today researching performance tuning with samba. I have tried everything that I can find out about how to make performance faster. I checked disk performance with Bonnie, installed FTP and tested a transfer that way, achieving 6-7 MB / second. about 30 seconds for 150 MB file. I was finally able to achieve those speeds on a file transfer to the server through samba. But QuickBooks is still just as slow as it was. Its performance has not changed a bit. I am banging my head against the wall on this. I am going nuts. Please Help. I doubt it has anything to do with Samba. Have you tried to run QB on a Windows file server on the same or similar hardware? I suspect what you are running up against is an architectural limitation of QB. Many low end databases have abysmal performance in a multiuser situation and I doubt QB is any different. If you instrument your network, say with Ethereal, you will probably find that there is an incredible amount of network traffic as QB clients hit the QB data file on your Samba server. QB does not use a client/server architecture so even the simplest queries ship large data sets across the wire to the clients. It isn't just data but indexes as well that gets sent back to the client. Add a good measure of badly implemented locking in the database and you have a recipe for molasses slow network performance. Microsoft Access is also notorious for sluggish performance when you have more than a handful of clients accessing a .mdb file across the network so the problem is hardly unique to QB. Windows apps tend to like using opportunistic locking to improve perceived performance but the problem with that is the potential for database corruption. If you turn op locks off, which is the safe thing to do, performance will suffer. Many small businesses run blissfully ignorant of how vulnerable their data is in products like QuickBooks and Simply Accounting and many of them are lucky most of the time. However, when things blow up with these low end products, and they do on occasion, they blow up pretty spectacularly, particularly with larger accounting data files. Assuming further testing proves that Samba, something specific to your server, a bad networking component such as a driver, card, cable, jack, or switch is not the culprit and you conclude that it is after all an architectural limitation, if you cannot live with the poor network performance of QuickBooks, you may want to consider an accounting application that is better designed. I'm evaluating SQL Ledger http://www.sql-ledger.org which is an Open Source client/server product. Regards, Clifford Ilkay Dinamis Corporation 3266 Yonge Street, Suite 1419 Toronto, Ontario Canada M4N 3P6 Tel: 416-410-3326 mailto:[EMAIL PROTECTED] -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba
RE: [Samba] Slow performance with QuickBooks
I am not sure which version of Samba you are using, but the first thing anybody is going to tell you is to upgrade to 2.2.8, if you already haven't. After that take a look at some of the notes found on our web site at: http://www.Drouillard.ca/TipsTricks/Samba/Oplocks.htm Also a few things interesting in your config file: socket options = TCP_NODELAY IPTOS_LOWDELAY SO_SNDBUF=2048 SO_RCVBUF=2048 It would be surprising if bumping up the BUF's did not increase the speed. You can find a test program in the above link to help you with that. What is the speed of your network and NIC? Regards - Gerald Drouillard President Drouillard Associates, Inc. http://www.Drouillard.ca -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brandon Lederer Sent: Wednesday, May 28, 2003 5:39 PM To: [EMAIL PROTECTED] Subject: RE: [Samba] Slow performance with QuickBooks Yes OPLOCKS are off. My smb.conf file follows: [global] workgroup = HMS server string = CBS Quickbooks Server (Samba) load printers = yes printer admin = @HMS+adminx printcap name = cups printing = cups guest ok = no restrict anonymous = yes valid users = @HMS+cbsusers, roz, root, dennis #invalid users = root admin users = root, @HMS+adminx log file = /var/log/samba/log.%m # max size of the log files (in Kb). max log size = 1000 #log level = 100 syslog = 0 security = domain password server = hms-pdc encrypt passwords = yes browsable = yes socket options = TCP_NODELAY IPTOS_LOWDELAY SO_SNDBUF=2048 SO_RCVBUF=2048 #I've been playing with this here. 8192 made it slower oplocks = no level2 oplocks = no wins server = 192.168.2.5 dns proxy = no passwd program = /usr/bin/passwd %u passwd chat = *Enter\snew\sUNIX\spassword:* %n\n *Retype\snew\sUNIX\spassword:* %n\n . winbind uid = 1-2 winbind gid = 1-2 template shell = /bin/false template homedir = /dev/null winbind cache time = 10 winbind separator = + #and the relevant share [qbdata] comment = QuickBooks Data path = /data/qbdata browsable = yes writable = no write list = @HMS+Finance, @HMS+adminx create mode = 0770 force create mode = 0770 directory mode = 0770 force directory mode = 0770 -Original Message- From: Gerald Drouillard [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 4:20 PM To: Brandon Lederer; [EMAIL PROTECTED] Subject: RE: [Samba] Slow performance with QuickBooks Did you turn oplocks off? Can we see your smb.conf file? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brandon Lederer Sent: Wednesday, May 28, 2003 4:05 PM To: '[EMAIL PROTECTED]' Subject: RE: [Samba] Slow performance with QuickBooks Just also verified that WinXP and Win98SE Exhibit the SAME issue. almost identical time from one OS to the Other. I just cant seem to make it any better. -Original Message- From: Brandon Lederer [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 2:26 PM To: '[EMAIL PROTECTED]' Subject: [Samba] Slow performance with QuickBooks I have spent much of the day today researching performance tuning with samba. I have tried everything that I can find out about how to make performance faster. I checked disk performance with Bonnie, installed FTP and tested a transfer that way, achieving 6-7 MB / second. about 30 seconds for 150 MB file. I was finally able to achieve those speeds on a file transfer to the server through samba. But QuickBooks is still just as slow as it was. Its performance has not changed a bit. I am banging my head against the wall on this. I am going nuts. Please Help. Brandon -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba
RE: [Samba] Slow performance with QuickBooks
I used an Excellent Loaded WINXP computer today. Samba is outspeeding FTP. Approaching 7 MB / sec on reads, 6 MB / sec on writes. Linux sees these speeds on FTP. Unable to test sambaclient on Linux. This isn't anything to complain about, albeit there is _better_. But a decent 98SE machine cant touch these speeds. Is there any explanation as to why? -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba
RE: [Samba] Slow performance with QuickBooks
That's strange. Samba shouldn't be able to get close to FTP speeds. I was able to get 10.5MB/sec with FTP and only 7.59MB/sec with Samba. I'm running on a switched 100Mb network. The network seems to be my limitation in my case as my server hard drives seem to be able to output about 20MB/sec. I can get the same speeds on Win98 as I can on WinXP. You have to tune a default Win98's TCP/IP performance to get the best results out of it. quote who=Brandon Lederer I used an Excellent Loaded WINXP computer today. Samba is outspeeding FTP. Approaching 7 MB / sec on reads, 6 MB / sec on writes. Linux sees these speeds on FTP. Unable to test sambaclient on Linux. This isn't anything to complain about, albeit there is _better_. But a decent 98SE machine cant touch these speeds. Is there any explanation as to why? -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba
RE: [Samba] Slow performance with QuickBooks
Just also verified that WinXP and Win98SE Exhibit the SAME issue. almost identical time from one OS to the Other. I just cant seem to make it any better. -Original Message- From: Brandon Lederer [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 2:26 PM To: '[EMAIL PROTECTED]' Subject: [Samba] Slow performance with QuickBooks I have spent much of the day today researching performance tuning with samba. I have tried everything that I can find out about how to make performance faster. I checked disk performance with Bonnie, installed FTP and tested a transfer that way, achieving 6-7 MB / second. about 30 seconds for 150 MB file. I was finally able to achieve those speeds on a file transfer to the server through samba. But QuickBooks is still just as slow as it was. Its performance has not changed a bit. I am banging my head against the wall on this. I am going nuts. Please Help. Brandon -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba
RE: [Samba] Slow performance with QuickBooks
Did you turn oplocks off? Can we see your smb.conf file? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brandon Lederer Sent: Wednesday, May 28, 2003 4:05 PM To: '[EMAIL PROTECTED]' Subject: RE: [Samba] Slow performance with QuickBooks Just also verified that WinXP and Win98SE Exhibit the SAME issue. almost identical time from one OS to the Other. I just cant seem to make it any better. -Original Message- From: Brandon Lederer [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 2:26 PM To: '[EMAIL PROTECTED]' Subject: [Samba] Slow performance with QuickBooks I have spent much of the day today researching performance tuning with samba. I have tried everything that I can find out about how to make performance faster. I checked disk performance with Bonnie, installed FTP and tested a transfer that way, achieving 6-7 MB / second. about 30 seconds for 150 MB file. I was finally able to achieve those speeds on a file transfer to the server through samba. But QuickBooks is still just as slow as it was. Its performance has not changed a bit. I am banging my head against the wall on this. I am going nuts. Please Help. Brandon -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba
RE: [Samba] Slow performance with QuickBooks
Yes OPLOCKS are off. My smb.conf file follows: [global] workgroup = HMS server string = CBS Quickbooks Server (Samba) load printers = yes printer admin = @HMS+adminx printcap name = cups printing = cups guest ok = no restrict anonymous = yes valid users = @HMS+cbsusers, roz, root, dennis #invalid users = root admin users = root, @HMS+adminx log file = /var/log/samba/log.%m # max size of the log files (in Kb). max log size = 1000 #log level = 100 syslog = 0 security = domain password server = hms-pdc encrypt passwords = yes browsable = yes socket options = TCP_NODELAY IPTOS_LOWDELAY SO_SNDBUF=2048 SO_RCVBUF=2048 #I've been playing with this here. 8192 made it slower oplocks = no level2 oplocks = no wins server = 192.168.2.5 dns proxy = no passwd program = /usr/bin/passwd %u passwd chat = *Enter\snew\sUNIX\spassword:* %n\n *Retype\snew\sUNIX\spassword:* %n\n . winbind uid = 1-2 winbind gid = 1-2 template shell = /bin/false template homedir = /dev/null winbind cache time = 10 winbind separator = + #and the relevant share [qbdata] comment = QuickBooks Data path = /data/qbdata browsable = yes writable = no write list = @HMS+Finance, @HMS+adminx create mode = 0770 force create mode = 0770 directory mode = 0770 force directory mode = 0770 -Original Message- From: Gerald Drouillard [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 4:20 PM To: Brandon Lederer; [EMAIL PROTECTED] Subject: RE: [Samba] Slow performance with QuickBooks Did you turn oplocks off? Can we see your smb.conf file? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brandon Lederer Sent: Wednesday, May 28, 2003 4:05 PM To: '[EMAIL PROTECTED]' Subject: RE: [Samba] Slow performance with QuickBooks Just also verified that WinXP and Win98SE Exhibit the SAME issue. almost identical time from one OS to the Other. I just cant seem to make it any better. -Original Message- From: Brandon Lederer [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 2:26 PM To: '[EMAIL PROTECTED]' Subject: [Samba] Slow performance with QuickBooks I have spent much of the day today researching performance tuning with samba. I have tried everything that I can find out about how to make performance faster. I checked disk performance with Bonnie, installed FTP and tested a transfer that way, achieving 6-7 MB / second. about 30 seconds for 150 MB file. I was finally able to achieve those speeds on a file transfer to the server through samba. But QuickBooks is still just as slow as it was. Its performance has not changed a bit. I am banging my head against the wall on this. I am going nuts. Please Help. Brandon -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba
