• Skip to primary navigation
  • Skip to main content

QBGarage.com

The QuickBooks Specialists

  • Home
  • Blog
  • KnowledgeBase
  • Company
  • Show Search
Hide Search
You are here: Home / Archives for KnowledgeBase / Solving Problems / Performance Problems

Performance Problems

How Can I Improve the Performance of QuickBooks?

Chief Mechanic · September 12, 2010 ·

QuickBooks is a complex program that processes a lot of data.  As data is added to a QuickBooks company file (.qbw), loading and processing times increase.  Within the program, slower processing is usually seen when performing tasks that involve the entire company file, such as running utilities or preparing reports.  Since QuickBooks is typically used every day over a period of years, it’s highly likely that at some point you’ll find a need to improve performance.

There’s no single solution that will improve performance in every circumstance, but there are a series of steps you can take that together will have a dramatic impact on QuickBooks performance.  We’re ignoring the “common sense” recommendations of “buy a faster computer with more memory” or “upgrade to the latest version/update to the latest release.”  Spending money on new or upgraded hardware and not running outdated software will improve performance.

We recommend that you:

  1. Close your company file before exiting QuickBooks and reduce to a minimum the amount of windows that do open once you open your company file.  This will dramatically reduce the time it takes to load QuickBooks, which is one way users measure performance, but it won’t have any impact on performance while working in the program itself.
  2. Perform a manual, verified backup on a regular basis.  QuickBooks maintains a transaction log file (.tlg) that is used in conjunction with its manual, verified backup routine.  This .tlg file grows and can often become bigger than a company file (.qbw) itself.  A manual, verified backup reduces the .tlg file size and improves performance.  Scheduled QuickBooks backups don’t count, nor do other backup routines that you happen to use.  When the .tlg file exceeds 25% of the size of the company file (.qbw) size, it’s time to do a manual, verified backup.  Remember that the primary purpose of this step is to reduce the .tlg file size, not to back up data.
  3. Reduce your DB file fragments if they’re too high.  DB file fragments represent the degree to which pieces of your QuickBooks company file (.qbw) are scattered over your hard disk.  The more fragments you have, the lower your performance will be.  For most organizations, DB file fragments in the single digits are reasonable.  Organizations running Terminal Services will see more DB file fragments, into the low double digits, and that’s reasonable.  If your DB file fragments exceed those levels, convert your company file (.qbw) into a portable file, and then convert that portable file into a company file (.qbw).  That conversion routine will reduce DB file fragments and improve performance.
  4. Clear the queues for forms to be printed.  Large numbers of forms with the To be printed flag set can degrade performance.  The most common example of this problem is a large number of invoices that are in the print queue.  Remove these invoices from the print queue and performance will improve.
  5. Run the clean up utility to reduce your company file’s overall size.  For QuickBooks Pro and Premier, Intuit recommends keeping data files under 100 Mb for reasonable performance.  The clean up utility can remove stale list items and consolidate closed transactions, thereby shrinking file size and improving performance.
  6. Avoid excessive use of sub-accounts, sub-items, and Jobs, which are effectively sub-customers.  Relatively speaking, a sub-account requires more processing than a top-level account, so the more sub-level list entries you create, the slower your performance will be.  The performance penalty is small, so don’t let this fact alone discourage your use of sub-level entries when necessary.  Some organizations have used sub-level list entries excessively, when other QuickBooks features would have been better suited to the purpose.
  7. Stop using Google Desktop.  Google Desktop can only index a QuickBooks company file (.qbw) when that file is open.  Google Desktop indexing routines consume processing and memory resources, leaving fewer of these resources available to QuickBooks.  That will degrade performance.  Uninstalling Google Deskop will improve performance.
  8. Consider an upgrade to Enterprise Solutions.  The database engine behind Enterprise Solutions is more robust and is capable of handling larger company files at reasonable performance levels.  If your business has grown and your QuickBooks company file can’t be cleaned up to where it offers reasonable performance, Enterprise Solutions will provide improved performance.
  9. Investigate network issues if QuickBooks is installed on a network.  For example, mismatched network interface card (NIC) settings can significantly reduce network performance.  If QuickBooks is the primary program that’s used over the network, this network configuration issue can appear to be a QuickBooks performance problem.

For some of these recommendations, the impact will be significant.  For others, it may be imperceptible.  What works or doesn’t work will be heavily dependent on your own configuration.

Intuit describes some of these recommendations in this knowledge base article.

Vote This Post DownVote This Post Up (+1 rating, 1 votes)
Loading...

What Is the Transaction Log File?

Chief Mechanic · September 7, 2010 ·

The QuickBooks transaction log file is a log of all changes about to be made to the company file (.qbw) before they are actually recorded in the company file.  It is stored in the same folder as the company file itself.  It’s automatically created by QuickBooks.

The filename of the transaction log file is in the form:

[company file name].qbw.TLG

QuickBooks uses data written to the transaction log file to transparently complete the recording of transactions that were not completely recorded in the company file itself because a connection to the company file was lost.  The transaction log file can also be used in conjunction with a QuickBooks backup file (.qbb) to recover from a damaged company file.

The transaction log file is reset when:

  • you sucessfully complete a manual (not a scheduled or online) backup in QuickBooks
  • you restore a portable company file (.qbm)
  • the company file does not match the transaction log file

The company file may not match the transaction log file if you restore a backup of the company file using the same filename in the same folder or if you make a copy of a company file, take the copy to another computer and make changes, and put the changed copy back in the original location.  For example, if you want to make a copy of the company file and work on it on another computer, you need to copy both the company file itself and the corresponding transaction log file in order to preserve the data recovery benefits that the transaction log file offers.

Because the transaction log file is only reset under specific circumstances, it may grow in size and become larger than the QuickBooks company file itself.  Large transaction log files can have an adverse effect on overall QuickBooks performance, so it’s important to periodically cause the events that trigger a reset of the transaction log file.  If you perform a manual backup, it’s important to run the backup with some degree of verification enabled.  If you complete the backup without verification enabled, your transaction log file will be reset, and the unverified data in the backup may be unusable.

Additional information on the QuickBooks transaction log file can be found in this Intuit knowledge base article as well as our article on the file types used by QuickBooks.

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...

What Are the Errors Tied To the Integrated PDF Converter From Amyuni Technologies?

Chief Mechanic · September 5, 2010 ·

Printing problems, especially printing to a PDF using the integrated driver, are a common problem area.  As a result, there is a long series of similar errors, including:

  • Error Code 2
  • Error Code 5
  • Error Code -20
  • Error Code 20
  • Error Code 21
  • Error Code 22
  • Error Code 30 or -30
  • Error Code 32
  • Error Code 40
  • Error Code 41 or -41
  • Error Code 87
  • Error Code 126
  • Error Code 1797
  • Error Code 1801
  • Error Code 1930
Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...

What Does a Runtime Error Such As R6025 Mean?

Chief Mechanic · September 5, 2010 ·

According to Intuit, the error “Runtime Error! Program: C:Program FilesIntuitQuickBooks [Year]qbw32.exe R6025 – pure virtual function call” can occur when opening or closing QuickBooks.

Here’s a screenshot of the actual error message:

QuickBooks Premier 2007 Error Code R6025

The exact cause or this error hasn’t been determined.

Intuit recommends these steps to reduce the chance of this error recurring:

  1. shorten any customer or vendor names and company names to 32 characters or less
  2. remove any special characters from list items
  3. close any open embedded browser windows that may contain script errors

A quotation mark “, an apostrophe ‘, an open bracket [, or a close bracket ] in certain fields of list items can produce this error.

For more information about this error, consult this Intuit knowledge base article.

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...

What Does a Fatal Error Referring To the License Utility Mean?

Chief Mechanic · August 31, 2010 ·

According to Intuit, the following error can occur when starting QuickBooks:

Fatal Error: Function: LicenseUtility::Initialize Signature:bool_cdecl LicenseUtility::Initialize(void) File:..srcLicenseUtility.cpp Line:431

The error has multiple possible causes:

  1. Microsoft’s .NET framework is not functioning properly
  2. Windows Protected Storage service is stopped or disabled
  3. Your QuickBooks installation is damaged
  4. Your Windows operating system is damaged

To troubleshoot this problem, follow the steps outlined in this Intuit knowledge base article.

Vote This Post DownVote This Post Up (+1 rating, 1 votes)
Loading...
  • Go to page 1
  • Go to page 2
  • Go to Next Page »

Accounting

  • Financial Accounting Standards Board

Developer

  • Intuit Developer Network Forums
  • qbXML Onscreen Reference

Intuit

  • Enterprise Solutions
  • Intuit
  • Intuit Marketplace
  • QuickBooks
  • QuickBooks Online Community

QBGarage.com

Copyright © 2008–2023 QBGarage.com · Privacy · Terms & Conditions · Site Help