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
|
|
make UPDATE statement run faster |
Author |
Message |
|
Posted : 2006-10-04 12:55:23 |
Why does update take forever. When QOBDC executes an UPDATE sql statement it takes 4-5 minutes for the UPDATE statement to complete.
How do I speed this and make run faster. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-10-04 21:50:18 |
This depends on your WHERE clause used in your UPDATE statement. When you run an UPDATE command, a SELECT is run to find qualified records, when one is found, then the record is re-qualified, the specified edit fields are changed, then we move to the next record. Each QODBC table has jump-ins which act like indexes. Jump-ins allow us to ask QuickBooks for the specific data IDs we are going to update instead of scanning large XML data streams.
For example:
update InvoiceLine set InvoiceLineRate=200 where TxnID='C38-1080104832' and TxnLineID = '7133-1197736106'
in this UPDATE the TxnID is a jump-in seen when you run:
sp_columns InvoiceLine
|
|
|
|
|