Quickbooks Enterprise 13 and Above How To Increase Cache Size

by Joe Payne 7. November 2013 20:16

These steps apply when the full program is installed on the hosting computer (server) and QuickBooks Enterprise Solutions is on R6 release or later.

  1. Go to the computer (server) hosting the company file.
  2. Go to the QBW.ini file in the Intuit folder:
    • Windows Vista and later: C:\ProgramData\Intuit
    • Windows XP or Windows Server 2003: C:\Document and Settings\All Users\Application Data\Intuit\
  3. Click the QBW file. Note: This file is different from the one you can access directly from the program.
    • Use the information below to add a [DBSERVEROPTIONS] section with your chosen values.
      [DBSERVEROPTIONS]
      InitialCache=256 (if set to 0, meaning “None”)
      MaxCache=512 (if set to 0, meaning ‘Unlimited’)
      Notes about InitialCache: The initial cache setting is used only until the first company file is opened. The initial cache adjusts at that time. Setting it to 0 or none should have no impact on performance.
      Notes about MaxCache: The max cache is the maximum amount of memory QuickBooks database manager can use to communicate with the Sybase database file (company file). Increasing this can improve performance. Setting this to 0 makes it "Unlimited". It is not truly unlimited but actually "Database managed" and can use more memory when needed.
  4. Save the file.
  5. Important! For the .ini file settings you entered to "take affect" you need to turn off Hosting from the file menu and turn it back on.  This will disconnect any user's sessions that are running at the time.
  6. If you have a "server only install" you can do the steps below:
    1. From the command prompt, type: net stop QuickBooksDB23 (or QuickbooksDB24)
    2. From the command prompt, type: net stop QBCFMonitorService
    3. From the command prompt, type: net start QBCFMonitorService

Tags: , ,

QuickBooks Connector | Tech Support

How to improve Quickbooks Web Connector Speed

by Joe Payne 21. Februarie 2013 11:24

For years I have worked to improve the transfer speed of my AbleCommerce Web Connector for Quickbooks. But there’s only so much you can do in code. The rest is up to the internet connection, the speed of the Quickbooks PC and Quickbooks itself.

A client of mine found a document that details how to increase the cache memory allocation of the Quickbooks database engine. So he passed it along to me to try.

Why increase the cache memory you ask? Because the default is a whopping 512mb of RAM. Even if your PC hosting the quickbooks company file has 8gb of RAM, the database engine will only ever use 512mb. Way to keep up with the times Intuit.

Read the attached document and follow the steps. It will require a change to the registry. So know what you are doing, or find someone who does.

The reward is worth it. My larger QB connector clients were taking 2.5 hours to transfer 300+ orders in a single transfer session. Now it takes 20 minutes. Yeah. You read that right. 20 minutes. Same internet. Same PC. 20 minutes instead of 2.5 hours. That’s how much of a difference this can make for your QB installation.

Here’s the PDF.

Tags: , , ,

AC7 Articles | General News | Personal | QuickBooks Connector | Tech Support

Month List