[SOLVED] MYSQL Table question, which way is more logical/ efficient?

[physaux]

Hey guys, lets say I have about 2500 users,

 

Each User can have say up to 100 "private messages" stored at a time.

 

What is the best way to put this into a table?

 

A-make a table for each user with a messageID

or B- make a table for messages, and just link them to each member

 

Which way would be better?

A- would make LOTS of tables

B- each query would access LOTS more messages than it needs to, and have to search through all of it for each user.

 

Or is there a better choice C?

 

Thanks!

[JAY6390]

Make a single table, with the following

sender_id
receiver_id
title
message
timestamp?

creating tables will get ridiculous for it

[physaux]

Hmm I see.

no offense, I just want a couple more people's opinions before i put it to "solved", but thanks!

[JAY6390]

No problem and none taken I doubt anyone else would agree with creating individual tables for it though 

[lemmin]

Definitely use two tables; one for users and one for messages (like JAY6390 said). Just relate the sender_id and receiver_ids to the user ids.