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