Getting the contents of whole tables is a complete waste of time. You should be reading subsets of data. For example, to read new (recent) InvoiceLines directly out of QuickBooks use:
select * from InvoiceLine UNOPTIMIZED WHERE Txndate > {d '2009-01-01'}
Or you can fully resync your optimized InvoiceLine table by first doing:
sp_optimizefullsync InvoiceLine
then read directly out of the optimized table by doing:
select * from InvoiceLine NOSYNC WHERE Txndate > {d '2009-01-01'}
This is very f...a.......s.................t.
Another good example of using NOSYNC would be to get for example all historical invoicelines before 2008:
SELECT * from InvoiceLine NOSYNC WHERE Txndate < {d '2008-01-01'}
as invocies before 2008 don't ever change, you can read them directly from the QODBC Optimizer. You just need to use unoptimized for crtical operations like Sales Commisions etc.
|