Re: 2 million row database from hell! help a newbie in over his head.

I think so. The grain is the specified frequency for the popular query. I'm a bit confused by Mikito's writing though. I understand materialized views, although I believe the original post referred to MySQL. AFAIK, materialized views are not an option in that DBMS. I was simply trying to point out that the materialized view is not available in all DBMS. Possibly, a simple solution to improve performance is to create aggregate tables that answer popular queries - the concept is simple. Transfer the work of performing the aggregate to off-peak time. Granted, data is aged using this technique, but I have found it to be quite acceptable in may instances.

Regards,

Carl

"David Cressey" <david_at_dcressey.com> wrote in message news:ODsh7.308$Iw2.21893_at_petpeeve.ziplink.net...
> Carl,
>
> > not what I was talking about though. I was suggesting an aggregate
 table(s)
> > to contain popular report data. We have used this quite a bit to
 transfer
> > the load of performing popular aggregates to off peak hours.
> >
>
> This sounds quite a bit like what Kimball calls "declaring the grain". Am
 I
> reading you correctly?
>
>
> --
> Regards,
> David Cressey
> www.dcressey.com
>
>
Received on Sat Aug 25 2001 - 07:34:14 CEST