Jump to content

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


physaux

Recommended Posts

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!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.