Cal Evans wrote:
Always start with a *fully* normalized design. You can always denormalize for speed but it's real hard to normalize once you are in production.I'd rather be 'stupid' about how normalized my data is and then write caching into my program (or use MySQL 4's query cache, which I don't have yet) than have to extract data properly after the fact for normalization.
Reading any old website about normalization will say basically the same thing (and if they don't, they shouldn't be writing about normalization).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
