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
|
|
Can I query optimized file only? |
Author |
Message |
|
Posted : 2008-08-29 08:18:31 |
(I'm very new at this, so please be patient).
I am using EXCEL to query a 15000 item inventory file. I have optimizer running every night. When I open the EXCEL spreadsheet the next day, it takes 31 seconds to pull in the optimized file data, then takes 20 minutes to query the QB data file for changes. (This is what it seems like it's doing, because for the second pass there are many "waiting for QB.." messages that flash by).
In this case just using the optimized file would be good enough (gives me quantities as of the end of the day yesterday), is there a way to have Excel only read the refreshed optimized file, but not go over the network to get the up to the minute changes from QB itself?
DSN=QuickBooks Data;DFQ=\\Gt-server\company\QBEnterprise\GOLDEN TRIANGLE_Live_for_QBE7.QBW;SERVER=QODBC;OptimizerDBFolder=C:\Program Files\Intuit\QuickBooks Enterprise Solutions 7.0\Components\QODBC\Optimizer;OptimizerCurrency=Y;OptimizerAllowDirtyReads=N;SyncFromOtherTables=N;IAppReadOnly=Y
SELECT ItemInventory.FullName, ItemInventory.IsActive, ItemInventory.SalesDesc, ItemInventory.SalesPrice, ItemInventory.QuantityOnHand, ItemInventory.QuantityOnSalesOrder FROM ItemInventory ItemInventory WHERE (ItemInventory.QuantityOnHand>0) ORDER BY ItemInventory.FullName |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-08-29 08:29:52 |
Sure, just use the NOSYNC tag like this:
SELECT ItemInventory.FullName, ItemInventory.IsActive, ItemInventory.SalesDesc, ItemInventory.SalesPrice, ItemInventory.QuantityOnHand, ItemInventory.QuantityOnSalesOrder FROM ItemInventory NOSYNC WHERE (ItemInventory.QuantityOnHand>0) ORDER BY ItemInventory.FullName
See: How do I setup the QODBC Optimizer? Where are the Optimizer options? for more info. |
|
|
|
|
Posted : 2008-08-30 01:49:17 |
I tried this and it doesn't seem to make a difference. Maybe I'm misunderstanding the two passes. The first one (41 sec), I see a rapid count up to my 15000 records (records found), the second one (pass) is the long one and I don't see the same record count (records found 0...)
Here's the change I made per your suggestion
SELECT ItemInventory.FullName, ItemInventory.IsActive, ItemInventory.SalesDesc, ItemInventory.SalesPrice, ItemInventory.QuantityOnHand, ItemInventory.QuantityOnSalesOrder FROM ItemInventory NOSYNC WHERE (ItemInventory.QuantityOnHand>0) ORDER BY ItemInventory.FullName
Any other ideas? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-08-31 23:52:25 |
|
|
|
|