> Normalizing the database will reduce the size of the database
> and help ensure that the data is clean and consistent. But if
> you're concerned with performance, typically you would
> "de-normalize" the database.
I feel compelled to point out that denormalization doesn't always provide
better performance - and doesn't even usually provide better performance for
most OLTP applications. It generally provides better performance for
reporting, but unless reporting is the primary purpose of your application,
you're usually much better off with a fully normalized database.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
