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
column
>
> There would be frequent read operation and slow write operation.
>
> Thanks
> SN
>
>
>
>
>
> Personally I'm always ready to learn, although I do not always like being
> taught
>
>
>
>
>
>
> From
learn, although I do not always like being taught
- Forwarded Message
From: "sudhir543-nima...@yahoo.com"
To: Jay Ess
Sent: Mon, 2 November, 2009 3:34:52 PM
Subject: Re: 50M records each year, help me choosing the stretegy
Its a very simple table that will store messages
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
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.
Thanks
SN
Sudhir NimavatSenior software engineer
