Thanks to all for all the valuable suggestions. I will primarily work on: 1:Using MySql federated or cluster to spread data across servers. 2: Developing application logic to spread the data and retreive it. 3: Hibernate Shards (thanks Nigel) to do the same. I will tell the list how each perform, pros and cons. Thanks Sandeep On 3/29/07, Nigel Thomas <nigel_cl_thomas@xxxxxxxxx> wrote:
Sadeep Have you looked at Hibernate Shards (http://www.hibernate.org/414.html)?