Re: [PHP] Re: Where to start!
[email protected] (Richard Heyes)
| Newsgroups | php.general |
|---|---|
| Message-ID | <[email protected]> |
Tony Marston wrote: > "Richard Heyes" <[email protected]> wrote in message > news:[email protected]... >>> 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(). > > 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. 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 | +----------------------------------------+