With the release of QODBC v6.00.00.155 (and later) we had to do a little more checking for deleted transactions and payments so tables that reference a open balance now run slower. Most users tend to use queries like:
SELECT * from Customer
which will run slowly as QODBC has to display the correct current balance for each customer, while this will run much faster:
SELECT "Name","LastName","FirstName","BillAddressAddr1", "BillAddressAddr2","BillAddressCity", "BillAddressState","BillAddressPostalcode" from Customer
However can also override your QODBC Optimizer configuration screen settings to suit what you are actually doing by using the following tags:
VERIFIED | VERIFY - Forces Full Resync with QuickBooks on the optimized table before Query starts CALLDIRECT | UNOPTIMIZED - Passthru query directly to QuickBooks - use no optimizations OPTIMIZE | OPTIMIZED | NOSYNC - Passthru query to optimized table directly for maximum speed
For example:
SELECT * from Customer NOSYNC
will run very fast as it uses our sqlite backend ................
See: How do I setup the QODBC Optimizer? Where are the Optimizer options? for more information on the QODBC Optimizer.
|