Quickbooks PRO 2006 multi-user extremely slow
Posted on 2006-10-25
Would greatly appreciate if someone could help with this.
We use Quickbooks PRO 2006 - multi-user (3 users in office)
Setup - Quickbooks is installed on the 3 users computers
- The company file resides on a share on a SBS 2003 server
Problem: Extremely slow performance when using Quickbooks. It gets even worse when multiple users are on it at the same time.
I have already contacted QB for support (terribly frustrating experience) - our company file was 90mb - basically all they said we could do is reduce the company file by archiving and condensing and stating to me that as long as we are under 60MB we should be fine in terms of performance. I archived and condensed the file to get it down to 44MB. The performance is STILL terrible.
I have also adjusted numerous items in the company preferences ie. turning off audit trail, turning off warning about duplicate invoices etc etc. None of this seems to help much.
Additional info: Small office environment - server has 2 GB RAM, plenty of CPU power - so I really don't think it's the hardware involved.
This has been extremely frustrating as QB tech support doesn't seem to have any answers for me other than the size of the company file.
1 item to note: We have 2 MAC users in the office who connect to the server for their mail using IMAP - sometimes it seems as though the performance of QB is better when the MAC users are offline or not in the office. I am not sure if the MAC users thru their connection to the exchange server via IMAP aren't having some affect on the network performance.
If anyone has experienced similar problems or could point me in the right direction it would be much appreciated!