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
|
|
Slow first query bust fast after that |
Author |
Message |
|
Posted : 2006-07-13 07:16:22 |
SELECT TxnID, RefNumber, BillAddressAddr1, BillAddressAddr2, BillAddressAddr3, BillAddressAddr4, BillAddressCity, BillAddressState, BillAddressPostalCode, ShipAddressPostalCode, InvoiceLineItemRefFullName, InvoiceLineDesc, InvoiceLineQuantity, CustomFieldInvoiceLineBINLOCATION FROM InvoiceLine NOSYNC WHERE (RefNumber = 'InoivceNumber')
Wierd problem. I run my custom program written in vb.net when it goes to query it takes at least a minute for the first query. Any query after that is about 4 to 10 seconds. any ideas on the cause? When the odbc status window comes up it says waiting on quick books. The quick books file is farily large but does not seem to consume anything put cpu usage untill the records are returned.
Thank you
David
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-07-13 09:13:34 |
Even when using the NOSYNC tag, QODBC still needs to connect to QuickBooks and resync payments made to InvoiceLines. So the behaviour you describe is normal. |
|
|
|
|