Friday, February 02, 2007

QuickBooks Performance Issue

slowbooks


I've had a ton of trouble with QuickBooks lately, it was almost time to call in the QuickBooks Queen, but alas I solved the slow QuickBooks mystery.

Here's the scanario: Computer A hosted the QuickBooks company file and ran QuickBooks. Computer B ran QuickBooks locally, but pulled the data from Computer A. Both computers were had the same hardware specs and all other programs worked normally, except QuickBooks.

Symptoms: QuickBooks opened terribly slow after logon...32 seconds to be exact after entering the password. When switching company files it was the same thing, 32 seconds. (Keep in mind these are good computers with a lot of RAM and Processor power).

What we found: Computer A happened to also be the Spector CNE server and Computer A & B both had the Spector Recorders installed and reporting data to Computer A. When we uninstalled the recorder from Computer B the QuickBooks company file would open the file from Computer A 10 times faster.

The problem: Apparently if you host the QuickBooks file on a computer and that computer is also the Spector CNE server, and if the other computer wanting to open QuickBooks has the Spector CNE recorder then the performance of QuickBooks is degraded. It seemed that even if I switched the files around so that Computer A was pulling the data from B that there was still a performance issue, so I think that if you have Spector CNE Recorder installed at all then QuickBooks seems to take a hit over the network.

Remember, Check Design Ninjas for the latest.

No comments: