DB Design of GMail: Multiple tables vs. one table?

From: <joeserel_at_gmail.com>
Date: 1 Apr 2005 12:35:40 -0800
Message-ID: <1112387740.634841.173710_at_z14g2000cwz.googlegroups.com>



Greetings,

I want to start an interesting topic about the DB design behind gmail:

Since the mail box is 1G, there must be a cluster of servers provides gmail service. One server, suppose it has 500G hard drive, may support 500 persons. How do you think google design DB? 500 tables for each user? (mail1, mail2, ...mail500) or one big table mail hold them all?

What is the performance difference between these two choice?

Thanks,

Joe Received on Fri Apr 01 2005 - 22:35:40 CEST

Original text of this message