|
|
Posted by J2be on 03/29/06 14:07
<chris.withers@gmail.com> wrote in message
news:1143627975.829456.318230@t31g2000cwb.googlegroups.com...
>I have built a web portal and was considering adding a 'user mail'
> feature for users to message each other. I'm a bit uncertain on how to
> design the DB, so was wondering if there is a standard to do this. I
> was figuring perhaps a table storing all user messages (but this might
> become very large very fast?) or would a seperate db storing
> sent/saved/recieved etc messages be better?
Yes, a separate Table for messages sent,saved,received could give better
results
than a whole table with all the messages, expecially with tons of users'
messages.
If users messages are really more than expected think about upgrading
hardware and doing load balancing.
Regards
--
Leonardo Armando Iarrusso - J2Be
www: http://www.J2be.com - e-mail: info[at]J2Be.com
Navigation:
[Reply to this message]
|