I'm working on a case where the potential customer has asked to show that DW stil runs smooth with around 4 million products.
I'did a little test with some bogus data, and imported almost 1 million products.
I notice that the "All Products" overview is still quite snappy, but that browsing the channel group (into which I imported the products) is much slower.
Why is this, and can I do anything about it?