I have 7000+ simple product (inside cca 1300 grouped products and 110+ categories and many of products are in 2-6 categories).
EVERY of that simple product must have its own price based on customer role. If I use tier pricing and set price in that way... will this slow down searching, browsing, ...
I have 6 different roles that needs to have different prices. That means I'll have 6*7000+ = 42000+ records for tier pricing only + normal tier pricing for some products.
I dont know how tier pricing is handeled in searching across whole site so I'm asking will this king of tier price usage slow web.
Another approach would be to extend product table with 5 more prices and then also change all business logic. But this is expensive approach :) but it will be necessary if tier pricing will slow down site.
Thank you in advance.