[QODBC-Desktop] Troubleshooting - Update Query optimization.
Posted by Jack - QODBC Support on 04 January 2017 10:40 AM
|
|
Troubleshooting - Update Query optimization.Problem Description:Can you give me some insights on how to optimize an update query to the PriceLevelPerItem table? Solution:The Intuit qbXML SDK requires us to modify the whole PriceLevelPerItem table with every insert or update, so it's going to take even longer the more levels and items you have. The problem here is that Intuit requires the whole list to be updated with every operation, not a single row like the rest of QuickBooks! | |
|