Re: webmail user mailbox schema design?
Date: Fri, 1 May 2009 09:24:01 -0700 (PDT)
Message-ID: <83c939cd-3bbf-4264-af3c-3da65a19c27f_at_j9g2000prh.googlegroups.com>
On May 1, 12:06 pm, meranayag..._at_yahoo.com wrote:
> Hi Folks,
> Does anyone have any insight into what user mailbox stores look like
> for yahoo, gmail, hotmail, etc? I am curious if they have, e.g. a
> mailbox table for each user that contains all their email or whether
> they have a single large table with email for all users or whether
> they have a smaller subset of tables with the users distributed
> between them? Each user can have a large number of messages, so a
> single table would end up having billions of records (for one of these
> webmail systems with millions of users) and likewise you wouldn't want
> separate tables for each user because then you'd have millions of
> tables. Any thoughts? Thanks.
> Sean
A separate mail box table for each user? Yikes ...
Why don't you start with a proposed ERD for this type of application? What are the entities involved? What kind of relationships between the entities? Received on Fri May 01 2009 - 18:24:01 CEST