I'm planning to use catalog price rules in a b2b website having huge number of products. Catalog (book store) contains 5M+ products.
Backend system is using discount matrix which need to be transformed to Magento pricing. I'm planning to use catalog price rules in the implementation.
1)
Is catalog price rules recommended approach to implement discount matrix?
2)
There will be max. 5 catalog price rules affecting single category or product.
Total number of catalog price rules will be 100+ since backend system will create own rule for each category.
Due huge number of products, I'm wondering can catalog price rues be used without performance issues?