Synch is Slow or Appears to Freeze

Modified on Sun, 26 Jul at 2:25 AM

Overview

Extracting data from a large QuickBooks company file may take longer than expected. A manual refresh may also require more than several minutes.

QQube retrieves QuickBooks data through the Intuit Software Development Kit (SDK). This is not a direct database connection. Large or detailed extractions can therefore require substantial processor time.

Not Responding Does Not Necessarily Mean Frozen

If the QQube Configuration Tool displays Not Responding, the Intuit SDK may still be retrieving data from QuickBooks. High processor utilization with normal memory usage is expected during a large extraction.

Do not interrupt the synchronization unless you have confirmed that the process has stopped. An interrupted synchronization may require a complete clear and reload.

Why Extraction Can Take Time

QQube must use the Intuit SDK rather than a direct QuickBooks database connection.
The Intuit SDK was designed primarily for exchanging data with QuickBooks, not for high-speed bulk extraction.
QQube extracts extensive transaction, list, and reporting details.
Larger QuickBooks files and longer date ranges require more processing.

Improve Extraction Performance

1. Allow the Synchronization to Finish

Large initial extractions can take considerable time. Allow the process to complete without closing QuickBooks, logging off the synchronization user, or stopping the QQube Synchronizer.

2. Select Only the Required Data Models

Load only the data models needed for the reporting project. One data model is not dependent upon another.

For example, the Job Costing data model already contains the information required for job-cost reporting. You do not need to load Sales, Purchases, and General Ledger solely to support that model.

Review Selecting QuickBooks Data Models in QQube.

3. Limit the Extraction Date Range

Use the QQube Extraction Range settings to load only the required period of QuickBooks data.

4. Schedule Large Initial Loads Appropriately

Run initial data loads overnight when the QuickBooks company file is larger than approximately 750 MB.

5. Use Adequate Hardware

Extraction speed is heavily affected by processor performance. Install QQube on a computer or server with a modern processor rather than an older secondary workstation.

For hosted or Remote Desktop environments, allocate approximately 3 GB to 8 GB of memory for the synchronization user and related applications.

Very Large QuickBooks Company Files

Consider separating historical and current activity when the QuickBooks company file meets one or more of these conditions:

QuickBooks Environment	Large-File Indicator
QuickBooks Enterprise	Company file larger than approximately 1.25 GB
QuickBooks Pro or Premier	Company file larger than approximately 350 MB
Any QuickBooks Desktop edition	More than approximately 10 years of transaction history

A qualified QuickBooks file service can divide the company file into:

A historical file that remains available for reference or separate QQube extraction.
A smaller current file used for daily QuickBooks operations.

CLEARIFY has referred customers to Matt Clark at QB or Not QB for this service. CLEARIFY does not receive compensation for this referral.

Expected Result

The synchronization completes without interruption, and future extraction time is reduced by limiting unnecessary data models, shortening the extraction range, scheduling large loads appropriately, and using adequate hardware.