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

How to force HTTPS/SSL in AbleCommerce Gold

by Joe Payne 3. Januarie 2013 16:57

Just like AbleCommerce 7.x, AbleCommerce Gold uses a specific configuration file to identify which pages/folders should force SSL.  Obviously key pages like the login page, the admin pages, checkout etc are all set to force SSL by default. 

But sometimes you need your own custom stuff to force SSL.  In my case, it’s my Quickbooks Connector for AbleCommerce.  The Intuit Web Connector program will only transfer to a public IP using HTTPS.  Any attempt to do so with straight HTTP will result in an Authentication Failed error response.

To force SSL connection on a specific page/file in your AbleCommerce Gold install, edit the /App_Data/ssl.config file and add the appropriate file name.  You’ll see the necessary syntax with the other entries in the file.

Make sure the file name is in all lower case in the ssl.config AND the actual file on your drive.    Able has had some issues with failing to recognize filenames when the case is not the same between what’s in the ssl.config and the actual file itself.  This was supposed to be corrected in Gold R3 however that has not been confirmed as of this writing.

Tags: , ,

AC7 Articles | QuickBooks Connector

Quickbooks Web Connector for AbleCommerce v 2.0.2 Released

by Joe Payne 27. Januarie 2012 11:35

Minor update to the QB module was released today.  A few performance improvements and a couple of obscure bug fixes.  Nothing super major unless you’ve seen noticeable site degradation since your module was installed.

Complete Change List can be found on our Support Site

Tags: ,

General News | QuickBooks Connector

New version released for QuickBooks Web Connector for AbleCommerce 7

by Joe Payne 27. April 2011 15:32

Wow, what an great two months it’s been since I started this project.   So much progress, so many new features.  Few projects have been this enjoyable to bring to completion.

I’ve updated the product description for the QuickBooks module to reflect the new features added.  You can find it here:  http://www.ablemods.com/AbleCommerce-7-Web-Connector-for-QuickBooks-P1C1.aspx

The
downloadable Demo version has also been updated.  You can find it easily by clicking the Downloads tab near the top on the home page of www.AbleMods.com

Tags: , , ,

General News | New Products | QuickBooks Connector

Month List