ishna Chandra Prajapati
To: || Sudhir Nimavat ||
Cc: Mysql
Sent: Tue, 3 November, 2009 10:41:57 AM
Subject: Re: 50M records each year.. how to handle
Hi Sudhir,
I am handling 50M record each day. Your requirement can be easily full filled
using partition and good architecture.
Thanks,
Krishna
O
Its a very simple table that will store messages.
Each message would have subject, body,to_user_id,
from_user_id,is_deleted,date_sent and may be one or two more column
There would be frequent read operation and slow write operation.
Thanks
SN
Personally I'm always ready to learn, alt
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 engin