Re: DB Design of GMail: Multiple tables vs. one table?
From: <joeserel_at_gmail.com>
Date: 3 Apr 2005 22:14:03 -0700
Message-ID: <1112591643.526102.222840_at_z14g2000cwz.googlegroups.com>
Date: 3 Apr 2005 22:14:03 -0700
Message-ID: <1112591643.526102.222840_at_z14g2000cwz.googlegroups.com>
I see your point.
My problems are (1) I need to convert historic data to the new system. The historical data are like 2000+ messages for each user.(2) The users will use the system frequently so the scalability requirement is to be able to efficiently access the mail box for 5000 messages/user.
So now you understand why I am so focused on that multiple table vs. signle table choice ... I just thought by looking at DB design of web mail systems, I can make the right choice. I don't have a lot of large scale DB experience: I don't know if it will be efficient to access a 10-million row table if we index on userId. Received on Mon Apr 04 2005 - 07:14:03 CEST
