Re: Newbie database question - Eric Fitzgerald - com.mysql.lists.mysql

4 messages in com.mysql.lists.mysqlRe: Newbie database question

From	Sent On	Attachments
valerio	13 Dec 2000 08:39
Gerald L. Clark	13 Dec 2000 09:08
Randy Johnson	13 Dec 2000 09:29
Eric Fitzgerald	13 Dec 2000 10:01

Subject:	Re: Newbie database question
From:	Eric Fitzgerald (er...@amntv.com)
Date:	12/13/2000 10:01:40 AM
List:	com.mysql.lists.mysql

I wouldn't use the username to tie the tables, as a text lookup is slower than a straight numerical lookup. I would have an auto incrementing userid field inside the authentication table. Use that as primary key there, and inside the contact info have that number for primary key to link the two together. 1 million users would easilly be handled with a regular int field.

I have a question. Iam just starting to deal with databases and won't take the actual class till next semester before I graduate.

If I have a site that has 1 million users

would it be faster to have a table with all the contact info and username in it and have another table with username and password in it to speed up user authentication and use the username as primary keys to tie the two tables together?

thanks

randy

--------------------------------------------------------------------- Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail mysq...@lists.mysql.com

To unsubscribe, send a message to: <mysql-unsubscribe-eric=amnt...@lists.mysql.com>

If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php