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