Re: PhP database design question


<chris.withers@xxxxxxxxx> wrote in message
news:1143627975.829456.318230@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Conceptual, Logical, and Physical views of data
    ... >> David Cressey wrote: ... >>> the problem itself from a feature of some imaginary soultion to the ... the difference between analysis and design. ... >>> DBMS class independent. ...
    (comp.databases.theory)
  • Re: What do programmers do?
    ... I know the software development cycle looks something like ... no authority to change the design based on feedback from their code, ... My typical week starts by asking the people who use my program what feature ... Then I convert the requirement into a set of goals. ...
    (comp.programming)
  • Re: Conceptual, Logical, and Physical views of data
    ... >> the problem itself from a feature of some imaginary soultion to the ... the difference between analysis and design. ... The logical model should be DBMS independent... ... or the relational data model. ...
    (comp.databases.theory)
  • Re: Whut I dew?
    ... poor design. ... There is a similar "feature" in Project which, ... > Well, I suspect that if your problem was related to AutoCorrect, ... if they'd implemented it with some kind of granular control ...
    (comp.databases.ms-access)
  • Re: IC redux
    ... then how is it possible for that feature to ... >As far as evolution goes, ... >"scaffolding" and then take it away. ... For example, if we think a bit about a "complex design", we ...
    (talk.origins)