Jump to content


Photo

Internal Mail System Infrastructure


  • Please log in to reply
2 replies to this topic

#1 pbeshai

pbeshai
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 23 March 2006 - 02:25 PM

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.

#2 ober

ober
  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 23 March 2006 - 02:27 PM

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.

Info: PHP Manual


#3 pbeshai

pbeshai
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 23 March 2006 - 03:16 PM

[!--quoteo(post=357598:date=Mar 23 2006, 09:27 AM:name=ober)--][div class=\'quotetop\']QUOTE(ober @ Mar 23 2006, 09:27 AM) View Post[/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!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users