create new user

redzzzon

Hello

When a person recieves an account with yahoo, hotmail, or g-mail is a NEW DATABASE created for each new user?

if not how is the space created to store e-mails.

thanks tom

devinemke

i don't know the specifics of the data structures of those services but i'm sure they don't create a new database for each user, they simply add new records to existing database tables.

redzzzon

Then it would work like the following to retrive e-mails from a record called emails.

select * from emails where username = '$current_user'.

then the e-mails would be pulled and interfaced to the user.

How in the world is this table index. I hardly believe the recored is searched from first instance and then skips until another email is realated to the current user to be displayed.

Index the e-mail table I imagine is important for quick access. How is this table indexed.

Thanks Tom

devinemke

as with any index, you index the field(s) that are specified in the WHERE clause of your queries. if i were to build an email system, at the very least i would have 2 tables: users, messages. these two tables were relate to each other via a common field. so you would probably want to create an index on the messages table of the field that relates to the users table as that will be your method of grabbing just the records for 1 specific user.

redzzzon

The goal is to build a friends list. I imagine I will have to do the same as with an e-mail system. I am new to database system. Realizing the speed is difficult to grasp. However, as in a large system like yahoo millions of e-mails ar inserted and to query through them is hard to realize. especially that I see twenty headers in a matter of a second. That is why I thought a new database is created for each new member.

Any links to understand these type of structures would be great.
Thanks