Re: Re: Where to start!
| From: | Richard Heyes | Date: | Mon, 05 May 2008 10:10:52 +0000 |
| Subject: | Re: Re: Where to start! | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-273881@lists.php.net to get a copy of this message | ||
Tony Marston wrote:
"Richard Heyes" <richardh@phpguru.org> wrote in message news:481ED03B.7090200@phpguru.org...Sometimes it's just a waste of time. If your site isn't that busy, and speed isn't crucial, why waste the time using a more complicated database structure? -- Richard Heyes +----------------------------------------+ | Access SSH with a Windows mapped drive | | http://www.phpguru.org/sftpdrive | +----------------------------------------+I disagree. The database should ALWAYS be normalised to at least the 3rd normal form. Sometimes going beyond that to 4NF, 5NF or 6NF becomes too complex.The database must be properly normalised otherwise it will be difficult to get at the data you need in an efficient manner.Not true. If your needs are simple for example, normalisation can increase the complexity of a schema, hence increasing development time needed. Sometimes for example you could use something like a SET type, and search for something in it using FIND_IN_SET().