Re: Performance

[Perrin Harkins]

On Tue, Apr 22, 2008 at 11:41 AM, Bruno B.  B.  Magalhães
<brunomagalhaes@stripped> wrote:
> I thing
> the most problematic part of those queries are the date range part, should I
> use a different index only for this column to maintain the index small?

My experience with doing data warehousing in MySQL was that when all
you need is day granularity, you are much better off having a
de-normalized 'days_since_epoch' column or a date dimension table with
a column like that.  Then your date math becomes simple integer
comparisons which are much faster.

- Perrin