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?
We do not provide a mechanism to permanently delete items. We will just have to assume our operations team has a solid infrastructure capable of handling it :)
I am not currently inclined to assume that. The performance this infrastructure is Abysmal. I've been deleting inventory for the past hour in an attempt to make the Clover performance issues survivable. Clover is clearly not designed to run anything larger than a small pizza shop.
1 Person is following this question.
