Re: Normalization vs. Performance

2008-08-29 Thread Arthur Fuller
sage- > >From: Kevin Hunter [mailto:[EMAIL PROTECTED] > >Sent: Thursday, August 28, 2008 10:59 PM > >To: John Smith > >Cc: MySQL General List > >Subject: Re: Normalization vs. Performance > > > >At 2:11pm -0400 on Tue, 26 Aug 2008, John Smith wrote: >

RE: Normalization vs. Performance

2008-08-29 Thread Jerry Schwartz
>-Original Message- >From: Kevin Hunter [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 28, 2008 10:59 PM >To: John Smith >Cc: MySQL General List >Subject: Re: Normalization vs. Performance > >At 2:11pm -0400 on Tue, 26 Aug 2008, John Smith wrote: >> So

Re: Normalization vs. Performance

2008-08-29 Thread Martijn Tonies
> > 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 >

Re: Normalization vs. Performance

2008-08-28 Thread Kevin Hunter
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. N