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 : Slow Performance using VB6 and ADOSearch Forum

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

 New Topic 
 
 Post Reply 
[1]  
 Slow Performance using VB6 and ADO 
 Author   Message 
  Mike Lutz 
  
 Group: Members 
 Posts: 2 
 Joined: 2009-02-19 
 Profile
 Posted : 2009-02-19 09:36:29

Why does it take forever to query a table via the ODBC driver?  The data I gather generate SQL INSERT scripts to add the data to another SQL Server.  When I run the SQL INSERT scripts to the new SQL it takes seconds to add 5000 records but takes 15 minutes just to query the table to get the data.  The ODBC driver status chunks data, why?  Please help increase query times!

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2009-02-19 10:30:35
See: How do I setup the QODBC Optimizer? Where are the Optimizer options?  

  Top 
  Mike Lutz 
  
 Group: Members 
 Posts: 2 
 Joined: 2009-02-19 
 Profile
 Posted : 2009-02-19 10:57:38
This is absolutely crazy.  I can write an app to get 50000 records to an SQL Server and get the results in maybe 10 seconds.  Just to query 1000 records take 5-6 minutes.  Why?  I have been writing applications that access databases for years now and this has to be the slowest and worse I have ever seen.  Please explain why it takes so long! 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2009-02-19 17:22:00

QODBC is a very fast ODBC driver, especially when you realize there's no database here. There's no SQL Server here. The QuickBooks interface SDK, which uses XML, is not the speediest file system available, but it does the job. The QODBC driver works with all front-end applications which can access ODBC, some of which are faster than others. QODBC converts a SQL statement to an XML Request which is sent to Intuit's qbXML SDK which is then processed by the QuickBooks application and a XML Document returned and QODBC strips out all the XML tags and returns you the data.

For this reason we added the QODBC Optimizer which is a SQLite Server that runs at a user (workstation) level. If you add a NOSYNC to your SELECT query, things run much faster:

select * from InvoiceLine NOSYNC WHERE Txndate > {d '2008-04-01'}

Unfortunately, it can't do anything about INSERTs.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to