Wow, I didn't know that can happen. I'll definitely take that into
consideration. Thanks Brent.
On Aug 7, 2006, at 4:26 PM, Brent Baisley wrote:
If you're looking to be put at ease, I've got a table with 250+
million records, but I've heard of people with larger tables than
that on this list.
You might want to also looking into using a compound primary key,
meaning userid+messageid.
Something like this:
CREATE TABLE `message` (
`userid` int unsigned NOT NULL default '',
`messageid` int unsigned NOT NULL auto_increment,
`message` text,
...
PRIMARY KEY (`userid`,`messageid`)
)
What that does is give each user their own incrementing message
id. Then you can do things like allow users to enter a message id
directly with a number that would be easy for them to remember.
Just an idea.
----- Original Message ----- From: "James Tu" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Monday, August 07, 2006 4:11 PM
Subject: Re: Database design question
Thanks everyone.
Now I feel confident that one table will be fine (Tripp's stat of
30 million records put me at ease :) ).
Cheers,
-James
On Aug 7, 2006, at 4:08 PM, John Meyer wrote:
One table,
USERS
Another table
MESSAGES
With a foreign key referencing users.
Maybe a second foreign key referencing the destinating user as well.
-----Original Message-----
From: James Tu [mailto:[EMAIL PROTECTED]
Sent: Monday, August 07, 2006 1:56 PM
To: mysql@lists.mysql.com
Subject: Database design question
I want to design a database for lots of users. Each user will
be managing
their own messages. Does it make sense to create a table for
each user
after they've registered?
Or should I just create one MESSAGES table and store messages
there keyed
off of their user_id?
If I create a table for each user (I can potentially have
hundreds of
thousands of users), will MySQL be able to handle this?
If I just have one table, I could potentially have millions of
records in
one table. Will MySQL be able to handle this?
My gut feel is that MySQL will be fine with one table and
millions of
records.
Thanks.
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]