Re: webmail user mailbox schema design?
Date: Fri, 1 May 2009 09:30:04 -0700 (PDT)
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.
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