Have you ever seen a mob at a store fighting for the last 70% off Blu-ray player ? Have you wondered what is like if they were shopping in your e-commerce site instead? In today's post I discuss inventory contention.
In contrast with other tables where each shopper keeps its own data (Orders, Addresses, etc), inventory is shared. While a shopper is updating inventory for a SKU, other shoppers trying to get the same product will need to wait. If the product is popular enough, several shoppers will be waiting to update inventory. The... [Continue Reading]