It currently takes about 30 minutes to calculate and store inventory snapshot data (for a OB instance that has lots of products and locations). We should be able to improve both the query time for the calculation as well as writing records to the tables.

• Implement inventory summary table to provide up-to-date snapshot of QoH for all items in the system
• Use inventory summary table in places where on-demand computed QoH was being used
• Validate inventory summary table against on-demand computed QoH
• Validate
• Improve performance of megamenu (outbound, inbound shipments)
• Improve time to save records to inventory summary and inventory snapshot tables
• Merge inventory snapshot and inventory item snapshot table
• Add worker queue / parallel computing (Gpars) to improve performance of the QoH calculation
• Add worker queue / parallel computing (Gpars) for populating inventory snapshot tables to compute
• Consider using secondary caching store (redis) for QoH summary
• Replace all inventory transactions with a correspondng adjustment transaction #165 Replace all inventory transactions with adjustment transactions
• Allow system admin to configure which method to use when pulling aggregate QoH data (i.e. summary, snapshot, calculate).