Thanks a lot for your time & reply. We are at a very early stages of finalizing the HW & SW design of our product. So it is completely in our hands to design the solution in a way it works the best in terms of performance . I needed these inputs to decide how to design our DB solution & think that your inputs will help me in doing so.