Hi Sohail, In my previous mail, I mentioned about storing categories as separate record. You should store and index Category name, MainProduct name as separate record. Index ChildProduct name, MainProduct as separate record.
When you want the count, 1. Retrieve the main product name matching the category 2. Retrieve the list of child products matching the main product You may need to two query but it is worth. You don't need to delete and bunch of records. Regards Aditya www.findbestopensource.com On Tue, May 22, 2012 at 5:12 PM, Sohail Aboobaker <sabooba...@gmail.com>wrote: > We are still in design phase, so we haven't hit any performance issues. We > do not want to discover performance issues too late during QA :) We would > rather account for any issues during the design phase. > > The refresh rate on fields that we are using from master table will be > rare. May be three or four times in a year. > > Regards, > Sohail >
