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
|
|
Querying SalesOrder table; Horrible performance |
Author |
Message |
|
Posted : 2007-12-01 05:49:45 |
Does anyone know why it would take 10 minutes to run the query and only to find an empty cursor set:
select TxnID, CustomerRefFullName,IsManuallyClosed from salesorder where RefNumber ='31727'
The sales order exists (happens to be the most recent S/O). I'm using QODBC v8.00.00.234 against QB Enterprise v6 w/ all of the latest updates installed
I also need to know how to extract SalesOrderLines relateing to a single Sales Order and how to update Sales Order Lines custom fields... |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-12-01 10:46:07 |
If you jst added the SaleOrder, the QODBC optimizer will need to resync, this takes time. So the best thing is to bypass optimizing the table and get the values you want in real time like this:
Select TxnID, CustomerRefFullName,IsManuallyClosed from salesorder calldirect where RefNumber ='31727' order by TimeCreated desc
or in the case of all the SaleOrderLInes:
Select * from salesorderline calldirect where RefNumber ='31727' order by TimeCreated desc |
|
|
|
|