Let me give you the use case.
I need to build this b2b commerce where the prices for each product is different for every logged in customer. One of the functionalities is, the customer should be able to filter and sort the list of products by price.
From what I've read so far, storing the prices into the product index could be quite a performance penalty.
Generally speaking in the context of a e-commerce site and especially with price scenarios like the one I mentioned before or discounts per customer etc where the data shouldn't be in the same index is quite difficult and honestly I couldn't find much around the internet.
How would you go about this on how I should tackle this kind of scenarios? I would appreciate a hint on this.