My client (an overstock chain) expects to have an average of 10-20K items in inventory with a high amount of product turnover so my inventory will be constantly changing. If items are not truly deleted from my inventory table then I will rapidly build up hundreds of thousands of deleted items.
How do I permanently delete an item from inventory? Since you can filter by deleted=true you are clearly not really deleting.
What is the best way to optimize a large, constantly changing inventory?