On Mon, 27 Jul 2009, CityDev wrote: > Over the intervening years I can't ever remember denormalising data (even > when dealing with eg 13 million insurance customers in a table). Is it OK > nowadays to say always aim to be fully normalised - modern RDBMSs are > usually powerful enough to cope with most anything?
My opinion: _always_ go for 4th normal form. I believe that it was both less robust RDBMSs and less powerful hardware that would justify denormalizing for speed on rare occasions. Rich -- Richard B. Shepard, Ph.D. | Integrity Credibility Applied Ecosystem Services, Inc. | Innovation <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users