pbeshai Posted March 23, 2006 Share Posted March 23, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/5595-internal-mail-system-infrastructure/ Share on other sites More sharing options...
ober Posted March 23, 2006 Share Posted March 23, 2006 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 Link to comment https://forums.phpfreaks.com/topic/5595-internal-mail-system-infrastructure/#findComment-19951 Share on other sites More sharing options...
pbeshai Posted March 23, 2006 Author Share Posted March 23, 2006 [!--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! Quote Link to comment https://forums.phpfreaks.com/topic/5595-internal-mail-system-infrastructure/#findComment-19975 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.