Overview
Large QuickBooks company files can take significant time to synchronize. QQube retrieves data through the Intuit Software Development Kit (SDK), not through a direct database connection, so extraction speed depends heavily on the amount of data requested and the computer running the synchronization.
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.
Do not stop the synchronization unless you have confirmed that the process has actually stopped. Interrupting a synchronization can leave the QQube database incomplete and may require a complete clear and reload.
What Affects Extraction Time
- The size and age of the QuickBooks company file.
- The number of QQube data models selected.
- The extraction date range.
- The amount of transaction and reporting detail available through the Intuit SDK.
- The processor performance of the computer or server running the synchronization.
Reduce Synchronization Time
Use the following steps to reduce unnecessary extraction work.
1. Let the Current Synchronization Finish
Large initial extractions can take considerable time. Keep QuickBooks open, keep the synchronization Windows session signed in, and allow the QQube Synchronizer to complete normally.
2. Select Only the Data Models You Need
QQube data models are self-contained. One data model does not need another data model in order to provide its subject-area reporting data.
For example, Job Costing already contains the information required for job-cost reporting. You do not need to load Sales, Purchases, and General Ledger solely to support Job Costing.
3. Limit the Extraction Date Range
Use the QQube Extraction Range settings to retrieve only the historical period required for reporting.
4. Schedule Large Initial Loads Appropriately
For QuickBooks company files larger than approximately 750 MB, run the initial data load overnight when practical.
5. Use Adequate Hardware
Processor performance has a substantial effect on extraction speed. Run QQube on a modern computer or server 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 reaches one or more of these levels:
| 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 for reference or separate QQube extraction and a smaller current file 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 and historical periods, scheduling large loads appropriately, and using adequate hardware.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article