I did testing on generating this report from a 130 MB Quickbooks file. Locally, 15 seconds. Samba Server, 1:35. Shared off of my win98 Workstation, 2+ mins. I do not understand the reason it is SOO slow. I know it is a fairly large file. The only explanation I can come up with is the way QuickBooks is accessing the files. Maybe jumping all around the file, requiring many operations on the file. Can anyone explain this? Opening the Check Register is horrendously slow, generating reports is slow. Its all around SLOW. I Know QB is slow, but its not this bad. Thanks In advance, Brandon
I have QucikBooks on our network too. I have had a number of problems with this crappy software. If my client actually wanted me too I'd rather create my own accounting software with a better interface and a mysql backend but that isn't going to happen. A few things with QuickBooks that I have noticed that maybe will help. #1. QuickBooks in multi-user mode is much slower than in single user mode. This is the (crappy) design of QuickBooks. It has to do with the fact that QuickBooks checks everything everywhere when in multiuser mode to make sure that no data gets corrupted (even though it has corrupted before). Our company datafile is around ~180mb. #2. This problem will not be solved easily at all. Quickbooks appears to be as slow as the weakest client link. In our case a P2 300 w/ 64 megs of ram. Again, this has to do with #1. #3. Upgrading Quickbooks won't help. We've had many versions in the past and currently run the "Enterprise Edition." It still can be as slow as a turtle under certain operations. #4. My biggest complain with this software is that it requires it's users to be "Power Users." Boy do I hate that.... With samba it's very difficult for me to limit a Power user's ability and I have had people take advantge of it repeatedly. Damn QuickBooks.... -Peter
Quickbooks is SO slow, we are having all of the same issues listed here. Our QB file is about 250 MB and is slow as a turtle. It is nearly unusable in a networked environment. If i put the file on the Local Machine, it is fine. It is only Slightly faster on a win2k server, i believe. Im not convinced its samba by any stretch. But can anyone reccomend a better product, cuz this product (QB) is terrible. -----Original Message----- From: Justin Kreger [mailto:jkreger@lwolenczak.net] Sent: Thursday, June 19, 2003 12:04 AM To: drgn65@ufl.edu Cc: samba@lists.samba.org Subject: RE: [Samba] Quickbooks revisited -- To unsubscribe from this list go to the following URL and read the instructions: http://lists.samba.org/mailman/listinfo/samba
How about mas90? /me runs On Thu, 2003-06-19 at 14:31, Brandon Lederer wrote:> Quickbooks is SO slow, we are having all of the same issues listed here. > Our QB file is about 250 MB and is slow as a turtle. It is nearly unusable > in a networked environment. If i put the file on the Local Machine, it is > fine. It is only Slightly faster on a win2k server, i believe. Im not > convinced its samba by any stretch. But can anyone reccomend a better > product, cuz this product (QB) is terrible. > > -----Original Message----- > From: Justin Kreger [mailto:jkreger@lwolenczak.net] > Sent: Thursday, June 19, 2003 12:04 AM > To: drgn65@ufl.edu > Cc: samba@lists.samba.org > Subject: RE: [Samba] Quickbooks revisited > > > -- > To unsubscribe from this list go to the following URL and read the > instructions: http://lists.samba.org/mailman/listinfo/samba-------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part Url : http://lists.samba.org/archive/samba/attachments/20030619/a78fe26a/attachment.bin
Another possible cause, from a windows newsgroup though.. http://tinyurl.com/er42 Go to google groups and type in 2 keywords: QuickBooks slow You will have a lot of reading to do...there are some good suggestions out there. Quickbooks is SO slow, we are having all of the same issues listed here. Our QB file is about 250 MB and is slow as a turtle. It is nearly unusable in a networked environment. If i put the file on the Local Machine, it is fine. It is only Slightly faster on a win2k server, i believe. Im not convinced its samba by any stretch. But can anyone reccomend a better product, cuz this product (QB) is terrible. -----Original Message----- From: Justin Kreger [mailto:jkreger@lwolenczak.net] Sent: Thursday, June 19, 2003 12:04 AM To: drgn65@ufl.edu Cc: samba@lists.samba.org Subject: RE: [Samba] Quickbooks revisited -- 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
Disabling Norton AV made no noticeable difference. -----Original Message----- From: Mark [mailto:lists@greplinux.dyndns.org] Sent: Thursday, June 19, 2003 2:11 PM To: 'Brandon Lederer'; samba@lists.samba.org Subject: RE: [Samba] Quickbooks revisited Another possible cause, from a windows newsgroup though.. http://tinyurl.com/er42 Go to google groups and type in 2 keywords: QuickBooks slow You will have a lot of reading to do...there are some good suggestions out there. Quickbooks is SO slow, we are having all of the same issues listed here. Our QB file is about 250 MB and is slow as a turtle. It is nearly unusable in a networked environment. If i put the file on the Local Machine, it is fine. It is only Slightly faster on a win2k server, i believe. Im not convinced its samba by any stretch. But can anyone reccomend a better product, cuz this product (QB) is terrible. -----Original Message----- From: Justin Kreger [mailto:jkreger@lwolenczak.net] Sent: Thursday, June 19, 2003 12:04 AM To: drgn65@ufl.edu Cc: samba@lists.samba.org Subject: RE: [Samba] Quickbooks revisited -- 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
> Quickbooks is SO slow, we are having all of the same issues listed here. > Our QB file is about 250 MB and is slow as a turtle. It is nearly unusable > in a networked environment. If i put the file on the Local Machine, it is > fine. It is only Slightly faster on a win2k server, i believe. Im not > convinced its samba by any stretch. But can anyone reccomend a better > product, cuz this product (QB) is terrible.Well, since Intuit strongly recommends not letting your QB data file get much bigger than 40MB for this very reason, I would say the file size is your problem. Charles
> Quickbooks is SO slow, we are having all of the same issues listed here. > Our QB file is about 250 MB and is slow as a turtle. It is nearly unusable > in a networked environment. If i put the file on the Local Machine, it is > fine. It is only Slightly faster on a win2k server, i believe. Im not > convinced its samba by any stretch. But can anyone reccomend a better > product, cuz this product (QB) is terrible.Well, since Intuit strongly recommends not letting your QB data file get much bigger than 40MB for this very reason, I would say the file size is your problem. Sorry, forgot to recommend something... Have you had a look at SQL Ledger? It's OSS, free, and they have very reasonable hosting and maintenance contracts available. www.sql-ledger.com I've been trying to get our Comptroller to look at it, but he's pushing for MAS90 because thats what he knows (I guess its good, but its expensive). Charles