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 and not Wi-Fi.

Network speed should be 1Gbps

If your QuickBooks database is hosted on another computer or a server then the network speed should be 1Gbps. Wi-Fi connections or cable connections at 100Mbps could lead to issues especially on large databases

Check computer updates CPU and RAM. 

Ensure that you are using the latest windows updates, not outdated Windows operating system. QuickBooks need RAM. It is recommended to work with 4GB Ram but if you have large databases then additional RAM and / or higher CPU capabilities would increase the performance.

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