QuickBooks being a bit sluggish for you?

Apart from adding newer, faster hardware (think solid state drives) or having your file supercondensed, here are some less obvious ways to possibly get a speed increase.

1. Turn off the built-in search indexing in QuickBooks. This is a company preference that enables you to do the quick, global search with F3. But that instant search capability comes at a price: slower performance for other functions, particularly saving new transactions. This is particularly true with very large files, or with version 2013 files.

So try this: Click on Edit / Preferences / Search / Company preferences. Uncheck the search box, or the search update automatically box, depending on your version of QuickBooks. Rebuild your file. Close out of QuickBooks, then open it up again. Are formerly sluggish processes faster? They might be. (If the rebuild step failed, your file has other issues.)

(Note: you can still search in your company file after turning off Search, but it will take longer.)

RELATED: Why QuickBooks Is Sometimes Slow
Condensing a Big QuickBooks File Without Downtime
Interview: User with a Big, Slow QuickBooks File

2. Get rid of unneeded memorized reports. Some users save a bunch of memorized reports over the years that become irrelevant later on. Get rid of the memorized reports you don’t need anymore.

We have seen cases where QuickBooks performance slows way down if you have memorized reports numbering in the dozens. Not sure why this is exactly. Maybe QuickBooks pre-populates at least some of the information in the memorized reports whenever you save new transactions? Maybe. In any event, we’ve seen performance increases sometimes when you parse the list of memorized reports down significantly.

To delete unneeded memorized reports, click Reports / Memorized Reports / Memorized Reports List. Right click on any unneeded report and select Delete Memorized Report.

3. Delete the TLG file. The TLG file – transaction log file – is an auxiliary file that QuickBooks automatically creates and maintains alongside your main file. The TLG file doesn’t have to be there for QuickBooks to work correctly; it can be deleted without data loss. (It sometimes is useful in data recovery situations, however.)

If the TLG file gets very large — say, over 1GB — then it might start to slow down QuickBooks, especially when you are adding new transactions.

RELATED: The Case of the Exploding TLG File
A Humble Hero: The QuickBooks TLG File
The Biggest QuickBooks File in the World

The simplest way to delete the TLG file is to just make a verified backup of your file in QuickBooks. That will blank out the TLG file and start it over again.

You can simply click File / Create Backup / Local Backup, and click the Options button. Make sure that “Complete verification” is selected. Finish making the backup, and the TLG file will be reset to a blank file. (If there are problems verifying the file, contact us for help.)

You should make sure that your automatic backup system is backing up the TLG file in addition to your QBW file, in case you need it later. Or, you can just manually move it in Windows from its current folder to a backup folder that you have created.

Anybody tried any of these techniques? How did they work for you?

Leave a reply

required

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>