Sudhir: do yourself a favr and split the blobs (=body) off to a different table. Most fo the time bodies are not used, only when the actual email needs to be shown. That means that you can keep the frequently used fields together in a table for much quicker access.
cheers, Walter On Mon, Nov 2, 2009 at 17:49, || Sudhir Nimavat || <sudhir_nima...@yahoo.com> wrote: > 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, although I do not always like being > taught > > > > > ----- Forwarded Message ---- > From: "sudhir543-nima...@yahoo.com" <sudhir543-nima...@yahoo.com> > To: Jay Ess <li...@netrogenic.com> > 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. > > 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, although I do not always like being > taught > > > > > > ________________________________ > From: Jay Ess <li...@netrogenic.com> > Cc: Mysql <mysql@lists.mysql.com> > Sent: Mon, 2 November, 2009 3:04:36 PM > Subject: Re: 50M records each year, help me choosing the stretegy > > 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 that bad if you only store a couple of bytes in every row. > So please describe your tables in more detail. > And also describe the expected access on the data. > > -- MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=sudhir543-nima...@yahoo.com > > > ________________________________ > Yahoo! India has a new look. Take a sneak peek. > > > Keep up with people you care about with Yahoo! India Mail. Learn how. > http://in.overview.mail.yahoo.com/connectmore -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
