MySQL Server - CRE Loaded - 150-250 Customer Groups - Server Hangs
Posted on 2010-11-10
We have a customer that has custom pricing for each customer at the product level.
We decided to program a way for each customer to be their own Customer Group.
There are 2000 products, and about 200 Customers.
So that's 400,000 records in the Customer Groups Pricing data table.
When we go to browse the site after loading this data, the site hangs.
It's obvious that this quantity of data is the cause.
Does anyone have some suggestions on a way to better handle this situation?
Would rebuilding indexes help?
Reduce the data amount so only *different from retail* prices are imported?
Any suggestions would be most appreciated.