Re: webmail user mailbox schema design?

From: ddf <oratune_at_msn.com>
Date: Fri, 1 May 2009 09:30:04 -0700 (PDT)
Message-ID: <167af7af-981a-4a42-803d-549c330508b3_at_x31g2000prc.googlegroups.com>


On May 1, 11:06 am, 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

Have you considered using a single, partitioned table for your messages? It's likely you'll have an ACCOUNTS Received on Fri May 01 2009 - 18:30:04 CEST

Original text of this message