Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : QODBC v9 performance concernSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v9 Forum

 New Topic 
 
 Post Reply 
[1]  
 QODBC v9 performance concern 
 Author   Message 
  ATGoss 
  
 Group: Members 
 Posts: 22 
 Joined: 2007-06-30 
 Profile
 Posted : 2008-11-11 04:09:22
We just upgraded to Quickbooks Enterprise 09 and upgraded to QODBC v9. We are currently re-optimizing our tables by running our nightly queries one at a time. The Invoice table is updating painfully slow according to the Optimizer status window. It has been running for one hour and has processed 60 records. One record a minute is a bit ridiculous. Did the move to QB 09 cause QODBC to become slower? 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-11-11 08:26:40
No, when you updated to QODBC v9 all the installation defaults got reinstated. You need to change your optimization settings to use the The start of every new connection (with "Load Updated Data" first) option and confirm that the Multi-Table Sync option has been disabled. If not, uncheck the Multi-Table Sync option as this is often defaulted on (checked) with QuickBooks Enterprise and the QODBC Enterprise Desktop Edition.

 

  Top 
  ATGoss 
  
 Group: Members 
 Posts: 22 
 Joined: 2007-06-30 
 Profile
 Posted : 2008-11-11 09:42:49
I have checked these settings and they are all exactly as you listed.
The optimizer is now on record 425 of the Invoice table after 6 1/2 hours.... 

  Top 
  ATGoss 
  
 Group: Members 
 Posts: 22 
 Joined: 2007-06-30 
 Profile
 Posted : 2008-11-12 07:20:23
Would it make a difference that our license says "QODBC Desktop Read Write 2007" (serial number begins with W07U...)? The QODBC version is 9.0.0.253. I am just trying to understand what may have changed in our upgrade to Enterprise 9.0 that could have killed our query performance. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-11-12 07:48:18
Yes it does, you need to either purchase a new full product QODBC Read/Write CDKey Code with a serial number that begins with W09U... for QuickBooks Enterprise 9 (2009) or deactivate your W07U... CDKey Code so the QODBC optimizer can run in Enterprise Desktop (read only) mode correctly. 

  Top 
  ATGoss 
  
 Group: Members 
 Posts: 22 
 Joined: 2007-06-30 
 Profile
 Posted : 2008-11-13 05:14:08
Thank you. I was unclear on the licensing issue with using Enterprise 9.
The optimizer worked great this time on the Invoice table. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to