Hi, I'm trying to keep my inventory 100% up to date on a website, all the time. Since QB's TimeModified doesn't update when items are invoiced/salesordered, the only way to do this is to run a query like this:

SELECT ListID, QuantityOnHand FROM ItemInventory UNOPTIMIZED

I have 10,985 inventory items, which makes this query take 33minutes -- making it difficult to have up--to-date inventory every hour. Is there a trick to make this run faster? I need my  ACTUAL inventory numbers; this would be simple if Intuit used the timestamps in QB, but since they don't I do not see an alternative option.

Please advise, I'm using QODBC 9 and Enterprise Solutions 9 US edition.  

SELECT QuantityOnHand FROM ItemInventory where FullName='Hardware:Lk Doorknobs'

Can also be extracted directly out of the QuickBooks engine in real time like this instead:

sp_report InventoryValuationDetail
show QuantityOnHand 
parameters ItemFilterFullNameWithChildren='Hardware:Lk Doorknobs'
where RowType='TotalRow'