RE: 50M records each year, help me choosing the stretegy

2009-11-02 Thread Daevid Vincent
Sudhir, please remove the || from your name in your email: "|| Sudhir Nimavat ||" We have about 1 BILLION rows of data here and we do a few tricks which may or may not be of interest to you. For starters, setup replication and write to a master and have at least 2 slaves. This makes backups MUCH

Re: 50M records each year, help me choosing the stretegy

2009-11-02 Thread Jay Ess
sudhir543-nima...@yahoo.com wrote: I have come across a requirement where I need to store a very large amount of data in a table. In one of our app.. we can have around 50 Million records each year.. Can any one guide me in choosing a strategy than can handle this load. 50M records is not th