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

From: Yiorgos Adamopoulos <adamo+news_at_dblab.ece.ntua.gr>
Date: Mon, 4 Apr 2005 10:57:16 +0000 (UTC)
Message-ID: <slrnd527cc.1ngi.adamo+news@ithaca.dbnet.ece.ntua.gr>

On 2005-04-04, joeserel_at_gmail.com <joeserel_at_gmail.com> wrote:
> I am indeed doing my homework right now. I am considering to build a
> message swap system (a web app) so that my 2000 users will be able to
> exchange messages with each other (actually NO email involved - the
> only way they can send/read messages is through our web app. No open
> protocol.). So, for me, it is simple: I am just building a web app
> pretty much like a web mail system so my users can log in and send/read
> messages to each other.

Then why not study forum messaging systems like Slashcode or Squishdot?

> scale DB experience: I don't know if it will be efficient to access a
> 10-million row table if we index on userId.

This is highly depended on the Database software, the hardware it runs on, the Operating System and the Index chosen.

-- 
#include <std/disclaimer.h>

Received on Mon Apr 04 2005 - 05:57:16 CDT