At 2:11pm -0400 on Tue, 26 Aug 2008, John Smith wrote: > So how bad is this? The mentioned query will be the query which is used > the most in my application (yes, it is going to be a forum). > Should I break normalization and save the date of the root in each node row?
My recommendation is no. Normalization is a Good Thing, and you'll be hard-pressed to convince me otherwise. In the long run, you (or following programmers) will thank yourself if you maintain a normalized core data model. Seriously. But speed and performance are the here-and-now issues while DB technology "catches up" to demands. Have you looked at temporary tables or materialized views? These might help you in this endeavor. Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
