I am testing magento for a project. One of the requirements is that each customer can view only products uniquely related to them. The way I am currently doing this is by creating a customer group for each customer and using an extension that allows you to show products only to designated customer groups. For example: a customer logs in and is taken to a category page that contains products that are unique to them and no one else can see.
We will probably have several thousand customers with their corresponding customer group. Every time I customer group is added the product price table needs reindexed. I’ve tested the DB with up to 3500 customer groups, but any more than this and that many customer groups causes mysql to hang on the reindexing process. I’ve researched this and that is because each customer group can have their own price structure so the database needs to reindex to allow for the possible prices for each customer group. We have about a thousand products so multiply that by however many thousand customer groups and you can see why mysql is having trouble processing it.
Any ideas on the fixing the indexing issue, or is there a better work around that doesn’t require having a customer group?