Re: [GENERAL] flattened tables with normalized tables

2004-10-07 Thread Dennis Gearon
Bruno Wolff III wrote: On Thu, Oct 07, 2004 at 22:35:50 -0600, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Thu, Oct 07, 2004 at 09:08:18PM -0700, Dennis Gearon wrote: About regular views, how does that speed things up, other than the initial SQL interpretation of the view not needing to be done?

Re: [GENERAL] flattened tables with normalized tables

2004-10-07 Thread Bruno Wolff III
On Thu, Oct 07, 2004 at 22:35:50 -0600, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Thu, Oct 07, 2004 at 09:08:18PM -0700, Dennis Gearon wrote: > > > > About regular views, how does that speed things up, other than the initial > > SQL interpretation of the view not needing to be done? > > I d

Re: [GENERAL] flattened tables with normalized tables

2004-10-07 Thread Dennis Gearon
Michael Fuhr wrote: On Thu, Oct 07, 2004 at 09:08:18PM -0700, Dennis Gearon wrote: About regular views, how does that speed things up, other than the initial SQL interpretation of the view not needing to be done? I didn't mean to imply that views would speed things up -- I was merely suggesting t

Re: [GENERAL] flattened tables with normalized tables

2004-10-07 Thread Michael Fuhr
On Thu, Oct 07, 2004 at 09:08:18PM -0700, Dennis Gearon wrote: > > About regular views, how does that speed things up, other than the initial > SQL interpretation of the view not needing to be done? I didn't mean to imply that views would speed things up -- I was merely suggesting them as an alt

Re: [GENERAL] flattened tables with normalized tables

2004-10-07 Thread Dennis Gearon
Michael Fuhr wrote: On Thu, Oct 07, 2004 at 10:07:47AM -0700, Dennis Gearon wrote: If I want to set up a dbase with normalized tables for inserts,and a flattened table for selects, am i going in the right direction for speeding up a busy site? Are you familiar with views? If so, is there a reas

Re: [GENERAL] flattened tables with normalized tables

2004-10-07 Thread Michael Fuhr
On Thu, Oct 07, 2004 at 10:07:47AM -0700, Dennis Gearon wrote: > If I want to set up a dbase with normalized tables for inserts,and a > flattened table for selects, am i going in the right direction for > speeding up a busy site? Are you familiar with views? If so, is there a reason not to use

[GENERAL] flattened tables with normalized tables

2004-10-07 Thread Dennis Gearon
If I want to set up a dbase with normalized tables for inserts,and a flattened table for selects, am i going in the right direction for speeding up a busy site? Also, if some of you are also doing this, how and how often do you do the SELECT from the normalized tables to the flattened table? An