Improve QuickBooks Performance

If your QuickBooks is performing slow, especially on a network multi user environment, then you may want to check for the following:

If this helps you then you can give us credit by sharing it to the Facebook or like our Facebook page 🙂

 

Use cable network only, not Wi-Fi connection

If your QuickBooks database is hosted on another computer or server then the network connection should be cabled 1 Gbps and not Wi-Fi.  Wi-Fi connections or cable connections at 100Mbps could lead to technical issues especially on large databases and a multi-user environment.

Check computer updates CPU and RAM and HHD both on QuickBooks Client PC and QuickBooks Host Server

  • Ensure that you are using the latest windows updates and definitely not outdated or discontinued Windows operating system.
  • QuickBooks needs RAM. The minimum is 4GB but 8GB Ram or more is recommended. If you have large databases and a multi -user environment then any additional RAM and / or higher CPU capabilities would increase the performance.
  • An SSD HDD would also increase the performance a lot, especially if you host on it Databases / Company Files

Is my QuickBooks compatible with the Windows operating system version I am using?

Compatibility can be a serious issue. If QuickBooks opens up and looks fine on your screen, then, it does not necessarily mean that it is compatible with your version of Windows or hardware. You may have issues where least expected.

Mapped drives with host name not IP address

If your QuickBooks database is hosted on another computer or a server then make sure that the connection to that server is through mapped drives and not IP address.

Rebuild your database

Rebuilding your database may help improve performance. Especially large databases need rebuilding more frequently than small database. To rebuild your database make sure that you login in single user mode and then go to the top menu and select File > Utilities > Rebuild data. It is always a good idea to rebuild your database on a regular period.

Check and excluded QBW32.EXE from Antivirus if any

Antiviruses some times or antivirus updates may block QuickBooks from functioning or reduce the performance. It is a good idea if your exclude QBW32.EXE from your antivirus scanning settings

Check if proper ports are opened on the firewall

If your QuickBooks database is hosted on another computer or server then make sure that windows firewall ports are properly opened on the host computer. You can find more on this article.

Database File Fragments

Press F2 while in QuickBooks company file and check the DB FILE FRAGMENTS, should be less than 2. If not, then it is a good idea if you defrag your server HDD

Install latest QuickBooks updates

Unless your QuickBooks version is discontinued then you are entitled and you should be able to receive QuickBooks updates. Please ensure that you are always using the latest QuickBooks updates. To manually check for updates, open your QuickBooks, go the top menu Help > Update QuickBooks Desktop

Upgrade to the newest QuickBooks version

Upgrade to the newest QuickBooks version to utilize the benefits of the new QuickBooks, features, engine and performance.

Large Database? Maybe it’s about time to start a new database.

If you have a large database, let say > 500 MB and none of the above works, then maybe it is just about time to consider changing to a new fresh database. If this is the case then you start a new database and start up with opening balances.

 

 

Leave a Reply