Jump to content

Archived

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

pbeshai

Internal Mail System Infrastructure

Recommended Posts

Hi, this is more of a MySQL centered problem.

I would like to set up an internal mail system on my web site, so that members have an inbox and can send "mail" to each other.

Is it better to have 1 giant mail table that stores all messages (and you call up the inbox by selecting all with recipient as username x) or to give each user their own table?

I'm leaning towards the first, but I really have no idea which one is more suitable.

Share this post


Link to post
Share on other sites
Using one giant table for all mail would be the preferred method. Setting up tables for each user is both inefficient and poor database design.

Share this post


Link to post
Share on other sites
[!--quoteo(post=357598:date=Mar 23 2006, 09:27 AM:name=ober)--][div class=\'quotetop\']QUOTE(ober @ Mar 23 2006, 09:27 AM) [snapback]357598[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Using one giant table for all mail would be the preferred method. Setting up tables for each user is both inefficient and poor database design.
[/quote]

Great. I was worried about that :-) Thanks Ober!

Share this post


Link to post
Share on other sites

×

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.